PH24975: PARTITION RELATED FIXES 20/04/30 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Partition related fixes
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool         *
  *                 and Db2 Object Comparison Tool for z/OS.     *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR provides fixes related to     *
  *                      classic partitioned table spaces,       *
  *                      tables and indexes.                     *
  *                                                              *
  *                      The following areas are changed:        *
  *                                                              *
  *                      1. Alter (ALT)                          *
  *                      2. Merge                                *
  *                      3. Compare                              *
  ****************************************************************
  This APAR provides fixes related to classic partitioned table
  spaces, tables and indexes.
  
  The following areas are changed:
  
  1. Alter (ALT):
  Currently, insert partition is allowed for partitioned by
  range (PBR) as well as classic partitioned (non UTS) tables,
  via INS line command on panel ADB27CPV 'Alter Partitioned
  Table'. Admin tool will now restrict insert partition
  operation on a table in a classic partitioned tablespace, in
  line with Db2 behavior.
  Below error message will be issued:
  ADB33AE INSERT PARTITION operation is not allowed for table
  >table name< which is in a non-universal tablespace.
  
  2. Merge:
  In classic partitioned tablespaces, when you call an ALT on a
  table to add a partition in the end, it ends up with error:
  
  ADB7955E ADBC024E - Unexpected catalog row on source file.
  Expected:RA found:TP
  
  3. Compare:
  In classic partitioned tablespaces, when there is increase in
  partitions from source to target and has associated index-based
  partition with increase in partitions on source, generated
  changes file in CMDELTA mode has missing tablespace definition
  with increased partitions.
  
  When such change is registered and analyzed results in
  compare failure :
  
         ADB7955E ADB2CMR Unable to drop partitioning index
         because related tablespace definition was not found'.
  
  Compare has been fixed to generate tablespace definition
  with increased partitions in generated CMDELTA changes
  file.
  

Problem conclusion

• Problems have been 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:

  UI69451

Modules/Macros

• ADB0     ADB21II1 ADB21TA  ADB21TAV ADB21XAS ADB27AC  ADB27AP
  ADB27C   ADB27CPC ADB27CPV ADB27PAS ADB27PTR ADB28MC  ADB2CDC
  ADB2CID  ADB2CM1  ADB2CM2  ADB2CM3  ADB2CME  ADB2CMF  ADB2CML
  ADB2CMO  ADB2CMP  ADB2CMR  ADB2CMS  ADB2CMT  ADB2CMU  ADB2DEP
  ADB2FMT  ADB2GDP  ADB2IGN  ADB2MSK  ADB2MSQ  ADB2PA   ADB2PA4
  ADB2PA6  ADB2PA7  ADB2PRP  ADB2RE   ADB2REE  ADB2REG  ADB2REH
  ADB2REM  ADB2REP  ADB2RER  ADB2RES  ADB2RET  ADB2REU  ADB2REY
  ADB2REZ  ADB2RGC  ADB2RPT  ADB2RS   ADB2WCL  ADB2WIN  ADB2WVL
  ADB7000  ADB8000  ADBALT   ADBCCM   ADBCCME  ADBCCMM  ADBCDTS
  ADBCEST  ADBCEXP  ADBCP    ADBCRCM  ADBCRCR  ADBCVC   ADBCVCP
  ADBCVCT  ADBCVEX  ADBCVEY  ADBCVEZ  ADBCVIC  ADBCVOC  ADBDK
  ADBH1TA  ADBH1TAV ADBH7CPV ADBLI    ADBMAIN  ADBNSPB  ADBPA
  ADBPPDCI ADBTCML  ADBTEP2  ADBTEPI  ADBTEPU  ADBV99   ADBVFC
  ADBVFCA  ADBVFCF  ADBVVFG
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI69451

     UP20/05/14 P F005 A

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.