Skip to Content
Information
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.

Reporting for BMC AMI Reorg

This topic describes the information that BMC AMI Reorg sends to the SUMMARY DD.

SUMMARY DD reports

Discard Report

The Discard report documents the database name, the table space name and the discard data set name. This report is issued only if rows are discarded during the BMC AMI Reorg process. 

Related topics

Getting-started-with-BMC-AMI-Reorg

History-tables
Reporting for BMC AMI Stats


DISCARD REPORT
DBNAME   TSNAME   DISCARD DATASET NAME
-------- -------- ---------------------
DBNAME   TSNAME   DISCARD.DATASET.NAME
Warning

Important

When the SYSDISC file is allocated as DD DUMMY, the DISCARD DATASET NAME in the DISCARD REPORT is noted as NULLFILE.

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
PBG TBLSPC DBNAME.PBG00010 DB=0228  PS=009D  FILE=009C   PTNS=1        MXPT=10       SGSZ=64
  TBL 009E PBG00010_TBL1
C NPI DBNAME.PBG0X001      FANSET=009F    PGSET=00A0    TYPE=DF    KYLEN=12     KYCOLS=3
  NPI DBNAME.PBG0X002      FANSET=00A1    PGSET=00A2    TYPE=DF    KYLEN=8      KYCOLS=2

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

Object space report

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

  OBJECT SPACE REPORT              PHYS  LOGL                  TTL        ALLOCATED      USED SPACE   PG   NO.   NO.
  DBNAME    SPNAME     OBID  PSID  PART  PART  TYPE  CX?  I/J  PTNS    (# 4K PAGES)    (# 4K PAGES)   SZ  XTNT  DSET
 --------  --------   ----  ----  ----  ----  ----  ---  ---  ----  --------------  --------------  ---  ----  ----
  DBNAME    PBG00010   009C  009D     1     1  PTTS        I      1          10,836           7,386   4K     2     1
  DBNAME    PBG00010                                           TOTS          10,836           7,386
                                                                                                  
  DBNAME    PBG0X001   009F  00A0               NPI        I                  3,780           1,385
  DBNAME    PBG0X002   00A1  00A2               NPI        I                  3,780           1,040
                                                                                                  
          TOTALS                                                             18,396           9,811

Partition breakdown report

The Partition breakdown report documents the number of rows for each partition. It is only produced for PBG table spaces with indexes.

PARTITION BREAKDOWN REPORT - ROWS PER PHYSICAL PART
 TABLESPACE DBNAME.PBG00010 (1 PARTS)
 BASED UPON NPI DBNAME.PBG0X001
                                
  PART                           ROWS
-----     --------------------------
     1                        225,651
                                    
 TOTAL ROWS                   225,651
                                    
 REORG ROWS                   225,651

Tablespace index report

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

TABLESPACE INDEX REPORT
INDEX = DBNAME.PBG0X001
IXDSN = VCAT.DSNDBC.DBNAME.PBG0X001.I0001.A001       KEYLEN =12           3 KCOLS
TABLE = DBNAME.PBG00010_TBL1
                                                                                   
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
COL07                                    DATE        A F       4       4     C      7
COL08                                    DATE        A F       4       8     C      8

Before-After report (BF AF)

The Before-After report documents rows, pages, and index metrics prior to and after the reorganization.

 BEFORE AFTER REPORT                               DELETED                         TS-DATA PGS   IX      IX           IX          IX
 BA SPNAME    TYP PART        ROWS        KEYS        ROWS    PTR ROWS  PAGES USED IX-LEAF PGS LVLS    C LR     NEAR OFF     FAR OFF
-- --------  --- ---- ----------- ----------- ----------- ----------- ----------- ----------- ----  --- --  ----------- -----------
 B  PBG00010  SEG    1     225,651                                   0       7,386       3,676                                      
 A                         225,651                                           3,392       3,263                                      
                                                                                                                                   
===================================================================================================================================
                                                                                                                                   
 B  PBG0X001  NPI          225,651     225,651                               1,385       1,376    3   99.7        3,602       1,374
 A                         225,651     225,651             AVGKL=  12        1,385       1,376    3  100.0            0           0
                                                                                                                                   
 B  PBG0X002  NPI          225,651     197,045                               1,040       1,032    3   99.7        3,995       1,116
 A                         225,651     197,045             AVGKL=   8        1,040       1,032    3  100.0          194           3
                                                                                                                                   
===================================================================================================================================
===================================================================================================================================
                                                                                                                                   
 B     ** TOTALS **        225,651           0                       0       9,811       6,084                  XRIDS =           0
 A                         225,651           0                               5,817       5,671                  XRIDS =           0

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

Objects copied report

The Objects copied report documents the objects that were copied during the reorganization.

OBJECTS COPIED REPORT                                                  COPY     CPY SYSF COPY     SYSCOPY              PAGES     
DBNAME   SPNAME   TP PRT# COPY DSNAME                                  DDNAME   FSQ SCLL DEVICE   LOGRBA               COPIED    
-------- -------- -- ---- -------------------------------------------- -------- --- ---- -------- -------------------- ----------
DBNAME   T29446S1 TS      UXX.REGCOPY.DBNAME.T29446S1.G0001V00                    0   RF 3390                                130

Data set summary report

The data set summary report documents the size, by partition of the table space being reorganized.

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*

BMC AMI Reorg for Db2 13.1