PI76123: PRESERVE TABLE SPACE STATUS AFTER A CHANGE

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• OC PRESERVE TABLE SPACE STATUS AFTER A CHANGE.
  

Local fix

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

Temporary fix

Comments

• Enhancement is delivered.
  

APAR Information

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

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

  UI45183

Modules/Macros

•    GOCGCMP
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• RC10 PSY UI45183

     UP17/03/07 P F703

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.