Reporting for BMC AMI Stats

You can optionally create BMC AMI Stats reports and write them to the RUNSTATS DD.

The BMC AMI utility job generates the ROLLUP REPORT in the RUNSTATS output for the following jobs:

REORG with a part specification and +ROLLUP(YES)
REORG on entire tablespace with +ROLLUP(YES) or +ROLLUP(NO)
NGTSTATS on a partitioned tablespace run with +ROLLUP(YES) or +ROLLUP(NO)
LOAD REPLACE or LOAD RESUME YES job for a partitioned tablespace with +ROLLUP(YES) or +ROLLUP(NO)
LOAD RESUME NO PART N REPLACE job for a partitioned tablespace with +ROLLUP(YES)

NGTSTATS OPTIONS

The NGTSTATS options section presents a report of the options that you defined.

14:26:00.22 B001.ST90OPTS CDBS003 -NGTSTATS OPTIONS -REPORT = YES, UPDATE = ALL, HISTORY = NON
14:26:00.22 B001.ST90OPTS CDBS003 -NGTSTATS OPTIONS -COLUMNS (ALL)KEYCARD NUMCOLS(3) MOST + LEAST 2

OBJECT SPACE REPORT

The OBJECT SPACE report provides allocation and usage statistics related to the two-partition table space:

OBJECT SPACE REPORT              PHYS LOGL                  TTL        ALLOCATED      USED SPACE   PG   NO.   NO.
DBNAME    SPCNAME    OBID PSID PART PART TYPE CX? I/J PTNS    (# 4K PAGES)    (# 4K PAGES)   SZ XTNT DSET
-------- --------   ---- ---- ---- ---- ---- --- --- ---- -------------- -------------- --- ---- ----
DBASE001 TSPART02   000A 000B     1     1 PTTS        I      2              36              22   4K     1     1
DBASE001 TSPART02                  2     2              I      2              36              22   4K     1     1
DBASE001 TSPART02                                           TOTS              72              44

DBASE001 PARTIX01   000D 0012     1     1   PIX CLX   I      2              12               7          1     1
DBASE001 PARTIX01                  2     2              I      2              12               7          1     1
DBASE001 PARTIX01                                           TOTS              24              14

DBASE001 NPSI0002   0013 0014               NPI        I                     12               6
DBASE001 DPSI0003   0015 0016     1     1 DPSI        I      2              12               5          1     1
DBASE001 DPSI0003                  2     2              I      2              12               5          1     1
DBASE001 DPSI0003                                           TOTS              24              10


        TOTALS                                                                132              74

NGTSTATS TS REPORT

The NGTSTATS TS report presents a summary of all table space statistics:

NGTSTATS TS REPORT                                   PCT               PCT                       VSAM       VSAM
DBNAME    SPCNAME   PART         CARD(F)    NACTIVE   ACT     NPAGES    PGS        SPACE(F)       PQTY       SQTY
-------- -------- ---- -------------- --------- ---- ---------   ---- -------------- --------- ---------
DBASE001 TSPART02     1             500         22    61         20     91             144         36        180
DBASE001 TSPART02     2             500         22    61         20     91             144         36        180
TOTALS                             1,000         44               40     91             288

SYSTABLEPART CATALOG STATISTICS report

The SYSTABLEPART catalog statistics report shows various catalog statistics for the table space:

SYSTABLEPART CATALOG STATISTICS FOR DBASE001.TSPART02 PARTITION 1

         CARD(F)            = 500
         PERCACTIVE         = 61
         SPACE(F)           = 144
         VSAM PQTY          = 36
         VSAM SQTY          = 180
         DSNUM              = 1
         EXTENTS            = 1

SYSTABSTATS FOR TABLE - CDBUSER.TEST_TS0040_TBL0 PARTITION     1
         CARD(F)            = 500
         NPAGES             = 20
         PCTPAGES           = 91
         NACTIVE            = 22
SYSTABLEPART CATALOG STATISTICS FOR DBASE001.TSPART02 PARTITION 2

         CARD(F)            = 500
         PERCACTIVE         = 61
         SPACE(F)           = 144
         VSAM PQTY          = 36
         VSAM SQTY          = 180
         DSNUM              = 1
         EXTENTS            = 1

SYSTABSTATS FOR TABLE - CDBUSER.TEST_TS0040_TBL0 PARTITION     2
         CARD(F)            = 500
         NPAGES             = 20
         PCTPAGES           = 91
         NACTIVE            = 22
SYSTABLES STATISTICS FOR TABLE - CDBUSER.TEST_TS0040_TBL0
         CARD(F)            = 1,000
         NPAGES             = 40
         PCTPAGES           = 91
         SPACE              = 288

SYSTABLESPACE CATALOG STATISTICS FOR DBASE001.TSPART02
         NACTIVE            = 44
         SPACE              = 288
---------------------------------------------------------

Index report

The index report reports on each index, and each partition of partitioned indexes and partitioned table spaces:

INDEX = CDBUSER.PARTIX01
IXDSN = BI12V90V.DSNDBC.DBASE001.PARTIX01.I0001.A001      KEYLEN =13           2 KCOLS
##################### PARTITION     1 #####################
                                                   N A F     COL   INDEX   F C    TBL
COLUMN NAME                              TYPE      L D V LENGTH   OFFST   Q # COLNO
---------------------------------------- -------- - - - ------   -----   - - -----
COL01                                    INTEGER     A F       4       0            1
COL02                                    CHAR        A F       9       4   Q        2

NON-UNIQUE, CLUSTERING PARTITIONED INDEX -- TS IS PBRANGE --

INDEXSPACE DBASE001.PARTIX01 (1)   2 IX COLUMNS, TS = DBASE001.TSPART02
     KEYS = 500 , FIRSTKEYS = 500 , TOTAL RIDS = 500

The index report uses codes for some of its headings, as follows:

Index report columns

Code	Description
NL	Indicates whether the specified index column accepts null entries (showing N if the index column allows null entries, or a blank if nulls are not allowed).
AD	Indicates whether the index column is ascending (A) or descending (D) or an Include column (I)
FV	Indicates whether the index column is fixed (F) or variable (V)
FQ	Shows the Frequency Numcols
C#	Shows the column groups where cardinality statistics are collected

SYSINDEXPART CATALOG STATISTICS report

The SYSINDEXPART catalog statistics report provides index statistics for each partition of the index:

SYSINDEXPART CATALOG STATISTICS FOR DBASE001.PARTIX01   PARTITION 1

    CARD(F) = #ROWS = 500
        NEAROFFPOSS = 22
         FAROFFPOSS = 0
           LEAFDIST = 1
           LEAFNEAR = 1
           LEAFFAR = 0
             SPACE = 48
           EXTENTS = 1
          DATASETS = 1
         VSAM PQTY = 12
         VSAM SQTY = 180
       AVGKEYLENGTH = 13
SYSINDEXSTATS CATALOG STATISTICS FOR DBASE001.PARTIX01   PARTITION 1

     FULLKEYCARD(F) = 500
    FIRSTKEYCARD(F) = 500
KEYCOUNT(F) = #ROWS = 500
    CLUSTERRATIO(F) = 100.0
   DATAREPEATFACTOR = 1
           NLEAF    = 3
           NTREE    = 1
           NLEVELS = 2

SYSCOLSTATS CATALOG STATISTICS FOR COL01
          COLCARDF   = 500

          LOWKEY     = 80000001                                      Ø
          LOW2KEY    = 80000002                                      Ø
          HIGH2KEY   = 800001F3                                      Ø 3
          HIGHKEY    = 800001F4                                      Ø 4
SYSCOLSTATS CATALOG STATISTICS FOR COL02
          COLCARDF   = 1

          LOWKEY     = C1D3D7C8C1 40404040                           ALPHA
          LOW2KEY    = C1D3D7C8C1 40404040                           ALPHA
          HIGH2KEY   = C1D3D7C8C1 40404040                           ALPHA
          HIGHKEY    = C1D3D7C8C1 40404040                           ALPHA

  SYSCOLDISTSTATS FREQ (1) FOR COL01,COL02
      TOTAL ROWS = 500 , 2 MOST FREQUENT KEYS

    COUNT       PCT    COLVALUE (HEX)                                (CHAR)
    -----     -----    --------                                      -----------

        1      0.20    80000001C1 D3D7C8C140 404040                  Ø   ALPHA
        1      0.20    80000002C1 D3D7C8C140 404040                  Ø   ALPHA

      TOTAL ROWS = 500 , 2 LEAST FREQUENT KEYS
    COUNT       PCT    COLVALUE
    -----       ---    --------

        1      0.20    80000002C1 D3D7C8C140 404040                  Ø   ALPHA
        1      0.20    80000001C1 D3D7C8C140 404040                  Ø   ALPHA
----------------------------------------------------------------------------

ROLLUP DATA report

The final section provides a report of rollup data:

****************************************************************************
*                                   ROLLUP DATA
****************************************************************************

NON-UNIQUE, CLUSTERING PARTITIONED INDEX -- TS IS PBRANGE --

INDEXSPACE DBASE001.PARTIX01 (0)   2 IX COLUMNS, TS = DBASE001.TSPART02
     KEYS = 1,000 , FIRSTKEYS = 1,000 , TOTAL RIDS = 1,000

SYSINDEXES CATALOG STATISTICS FOR DBASE001.PARTIX01

     FULLKEYCARD(F) = 1,000
    FIRSTKEYCARD(F) = 1,000
          CLUSTERED = Y
    CLUSTERRATIO(F) = 100.0
   DATAREPEATFACTOR = 477
       AVGKEYLENGTH = 13
           NLEAF    = 6
           NTREE    = 1
           NLEVELS = 2
             SPACE = 96

SYSCOLUMNS STATS FOR COL01
          COLCARDF   = 1,000

          LOWKEY     = 80000001                                      Ø
          LOW2KEY    = 80000002                                      Ø
          HIGH2KEY   = 800003E7                                      Ø X
          HIGHKEY    = 800003E8                                      Ø Y

SYSCOLUMNS STATS FOR COL02
          COLCARDF   = 66,039,011,955

          LOWKEY     = C1D3D7C8C1 40404040                           ALPHA
          LOW2KEY    = C1D3D7C8C1 40404040                           ALPHA
          HIGH2KEY   = C1D3D7C8C1 40404040                           ALPHA
          HIGHKEY    = C1D3D7C8C1 40404040                           ALPHA

SYSCOLDIST STATS FOR COL01,COL02
      TOTAL ROWS = 1,000 , 2 MOST FREQUENT KEYS

    COUNT       PCT    COLVALUE (HEX)                                (CHAR)
    -----     -----    --------                                      -----------

        1      0.10    80000001C1 D3D7C8C140 404040                  Ø   ALPHA
        1      0.10    80000002C1 D3D7C8C140 404040                  Ø   ALPHA

      TOTAL ROWS = 1,000 , 2 LEAST FREQUENT KEYS

    COUNT       PCT    COLVALUE
    -----       ---    --------

        1      0.10    80000002C1 D3D7C8C140 404040                  Ø   ALPHA
        1      0.10    80000001C1 D3D7C8C140 404040                  Ø   ALPHA

------------------------------------------------------------------------------