PI72544: DB2 OBJECT COMPARE - RO TABLESPACE LEFT IN RW STATUS AFTER WORKLIST PROCESSING

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 OBJECT COMPARE -  RO TABLESPACE LEFT IN RW STATUS AFTER
  WORKLIST PROCESSING.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison Tool      *
  *                 for z/OS.                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: A read-only tablespace may be left in   *
  *                      read-write status, instead of its       *
  *                      original read-only status, after        *
  *                      the execution of a Work Statement       *
  *                      List (WSL).                             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  This APAR provides a new enhancement to recover table
  space access status when running a Work Statement List
  (WSL).  A new option to recover the table space status is
  introduced for the Batch Restart Program ADBTEP2
  using the batch parameter option:
  
  On panel ADB2UPA 'Batch Job Utility Parameters',
  there is a new option called 'Preserve tablespace
  access state. If the option is set to YES, the table
  space access status will be recovered.
  The default is NO.
  
     Preserve tablespace
     access state . . . . . YES      (Yes/No)
  
  The same function can be enabled from CM Batch.
  A parameter, adbtep2_tsaccess, specifies whether
  to preserve the access state of the table spaces
  being accessed.  If you set the adbtep2_tsaccess
  parameter value to YES, run change (ADBTEP2)
  tracks the statements and processes that can
  place a tablespace in a different access state and
  preserves the state the tablespace is in.
  
  Values:
  YES  The access state of the table space is
       preserved
  NO   The access state of the table space is not
       preserved.
  default:
  NO
  

Problem conclusion

• The new enhancement is delivered.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI43603

Modules/Macros

•    GOCGCMP
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• RB20 PSY UI43603

     UP17/01/03 P F612

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.