PI76120: PRESERVE TABLE SPACE STATUS AFTER A CHANGE

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

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

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:

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

• RC10 PSY UI45191

     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.