About malte_schuenemann

malte_schuenemann

MotivationIn this blog post, I’ll discuss space and performance considerations of large objects (LOBs) in SAP environments on Db2 for Linux, UNIX, and Windows (LUW). You will learn how to address potential issues by configuration and maintenance. Ke...

malte_schuenemann

Storage systems play an important role in database recovery. Given the flexible storage capabilities of Cloud environments, it’s not surprising that database products learn to make use of Cloud features to store backups and database log archives.In t...

malte_schuenemann

If a Db2 logfile is ignored by the rollforward (as in this case), then usually the logfile is not accepted, e.g. due to a corruption. You might want to use the tool db2cklog for a first verification (i.e. run db2cklog CHECK 214489). You can run this ...

malte_schuenemann

If you are on DB2 9.7, you need to use admin_move_table (AMT), instead of online_table_move (OTM). Note that the syntax is slightly different.However, the command line given at the beginning uses a trailing semicolon - how did you call the DB2 CLP th...

malte_schuenemann

Use the ADMIN_GET_TAB_COMPRESS_INFO, and on 9.7 also the ADMIN_GET_INDEX_COMPRESS_INFO table function.Malte

malte_schuenemann

db2dart is an offline tool. This means that if the database is active while db2dart is started, the tool will output such a message. Depending on command line options used, the tool will deny further processing.To check a table's integrity, consider ...

malte_schuenemann

I suspect this is an issue to be followed up by SAP Support. Please open a SAP ticket.Malte

User Statistics

User Activity

LOB Administration in a Db2 LUW database

Db2 Database Recovery and Cloud Object Store

Re: DB2 online restore restore failed

Re: Using ADMIN_TABLE_MOVE or DB6CONV to move VBDATA

Re: Check the compression ratio or percentage achieved for the database

Re: db2dart SAP returns "Inconsistent Database"

Re: DB2 Archive Backup Problem