Reporting for BMC AMI Load
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*