January 04, 2011

Changed Catalog Tables in DB2 10

With DB2 10 comes many changes in the catalog. In last week's blog, I wrote about how some tables have been split out into new table spaces, which may have an impact on your catalog utility maintenance jobs such as imagecopy, runstats or reorgs.

This week I would like to focus on 33 catalog tables changed. This includes 59 new columns and 43 changed columns. The column changes include: new column description, new values for the column, changed data types, changed column length, or both changed length and data type.

The following file contains Download 2011-01-04-Changed Catalog Tables in DB2 10 a list of tables with a short description of the new column or changed columns. When possible I tried to include some information that would tell you about the new service being supported with the column change.