PI66953: READ-ONLY TABLESPACE MAY BE LEFT IN READ-WRITE STATUS AFTER EXECUTION OF WORKLIST

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A read-only tablespace may be left in read-write status,
  instead of its original read-only status, after the execution
  of a worklist.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 who run an APPLY job using the Batch         *
  *                 Restart Program ADBTEP2.                     *
  ****************************************************************
  * 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:

  UI43602

Modules/Macros

•    ADBCCM   ADBEALT  ADBHUPA  ADBSETUP ADBTEPR
  ADBTEP2  ADB2TEP  ADB2UPA  ADB2000
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI43602

     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.