Statistics commands
Related topics
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 |