How to restore a 64-bit database into a 32-bit instance using a compressed backup

This one seems to baffle some, though like redirected restores, it’s something that is only tough the first few times. If you attempt to restore a 64-bit database on a 32-bit instance using a compressed backup image, you get this scary error message:

SQL2570N  A database cannot be restored on a platform that does not match the
platform on which the backup image was created.
Read the rest Continue reading »

Managing db2 transaction log files

Logging method

There are two methods of logging that DB2 supports: Circular and Archive. I believe Oracle has similar modes.

Circular

To my extreme disgust, the default that Commerce uses if you don’t change anything is Circular logging. Circular logging is more often appropriate for databases where you don’t care about the data (seen it for databases supporting Tivoli and other vendors) or for a Data Warehousing and Decision Support databases where you have extremely well defined data loading processes that can easily be re-done on demand.… Read the rest

Continue reading »

When to Backup your DB2 database

Ok, so there are several good reasons for Backing up your Commerce DB2 database

  1. After Commerce Instance Creation
  2. As required by your overall ongoing backup and recovery strategy
  3. Before a FixPack(DB2 or Commerce) or Feature Pack(Commerce)
  4. After a FixPack(DB2 or Commerce) or Feature Pack(Commerce)
  5. Before any task that requires change of a lot of data – such as first time pruning, explicit executions of delete statements or update/insert statements that will affect more than one table.
Read the rest Continue reading »