PH20648: DB2V12 INSERT PARTITIONS ENHANCEMENTS

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• DB2v12 Insert Partitions enhancements
  

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 enhancements to      *
  *                      support the new Db2 12 functionality    *
  *                      to insert partitions.                   *
  *                                                              *
  *                      The following areas are changed:        *
  *                                                              *
  *                      1. Catalog navigation                   *
  *                      2. Alter (AL/ALT)                       *
  *                      3. GEN                                  *
  *                      4. DDL reader/Merge                     *
  *                      5. Compare                              *
  ****************************************************************
  This APAR provides the following specific enhancements:
  
  1. Catalog navigation:
      Panel ADB21II1 'Interpretation of an Object in SYSCOPY'
      describes additional TTYPE column values of the SYSCOPY
      catalog table in the 'Format' field.
      Panel ADBPPDCI 'Interpretation of Object in SYSPENDINGDDL'
      displays the lowest and highest partition in range for REORG
      (the REORG_SCOPE_LOWPART and REORG_SCOPE_HIGHPART
      values in the SYSPENDINGDDL catalog table).
  
  2. Alter (AL/ALT):
      The ALT line command on a partitioned table displays panel
      ADB27CPV 'Alter Partitioned Table', which is enhanced to
      allow inserting a partition before or after any existing
      partition by using the INS line command. This panel allows
      editing limit key values by using multiple operation types
      (ALTER, ADD, INSERT) and the operation type is reflected in
      the 'Oper' column.
  
      The new RESET primary command cleans up and
      resets all changes to the original values.
  
      During the AL line command operation, panel ADB21TAV 'Alter
      Partitioned Table' allows a similar streamlined
      insertion operation. More usability improvements to make
      AL consistent with ALT are planned for a future release.
  
  3. GEN:
      When you generate SQL to re-create an object, Db2 Admin
      Tool can generate CREATE or ALTER statement that include
      the pending changes to insert partitions.
  
  4. DDL reader/Merge:
      Db2 Admin Tool can now parse the statement ALTER TABLE...
      ADD PARTITION n ENDING AT x to insert a
      partition at physical partition n with limit key value x.
  
      Db2 Admin Tool also supports inserting partitions by using
      the statement ALTER TABLE....ADD PARTITION ENDING AT x.
      The partition is inserted into the correct location
      based on limit key value x.
  
  5. Compare:
      Today, when Db2 Object Compare compares the partitions in a
      source and target, it can generate ALTER ..TABLE ADD
      PARTITION AT x for adding partitions at the end and ALTER
      TABLE..ALTER PARTITION n ENDING AT x for altering limit
      keys of existing partitions.
  
      With this enhancement, when Db2 Object Compare compares
      the partitions in a source and target and discovers
      a partition in the source that does not exist in the
      target, Object Compare can generate the change
      statement ALTER TABLE..ADD PARTITION AT x to insert
      the partition.
  
      The change statement to insert a partition
      (ALTER TABLE...ADD PARTITION ENDING AT x) is
      a pending change. Object Compare generates
      REORG TABLESPACE.. SCOPE PENDING to resolve the pending
      changes for affected partitions.
  

Problem conclusion

Temporary fix

Comments

• ×**** PE20/04/30 FIX IN ERROR. SEE APAR PH24975  FOR DESCRIPTION
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI69179

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 UI69179

     UP20/04/28 P F004

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.