DB2 Version 10.1 for Linux, UNIX, and Windows

db2cat command output text has changed

The output for the db2cat command no longer includes properties for the table space where the database object is stored.

Details

Due to changes for storage groups in V10.1, the following table space properties are no longer reported by the db2cat command:

TRANSFERRATE
OVERHEAD
WRITETRANSFERRATE
WRITEOVERHEAD
PREFETCHSIZE
EXTENTSIZE
PAGESIZE

The SYSCAT.TABLESPACES catalog view provides the values for all of these table space properties. The EXPLAIN_ARGUMENT table also provides information about the values used by the optimizer for the TRANSFERRATE, OVERHEAD, and PREFETCHSIZE properties.

In previous releases, the db2cat command included table space properties along with the packed descriptor information for tables.

Resolution

To determine the values for the table space properties, first determine the table space where the table or index is stored and then query the SYSCAT.TABLESPACES catalog view for that table space.