DB2

Home ACSLogo DB2 Links

Finding Tablespaces not copied in n days presents a catalog query which will tell you which tablespaces haven't been copied recently.

Generating commands from the DB2 catalog part 1 looks at using SQL to generate input for utilities and the command processor.

Generating commands from the DB2 catalog part 2 extends part 1 by looking at ways of generating multi-line commands.

Notes on using Template and Listdef new features for utility processing in DB2 V7.

Online Reorg notes discusses online reorg - how it works and how you implement it. The animations and diagrams need the Flash Player from Macromedia.

Problems after adding columns to a table looks at the sort of problems you might get after adding columns to a table, why you might want to do a reorg, and how to identify potential problem tables.

DB2 Books

DB2 Links