PH36485: FL509 OBJECT LEVEL COMPRESSION

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• FL509 Object level Compression
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for         *
  *                 z/OS and Object Comparison Tool for z/OS.    *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR provides enhancements to      *
  *                      support Db2 12 function level 509. It   *
  *                      also includes toleration and support    *
  *                      for Db2 12 function level 510.          *
  *                                                              *
  *                      Changes are in the following            *
  *                      areas:                                  *
  *                                                              *
  *                      1. Catalog Navigation                   *
  *                      2. Create/Alter                         *
  *                      3. Parser and DDL reader                *
  *                      4. GEN                                  *
  *                      5. Compare                              *
  *                      6. Masking                              *
  *                      7. WSL cloning                          *
  *                      8. Change management (CM) Import        *
  *                      9. Tools Customizer (TCz)               *
  *                                                              *
  ****************************************************************
  The following enhancements support Db2 12 function level 509:
  
  1. Catalog Navigation
  The column that displays the COMPRESS attribute (CO) is moved
  to the main display screen on the 'Table Spaces' panel (ADB21S).
  This display is consistent with its display on the
  'Table Space Partitions' panel (ADB21SP). The Interpret
  panels for objects SYSTABLESPACE (ADB21SI1) and SYSTABLEPART
  (ADB21SPI) are also updated to describe the FIXEDLENGTH and
  HUFFMAN values of the COMPRESS column.
  
  2. Create/Alter
  When creating or altering (AL/ALT) a table space, a user can
  select additional valid COMPRESS values of 'H' (HUFFMAN) and
  'F' (FIXEDLENGTH) for partitions. A new COMPRESS field is
  also added on panels ADB21SAR (Create/Redefine Table Space)
  and ADB21SA (Alter Table Space) to allow specifying
  COMPRESS at the table space level.
  
  3. Parser and DDL reader
  The Admin Tool SQL parser and DDL reader is enhanced to support
  the FIXEDLENGTH and HUFFMAN values of the table space COMPRESS
  attribute.
  
  4. GEN
  GEN is enhanced to support the FIXEDLENGTH and HUFFMAN
  values of the table space COMPRESS attribute.
  
  5. Compare
  Object Compare is enhanced to detect differences in the
  COMPRESS values FIXEDLENGTH and HUFFMAN on both the table
  space and partition level.
  
  6. Masking
  The masking function has been enhanced to support the new values
  FIXEDLENGTH and HUFFMAN for the TSCOMPRES overwrite.
  
  7. WSL cloning
  The WSL cloning function has been enhanced to support an
  overwrite of the COMPRESS attribute with the new values
  FIXEDLENGTH and HUFFMAN.
  
  8. CM Import
  The CM import function has been enhanced to support an
  overwrite of the COMPRESS attribute with the new values
  FIXEDLENGTH and HUFFMAN.
  
  This APAR also adds the enhancement to tolerate and support
  Db2 12 function level 510. Tools Customizer (TCz) now allows
  V12R1M510 as a valid option for the APPLCOMPAT field.
  

Problem conclusion

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:

  UI75519

Modules/Macros

• ADB$$PRM ADB21S   ADB21SA  ADB21SAR ADB21SI1 ADB21SPI ADB21T
  ADB27AC  ADB28MC  ADB2C21  ADB2C2L  ADB2CDC  ADB2CID  ADB2CM1
  ADB2CM2  ADB2CM3  ADB2CME  ADB2CMF  ADB2CMM  ADB2CMO  ADB2CMP
  ADB2CMR  ADB2CMS  ADB2CMT  ADB2CMU  ADB2DEP  ADB2FMT  ADB2MASK
  ADB2MSK  ADB2MSQ  ADB2PA   ADB2PA3  ADB2PA4  ADB2PA5  ADB2PA6
  ADB2PA7  ADB2RE   ADB2REE  ADB2REG  ADB2REH  ADB2REM  ADB2REP
  ADB2RER  ADB2RES  ADB2RET  ADB2REU  ADB2REY  ADB2REZ  ADB2RGC
  ADB2RPT  ADB2W1Q  ADB2W1QB ADB2WCL  ADB2WIN  ADB2WVL  ADB2Z
  ADB3000  ADB49    ADB7000  ADBALT   ADBASW   ADBCCM   ADBCCME
  ADBCCMM  ADBCDTS  ADBCEST  ADBCHST  ADBCP    ADBCRCR  ADBCSPG
  ADBCVCT  ADBCVEY  ADBCVIC  ADBCVOC  ADBDAT   ADBDK    ADBGDDL
  ADBH1S   ADBH1SA  ADBH1SAR ADBH1SP  ADBHC2L  ADBLI    ADBMAIN
  ADBNSPB  ADBPA    ADBPA1   ADBPZAPU ADBTEP2  ADBTEPI  ADBTEPR
  ADBTEPU  ADBV99   ADBVERS  ADBVFC   ADBVFCA  ADBVFCF  ADBVVFG
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI75519

     UP21/05/25 P F105

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.