Default language.

Writer instructions

Page title

For most spaces, this page must be titled Space announcements.

For spaces with localized content, this page must be titled Space announcements l10n.

Purpose

Provide an announcement banner on every page of your space.

Location

Move this page outside of your home branch.

Guidelines

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 Stats for Db2 13.1.

Db2 catalog tables

For specific tables in the Db2 catalog, this topic lists the columns that BMC AMI Stats can update. BMC AMI Stats can update some or all of them, depending on the options that you select. In many instance BMC AMI Stats inserts a row which includes all columns.

Only the relevant statistics columns are shown.

Important

For information about updates that BMC AMI Utilities make to real-time statistics (RTS) tables, see Db2-Real-Time-Statistics-RTS.

BMC AMI Stats can update columns in the following Db2 catalog tables:


Columns BMC AMI Stats can update in the SYSCOLSTATS table

Column

Description

COLCARDF

Number of distinct column values in the partition

HIGHKEY

Highest column value within the partition

HIGH2KEY

Second-highest column value within the partition

LOWKEY

Lowest column value within the partition

LOW2KEY

Second-lowest column value within the partition

STATS_FORMAT

Type of statistics collected

STATSTIME

Timestamp of the RUNSTATS update

Important

BMC AMI Stats does not update SYSCOLSTATS (column by partition) statistics for the columns of a nonpartitioned index. However, BMC AMI Stats does update SYSCOLUMNSstatistics for the columns of a nonpartitioned index.


Columns BMC AMI Stats can update in the SYSCOLUMNS table

Column

Description

COLCARDF

Number of distinct column values in the column

HIGH2KEY

Second-highest column value in the table

LOW2KEY

Second-lowest column value in the table

STATSTIME

Timestamp of the RUNSTATS update

 

Columns BMC AMI Stats can update in the SYSCOLDISTSTATS table

Column

Description

CARDF

Number of distinct values in the column, group, or frequency

COLGROUPCOLNO

Set of columns associated with the statistics

COLVALUE

The data of the frequently occurring value

TYPE

Type of statistics collected

FREQUENCYF

A value equal to 100 times the percentage of rows containing the data displayed in the COLVALUE column

NUMCOLUMNS

Number of columns in the column group

STATSTIME

Timestamp of the RUNSTATS update

Columns BMC AMI Stats can update in the SYSCOLDIST table

Column

Description

CARDF

Number of distinct values in the column, group, or frequency

COLGROUPCOLNO

Set of columns associated with the statistics

COLVALUE

The data of the frequently occurring value

TYPE

Type of statistics collected

FREQUENCYF

A value equal to 100 times the percentage of rows containing the data displayed in the COLVALUE column

NUMCOLUMNS

Number of columns in the column group

STATSTIME

Timestamp of the RUNSTATS update

Columns BMC AMI Stats can update in the SYSKEYTARGETS table

Column

Description

CARDF

Number of distinct values for the key target

HIGH2KEY

Second-highest column value in the table

LOW2KEY

Second-lowest column value in the table

STATSTIME

Timestamp of the RUNSTATS update

Columns BMC AMI Stats can update in the SYSKEYTGTDIST table

Column

Description

KEYSEQ

Numeric position of the key target in the index

KEYVALUE

The data of the frequently occurring key

CARDF

Number of distinct values in the key group

FREQUENCYF

Percentage of keys with KEYVALUE

STATSTIME

Timestamp of the RUNSTATS update

Columns BMC AMI Stats can update in the SYSTABSTATS table

Column

Description

CARDF

Number of rows in the partition

NPAGES

Number of pages with rows

PCTPAGES

Percentage of active pages with rows

NACTIVE

Number of active pages

STATSTIME

Timestamp of the RUNSTATS update

Columns BMC AMI Stats can update in the SYSTABLES table

Column

Description

CARDF

Number of rows in the table

NPAGES

Number of pages with rows in this table

PCTPAGES

Percentage of active pages with rows

STATSTIME

Timestamp of the RUNSTATS update

Columns BMC AMI Stats can update in the SYSTABLESPACE table

Column

Description

NACTIVEF

Number of active pages in the table space

SPACEF

Kilobytes of DASD storage

STATSTIME

Timestamp of the RUNSTATS update

Columns BMC AMI Stats can update in the SYSINDEXSTATS table

Column

Description

FIRSTKEYCARDF

Number of distinct values of the first key column

FULLKEYCARDF

Number of distinct values of the key

NLEAF

Number of leaf pages in the index

NLEVELS

Number of levels in the index tree

DATAREPEATFACTORF

Anticipated number of pages repeatedly scanned, following index key order

KEYCOUNTF

Total number of rows in the partition

CLUSTERRATIOF

Percentage of rows in clustering order

STATSTIME

Timestamp of the RUNSTATS update

Columns BMC AMI Stats can update in the SYSINDEXES table

Column

Description

CLUSTERRATIOF

Percentage of rows in clustering order

CLUSTERED

Whether the index/table is clustered

This column is set to Y if the value of CLUSTERRATIOF exceeds 94.

FIRSTKEYCARDF

Number of distinct values of the first key column

FULLKEYCARDF

Number of distinct values of the full key

NLEAF

Number of leaf pages in the index

NLEVELS

Number of levels in the index tree

DATAREPEATFACTORF

Anticipated number of pages repeatedly scanned, following index key order

AVGKEYLEN

Average length of keys within the index

SPACEF

Kilobytes of DASD storage

STATSTIME

Timestamp of the RUNSTATS update

Columns BMC AMI Stats can update in the SYSTABLEPART table

Column

Description

CARDF

Number of rows in the table space or partition

DSNUM

Number of data sets

EXTENTS

Number of data set extents

FARINDREF

Number of rows that have been relocated far from their original page

NEARINDREF

Number of rows that have been relocated near their original page

PERCACTIVE

Percentage of space occupied by rows of data from active tables

SECQTYI

Secondary space allocation

SPACEF

Kilobytes of DASD storage

STATSTIME

Timestamp of the RUNSTATS update


Columns BMC AMI Stats can update in the SYSINDEXPART table

Column

Description

AVGKEYLEN

Average length of keys within the index

CARDF

Number of rows in the index or partition

DSNUM

Number of data sets

EXTENTS

Number of data set extents

NEAROFFPOSF

Number of rows near the optimal position

FAROFFPOSF

Number of rows far from the optimal position

LEAFDIST

A value equal to 100 times the average number of leaf pages between successive active leaf pages of the index

LEAFFAR

Number of leaf pages located physically far away from previous leaf pages for successive (active leaf) pages accessed in an index scan

LEAFNEAR

Number of leaf pages located physically near the previous leaf page for successive active leaf pages

SECQTYI

Secondary space allocation

SPACEF

Kilobytes of DASD storage

STATSTIME

Timestamp of the RUNSTATS update

Related topics

RUNSTATS

Common-options-syntax

Example: controlling what BMC AMI Stats writes to the catalog 

SYSIN-statement-syntax 

Overview-of-BMC-AMI-Stats

Getting-started

BMC-statistical-repository-tables

Table-columns-updated-by-BMC-AMI-Stats 




 

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