PH62135: COMPARE CHANGES TABLESPACE COMPRESS YES TO COMPRESS YES FIXEDLENGTH

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Object Compare generates changes from COMPRESS YES to COMPRESS
  YES FIXEDLENGTH when there should be no changes.
  
  Customer scenario:  SOURCE DDL has COMPRESS YES, Target has
  COMPRESS YES, ZPARM on target sub system is FIXEDLENGTH.
  
  1)COMPRESS YES has catalog value SYSTABLESPACE.COMPRESS = "Y"
  2)COMPRESS YES FIXEDLENGTH has catalog value
  SYSTABLESPACE.COMPRESS = F
  3)COMPRESS YES HUFFMAN has catalog value SYSTABLESPACE.COMPRESS
  = "H"
  
  When source is DDL and COMPRESS YES is specified , Compare
  applies ZPARM (TS_COMPRESSION_TYPE) to source. In this case "F"
  and Compares with target value "Y" and hence ALTER TABLESPACE
  COMPRESS YES FIXEDLENTH is generated.
  
  The ZPARM value is applied only on source , if it is DDL and
  COMPRESS is YES. The rest of the combinations will work like
  before .
  
  With this APAR fix, Object Compare will no longer apply ZPARM to
  source value  before comparing with target value which causes
  the issue described.
  
  _From V13 SQL reference -:_
  
  _COMPRESS YES - Specifies that data compression is used for the
  table space or partition. The rows are not compressed until the
  LOAD or REORG utility is run on a table in the table space or on
  a partition, or until the total row data size reaches the
  compression data threshold while an insert operation is
  performed._
  
  _If a keyword for the compression algorithm is not specified,
  the default compression algorithm is used._
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  *                 and Db2 Object Comparison Tool for z/OS      *
  ****************************************************************
  * PROBLEM DESCRIPTION: Compare applies TS_COMPRESSION_TYPE     *
  *                      to source COMPRESS YES attributes,      *
  *                      causing unnecessary ALTER and REORG     *
  *                      operations.                             *
  ****************************************************************
  Compare will apply the TS_COMPRESSION_TYPE value to source
  COMPRESS YES attributes for the compare operation.
  However, this behavior can cause unnecessary ALTER and REORG
  operations when none are needed.
  
  KEYWORDS: MSGADB7412
  

Problem conclusion

• The problem has been resolved. Compare will no longer apply
  the TS_COMPRESSION_TYPE value to source COMPRESS YES attributes.
  However, it will still use TS_COMPRESSION_TYPE in the background
  to determine if an ALTER or REORG is necessary. Compare
  will issue a new informational message ADB7412I when relevant.
  

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:

  UI99194

Modules/Macros

• ADB2CM3  ADB2CME  ADB2CMF  ADB2CMO  ADB2CMP  ADB2CMR  ADB2CMS
  ADB2CMT  ADB2CMU  ADB7000
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RD10 PSY UI99194

     UP24/11/27 P F411

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.