Blogs tagged johannes heinrich

If the large table is not already in a separate tablespace option 2 might be the better alternative. Needless to say that both option are ‘workarounds’ to cope with the situation. It would be much better if LRIDs would be enabled on... Read More »

Database and Operating System compose the foundation on which all SAP software is running. We therefore often talk about the (DB-, OS-)’platform’ of an SAP system. Names of database management systems, like names for any product, change... Read More »

Welcome to this last post in the series about new features in DB2 9 andtheir applicability in the SAP environment. Today I’d like to talk about theSelf Tuning Memory Manager (STMM). Also I will mention briefly other interestingDB2 9... Read More »

One of the new features in DB2 version 9 which got a lot of attention is certainly ‘Row Compression’. While compression algorithms are in place already in DB2 before version 9 (for instance backup compression, value compression), row... Read More »

In today’s post I’d like to talk about news regarding the installation procedure of DB2 and a new possibility to generate a script for a ‘redirected restore’ to copy a database. h4. Feature: Script generation for a redirected... Read More »

Feature: Larger Record Identifiers (LRIDs) Record Identifiers (sometimes also called Row Identifiers orRIDs) are used within indexes to address records. You may think ofa RID as ‘pointer’ to the actual table data. If during... Read More »

While the focus of the new Version of DB2 for Unix and Windows (codenamed Viper) is certainly on the native XML capabilities, there are also news for everyone using this database for SAP. Based on the excellent partnership between IBM and SAP,... Read More »