PI68012: DB2 ADMIN TOOL ADD SUPPORT FOR UPDATE XXX SYNTAX WHICH IS DB2 FOR Z/OS V11 NEW FUNCTION

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This APAR will add support to AL/ALTER tablespace db.ts
  PCTFREE yyy FOR UPDATE xxx within the panel ADB21SA.  Will
  also add support for AL function to register a change.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS and IBM Tools Customizer            *
  *                 for z/OS.                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: The following panels have been          *
  *                      modified to include the table           *
  *                      space PCTFREE FOR UPDATE attribute:     *
  *                                                              *
  *                      1. 'Create/Redefine Table Space'        *
  *                          panel ADB21SAR.                     *
  *                      2. 'Alter Table Space' panel ADB21SA.   *
  *                                                              *
  *                      - Support for PCTFREE FOR UPDATE        *
  *                      added for DB2 Object Compare.           *
  *                                                              *
  *                      - Support for PCTFREE FOR UPDATE        *
  *                      has been added for Masking.             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Support for tablespace attribute PCTFREE FOR UPDATE has been
  provided for the following panels:
  
  1. Panel ADB21SAR 'Create/Redefine Table Space' has a
      new column 'PFU'.
  2. Panel ADB21SA 'Alter Table Space' has a new column 'PFU'.
  3. Panel ADB21SPI 'Interpretation of an Object in
     SYSTABLEPART' has also been updated with the following
     new field:
  
      'For update space/page .:    '
  
  - DB2 Administration Tool has the ability to overwrite
  attribute PCTFREE FOR UPDATE using the Generate (GEN)
  function with masking for tablespace objects.
  
  - DB2 Administration Tool has the ability to overwrite
  attribute PCTFREE FOR UPDATE using the Work Statement List
  (WSL) cloning function with masking for tablespace objects.
  
  - DB2 Administration Tool has the ability to overwrite
  attribute PCTFREE FOR UPDATE using the Change Management (CM)
  import function with masking for tablespace objects.
  
  Below are examples of how to overwrite and verify the PCTFREE
  FOR UPDATE attribute for tablespaces:
  
  TSPCTFUPD:DB1.TS1,25
  VER,TSPCTFUPD:RANGE,10,20,RC=8
  

Problem conclusion

• Enhancements delivered and problems resolved.
  

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:

Modules/Macros

•    ADBASW   ADBCCM   ADBCCMM  ADBCDTS  ADBCEST
  ADBCP    ADBCRCR  ADBCSPG  ADBCVC   ADBCVCP  ADBCVCT  ADBCVEX
  ADBCVEY  ADBCVEZ  ADBCVIC  ADBDAT   ADBDK    ADBHC2L  ADBH1SA
  ADBH1SAR ADBLI    ADBMAIN  ADBNSPB  ADBPA    ADBPA1   ADBTEPI
  ADBTEPR  ADBTEPU  ADBTEP2  ADBVFC   ADBVFCA  ADBVFCF  ADBV99
  ADB2CDC  ADB2CID  ADB2CME  ADB2CMF  ADB2CMM  ADB2CMO  ADB2CMP
  ADB2CMR  ADB2CMS  ADB2CMT  ADB2CMU  ADB2CM1  ADB2CM2  ADB2CM3
  ADB2C2L  ADB2C21  ADB2DEP  ADB2FMT  ADB2IGN  ADB2MASK ADB2MSK
  ADB2MSQ  ADB2PA   ADB2PA3  ADB2PA4  ADB2PA5  ADB2PA6  ADB2PA7
  ADB2RE   ADB2REC  ADB2REE  ADB2REG  ADB2REH  ADB2REM  ADB2REP
  ADB2RER  ADB2RES  ADB2RET  ADB2REU  ADB2REY  ADB2REZ  ADB2RGC
  ADB2RPT  ADB2WCL  ADB2WIN  ADB2WVL  ADB21S   ADB21SA  ADB21SAR
  ADB21SP  ADB21SPI ADB26CS  ADB27AC  ADB28MC  ADB3000  ADB33
  ADB7000
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI45181

     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.