Reporting for BMC AMI Load


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

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

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                                   
                                                                                                                                  
===================================================================================================================================

 

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