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, 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.

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 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 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 action occurred
  • The date and time when 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: 2020-08-15         BMC AMI Log Master for Db2 -  V12.01.00        Page:       1
Time: 13.45.34         Copyright BMC Software, Inc. 1995-2020
                     Status Changes Report, By Utility Name
--------------------------------------------------------------------------------
From: Date 2020-08-15 12.01.00.000000
  To: Date 2020-08-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      : 2020-08-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      : 2020-08-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      : 2020-08-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