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
===================================================================================================================================
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
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
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
===================================================================================================================================
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
===================================================================================================================================
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*