Important We are integrating BMC AMI LOBMaster technology into the BMC AMI Reorg product and discontinuing BMC AMI LOBMaster as a separate product. For the latest integrated documentation, see BMC AMI Reorg for Db2 13.1.

Reports to the SUMMARY DD

This topic describes the additional information that BMC AMI Reorg sends to the SUMMARY DD for LOB table spaces.

Internal IDS report

The LOBS ON BASE TBL section is included in the Internal IDS report for each defined LOB column, showing the auxiliary table space and index for each LOB column.

Related topics

Reporting-for-BMC-AMI-LOBMaster

BMC-AMI-LOBMaster-DD-statements 


Example
- INTERNAL IDS REPORT                                                                       
- TABLESPACE BI12DWWA.PBRLOB01 DB=0112  PS=008C  FILE=008B   PTNS=4        SGSZ=16          
-   TBL 008D TEST_PBRLOB01_TBL1                                                             
- PTGIX DBPROD1.FAKE PIX       FANSET=0000    PGSET=0000    TYPE=DF    KYLEN=4      KYCOLS=1
- C NPI DBPROD1.RLOBIX02       FANSET=00A8    PGSET=00A9    TYPE=UF    KYLEN=4      KYCOLS=1
-   NPI DBPROD1.RLOBIX26       FANSET=00EB    PGSET=00EC    TYPE=DF    KYLEN=13     KYCOLS=2
                                                                                           
- LOBS ON BASE TBL COL #26                   
                                            
-           FILE   FSET   AUX        AUX     
-    PART   OBID   OBID   TSNAME     IXSPACE  
-    ----   ----   ----   --------   --------
-       1   0003   000D   QAS        Q9098IX1
-       2   0005   000F   QBS        Q9091CNW

For more information about this report, see Reporting for BMC AMI Reorg.

LOBs space report

The LOBs space report documents the type and size of the LOB objects being processed.

Example
   LOBS SPACE REPORT           TABL                              ALLOCATED      USED SPACE   PG   NO.   NO.
   TSNAME    IXNAME     TYPE   COL#  PART  OBID  PSID  I/J    (# 4K PAGES)    (# 4K PAGES)   SZ  XTNT  DSET
   --------  --------   -----  ----  ----  ----  ----  ---  --------------  --------------  ---  ----  ----
   LOBC10               LOBTS    12     1  000C  000D   I              360              21   4K     1     1
             LXLOBC10   LOBIX    12     1  0018  0019   I              180             180   4K     1     1

   LOBC11               LOBTS    13     1  000E  000F   I           54,180          50,277   4K    20     1
             LXLOBC11   LOBIX    13     1  001A  001B   I              540             540   4K     2     1

   LOBC17               LOBTS    19     1  0010  0011   I              360              21   4K     1     1
             LXLOBC17   LOBIX    19     1  001C  001D   I              180             180   4K     1     1

 TOTALS                                                             55,800          51,219

Data set summary report

The data set summary report documents the size of the base table space by partition.

Example
PARTITION DATASET SUMMARY
                         CNTL       EMPTY                     PTR       OFLOW               VERSIONED   NULL CLIX
  PART      PAGES       PAGES       PAGES        ROWS        ROWS        ROWS    DISCARDS        ROWS        ROWS
  ---- ----------  ----------  ----------  ----------  ----------  ----------  ----------  ----------  ----------
   1       65,509           5          28      65,472           0           0           0           0
   2       65,509           5          28      65,472           0           0           0           0
   3       65,509           5          28      65,472           0           0           0           0
   4       65,509           5          28      65,472           0           0           0           0
   5       65,509           5          28      65,472           0           0           0           0
   6       65,509           5          28      65,472           0           0           0           0


 

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