Status Changes report

This report provides information about database exception (DBE) records that are logged by Db2 utilities, including MODIFY and REPAIR. These records reflect changes to table space status, data pages, deleted rows, DBD repairs, and versioning. This information can be crucial for recovery purposes because it includes data changes and other actions that cause spaces and indexes to go in and out of restricted status.

When you generate a Status Changes report, BMC AMI Log Master cannot generate other forms of output in the same log scan, such as other reports or SQL. To generate other output in the same job, include an additional, separate log scan step.

Related topics

Reference-of-default-Log-Master-reports

Selectable field definition

Consider the following when you define a Status Changes report:

  • ORDER-BY-definition provides the STATUS and UTILITY keywords to conveniently sort a Status Changes report.
  • When BMC AMI Log Master processes a DBE record, some of the report dictionary items might not be accurately populated if the Begin UR record is logged before the start of the BMC AMI Log Master scan range. In this case, the following will be reported as UNKNOWN:
    • AUTH ID
    • CONNECTION ID
    • CONNECTION TYPE
    • CORRELATION ID
    • DATA SHARING MEMBER NAME
    • DATA SHARING MEMBER ID
    • PLAN NAME
    • SSID
  • The information presented in the Status Changes report includes the following:
    • Unit of recovery information if available
    • RBA/LRSN value when an action occurred
    • The date and time when an action occurred
    • Space Name
    • DBID
    • PSID
    • Partition Range
    • Utility
    • Status
    • Subtotals by Status if valued (depending on the ordering fields that you define for the report)
    • Report totals by Status if valued

  • You can order this report by the following unit of recovery (URID) options:

    • Unit of Recovery
    • Plan Name
    • Auth ID
    • Connection Type
    • Connection ID
    • Correlation ID

    You can also order this report by the following:

    • Database Name
    • Tablespace Name
    • DBID
    • PSID
    • Data Sharing Member Name
    • Data Sharing Member ID
    • SSID
    • Status
    • Utility

The following is a sample Status Changes report:

Date: 2022-01-15       BMC AMI Log Master for Db2 -  V13.01.00        Page:       1
Time: 13.45.34         Copyright BMC Software, Inc. 1995-2023
                     Status Changes Report, By Utility Name
--------------------------------------------------------------------------------
From: Date 2022-01-15 12.01.00.000000
  To: Date 2022-01-15 12.01.30.000000
--------------------------------------------------------------------------------
Report Information:
Work ID    : DB2DBA.$$WORKID0015         Run Number:    1  Subsystem: DEJM
Description:
--------------------------------------------------------------------------------
  Utility Name : QUIESCE
   ----------------------------------------------------------------------------
   URID      : x'000000000685088C2510'           Auth ID  : DB2DBA2
   RBA       : x'000000000685088C25CA'           Conn ID  : UTILITY
   Time      : 2022-01-15 12.01.09.236           Conn Type: BA
   Space Name: DB2DBADB.DB2DBAT1                 Corr ID  : DB2DBAPR
   DBID.PSID : (363.2)                           Plan Name: DSNUTIL
   Partitions: 1 - 1                             Status   : RECP
   Utility   : QUIESCE
   ----------------------------------------------------------------------------
   URID      : x'000000000685088C281A'           Auth ID  : DB2DBA2
   RBA       : x'000000000685088C28D4'           Conn ID  : UTILITY
   Time      : 2022-01-15 12.01.09.904           Conn Type: BA
   Space Name: DB2DBADB.DB2DBAT1                 Corr ID  : DB2DBAPR
   DBID.PSID : (363.2)                           Plan Name: DSNUTIL
   Partitions: 1 - 1                             Status   : RECP
   Utility   : QUIESCE
   ----------------------------------------------------------------------------
   URID      : x'000000000685088C2B24'           Auth ID  : DB2DBA2
   RBA       : x'000000000685088C2BDE'           Conn ID  : UTILITY
   Time      : 2022-01-15 12.01.10.193           Conn Type: BA
   Space Name: DB2DBADB.DB2DBAT1                 Corr ID  : DB2DBAPR
   DBID.PSID : (363.2)                           Plan Name: DSNUTIL
   Partitions: 1 - 1                             Status   : RECP
   Utility   : QUIESCE

 Totals For:Utility Name: QUIESCE
  RBDPSTAR   :       0     RECP       :       3     REORP      :       0
  TOTAL      :       3
Report Totals:
  RBDPSTAR   :       0     RECP       :       3     REORP      :       0
  TOTAL      :       3



 

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