Skip to Content

 

Information
Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Catalog Manager for Db2 13.1.

Statistics commands

Catalog Manager

 can display statistical information from various catalog tables.

To execute a command, type the command in the Cmd column next to an appropriate item on a list. lists the statistics commands.

Command

Description

CATSTATS

Executes the SQL COUNT (*) statement for objects in the DB2 catalog

COLSTATS

Displays statistics from the SYSIBM.SYSCOLSTATS catalog table for the selected table or column

DEST

DESTATISTICS

Displays statistical information and catalog row information for the selected object

DISTSTATS

Displays statistics from the SYSIBM.SYSCOLDIST or SYSIBM.SYSCOLDISTSTATS catalog table for the selected object

HISTORY

Displays statistics from the SYSIBM history tables for the selected object

INDEXSTATS

Displays statistical information from the SYSIBM.SYSINDEXSTATS catalog table for the selected object

PDISTSTATS

Displays statistics from the SYSIBM.SYSCOLDISTSTATS catalog table for the selected object

TABSTATS

Displays statistics from the SYSIBM.SYSTABSTATS catalog table for the selected object

Related topic

Commands

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI Catalog Manager for Db2 12.1