Reporting for BMC AMI Load

This topic describes what BMC AMI Load sends to the SUMMARY DD.

(PTF BQU2361 applied) SUMMARY DD reports

Internal IDS report

The Internal IDS report correlates the Db2 internal object identifiers to their full external names. You can use this to interpret product messages with internal identifiers.

INTERNAL IDS REPORT
TABLESPACE DBNAME.SEGM0001 DB=0228 PS=0033 FILE=0032   SGSZ=32
  TBL 0034 SEGM0001_TBL1
C IX DBNAME.SEGM1X11      FANSET=0035    PGSET=0036    TYPE=DF    KYLEN=4      KYCOLS=1
   IX DBNAME.SEGM1X12      FANSET=0037    PGSET=0038    TYPE=DF    KYLEN=9      KYCOLS=2
   IX DBNAME.SEGM1X13      FANSET=0039    PGSET=003A    TYPE=DV    KYLEN=20     KYCOLS=3
  TBL 003B SEGM0001_TBL2
C IX DBNAME.SEGM1X21      FANSET=003C    PGSET=003D    TYPE=DF    KYLEN=4      KYCOLS=1
   IX DBNAME.SEGM1X22      FANSET=0054    PGSET=0055    TYPE=DF    KYLEN=13     KYCOLS=2
  TBL 0075 SEGM0001_TBL3
C IX DBNAME.SEGM1X31      FANSET=0076    PGSET=0077    TYPE=DF    KYLEN=4      KYCOLS=1

TABLESPACE INDEX REPORT
  INDEX = DBMVSUSR.SEGM1X21
  IXDSN = DEJMCAT.DSNDBC.DBMVSUSR.SEGM1X21.I0001.A001       KEYLEN =4            1 KCOLS
  TABLE = DBMVSUSR.SEGM0001_TBL2


  INDEX COLUMN NAME REPORT                           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


OBJECTS LOADED REPORT                               DELETED                         TS-DATA PGS IX    IX           IX          IX
DBNAME   SPCNAME   PART        ROWS        KEYS        ROWS    PTR ROWS PAGES USED IX-LEAF PGS LVS   CLR     NEAR OFF     FAR OFF
------- -------- ---- ----------- ----------- ----------- ----------- ----------- ----------- --- ----- ----------- -----------
DBMVSUSR SEGM0001             5,000                                   0         547         209

DBMVSUSR SEGM1X11             5,000       5,000             AVGKL=               23          19 2   54.5        3,439       1,155

DBMVSUSR SEGM1X12             5,000       5,000             AVGKL=   1           29          25 2   54.5        3,439       1,155

DBMVSUSR SEGM1X13             5,000       5,000             AVGKL=   2           45          41 2   54.5        3,439       1,155
===================================================================================================================================
===================================================================================================================================

                               5,000           0                                 644         294

===================================================================================================================================

Each line of this report represents part of the object being processed:

The first line specifies the database.tableSpace, followed by the hexadecimal value for the DBID (DB), PSID (PS), OBID (FILE), and the number of partitions (PTNS).
The second line specifies the table OBID and name.
The third through fifth lines lines show the following index information:
Field name
Description
FANSET
OBID
PGSET
ISOBID
TYPE
First character: Dup or Unique, second character: Fixed or Variable.
KYLEN
Key length in bytes
KYCOLS
Number of table columns in the index

Field name	Description
FANSET	OBID
PGSET	ISOBID
TYPE	First character: Dup or Unique, second character: Fixed or Variable.
KYLEN	Key length in bytes
KYCOLS	Number of table columns in the index

Tablespace index report

The Tablespace index report documents column-related information for the specified index.

TABLESPACE INDEX REPORT
INDEX = DBNAME.SEGM1X22
IXDSN = VCAT.DSNDBC.DBNAME.SEGM1X22.I0001.A001       KEYLEN =13           2 KCOLS
TABLE = DBNAME.SEGM0001_TBL2

INDEX COLUMN NAME REPORT                           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     C      2

Objects loaded report

The Objects Loaded report documents the content and size of the objects processed by the utility.

OBJECTS LOADED REPORT                               DELETED                         TS-DATA PGS IX    IX           IX          IX
DBNAME   SPNAME    PART        ROWS        KEYS        ROWS    PTR ROWS PAGES USED IX-LEAF PGS LVS   CLR     NEAR OFF     FAR OFF
------- -------- ---- ----------- ----------- ----------- ----------- ----------- ----------- --- ----- ----------- -----------
DBNAME   SEGM0001             5,000                       0                     547         209

DBNAME   SEGM1X11             5,000       5,000             AVGKL=   4           23          19 2   54.5        3,439       1,155

DBNAME   SEGM1X12             5,000       5,000             AVGKL=   1           29          25 2   54.5        3,439       1,155

DBNAME   SEGM1X13             5,000       5,000             AVGKL=   2           45          41 2   54.5        3,439       1,155
===================================================================================================================================
===================================================================================================================================

                              5,000                      0                     644         294

===================================================================================================================================