Category: Maintenance

0

When to Backup your DB2 database

Ok, so there are several good reasons for Backing up your Commerce DB2 database After Commerce Instance Creation As required by your overall ongoing backup and recovery strategy Before a FixPack(DB2 or Commerce) or Feature Pack(Commerce) After a FixPack(DB2 or Commerce) or Feature Pack(Commerce) Before any task that requires change of a lot of data – such as first time...

0

Never do runstats on volatile tables

Ok, so everyone will tell you that it doesn’t matter if you do runstats on volatile tables. The volatile flag is supposed to tell DB2 that the statistics are absolutely not correct, and heavily bias db2 to use indexes over table scans. Commerce has 8 tables in Commerce 6 (9 in Commerce 7) that are marked as volatile. At least...