PH67403: NEW FUNCTION - BASE

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• New Function - Base
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR provides enhancements to      *
  *                      support Db2 online conversion of        *
  *                      table spaces from partition-by-range    *
  *                      (PBR) to partition-by-growth (PBG).     *
  ****************************************************************
  GEN:
  This enhancement enables generation of DDL for table spaces,
  tables, and indexes when the object is affected by a pending
  alter to PBG. Pending changes are reflected in the generated
  CREATE statements when the option "Include Db2 pending chgs"
  is set to "Yes." Otherwise, ALTER statements are generated.
  When an alter to PBR is also pending, the generated ALTER or
  CREATE statements reflect the final PBR attributes.
  
  Object Compare:
  With this enhancement, Db2 Object Comparison Tool now
  supports the following capabilities:
  1)Generating ALTER statements to convert a PBR table space to
  PBG, eliminating the need to drop and re-create the object
  2)Generating ALTER statements for repartitioning, when the
  partitioning key of a table in a PBR table space is changed,
  avoiding drop and re-create operations
  3)Generating ALTER statements to handle dropped partitions
  from a table in a PBR table space
  4)Retaining partition-level attributes and partitioned indexes
  when dropping a partition or changing the partitioning key
  
  ALT table:
  This enhancement introduces the following changes to ALT
  functionality for tables:
  1) Ability to alter the partitioning key by using primary
  command PARTCOLS on the ADB27CPV (Alter Partitioned Table)
  panel
  2) Ability to drop a partition by using line command DROP
  on the ADB27CPV (Alter Partitioned Table) panel
  3) Ability to restore partition-level attributes and
  partitioned indexes when dropping partitions or altering a
  partitioning key
  4) Support for new operations in the virtual changes
  functionality for ALT on tables
  
  ALT table space:
  This enhancement introduces the following changes to ALT
  functionality for table spaces:
  1) Ability to alter the partitioning key by using primary
  command PARTCOLS on the ADB21TAV (Alter Partitioned Table)
  panel
  2) Ability to drop a partition by using line command DROP
  on the ADB21TAV (Alter Partitioned Table) panel
  3) Ability to restore partition-level attributes and
  partitioned indexes when dropping partitions or altering a
  partitioning key
  4) Support for new operations in the virtual changes
  functionality for ALT on table spaces
  
  Alter (AL) table:
  This enhancement introduces the following panel changes
  for AL functionality for tables:
  1) New option ALTER PARTITIONING BY GROWTH on
  panel ADB21TA (Alter Table)
  2) New fields DSSIZE and MAXPARTITIONS on panel ADB21TA
  (Alter Table) to support conversion to PBG table spaces
  3) Existing ADD PARTITIONING KEY option on panel ADB21TA (for
  PBG table space) changed to ADD/ALTER PARTITIONING BY RANGE.
  This change was made for consistency with the new PBR option
  ALTER PARTITIONING BY GROWTH.
  
  Keyword: DB2V13R1M507T/K
  

Problem conclusion

Temporary fix

Comments

• The enhancement has been delivered.
  ×**** PE25/09/23 FIX IN ERROR. SEE APAR PH68271  FOR DESCRIPTION
  

APAR Information

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

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

  UO04303

Modules/Macros

• ADB1000  ADB2     ADB21II1 ADB21S   ADB21SA  ADB21SA0 ADB21SAP
  ADB21SAR ADB21SAY ADB21SP  ADB21T   ADB21TA  ADB21TAP ADB21TAV
  ADB21VV  ADB21XA  ADB21XAR ADB21XAS ADB26CXC ADB27AC  ADB27AP
  ADB27C   ADB27C0  ADB27CA  ADB27CAA ADB27CMR ADB27CPC ADB27CPV
  ADB27CX  ADB27DUP ADB27PAS ADB28MC  ADB2ALL0 ADB2CDC  ADB2CID
  ADB2CM1  ADB2CM2  ADB2CM3  ADB2CME  ADB2CMF  ADB2CMO  ADB2CMP
  ADB2CMR  ADB2CMS  ADB2CMT  ADB2CMU  ADB2CVC  ADB2DEP  ADB2ELOB
  ADB2FMM  ADB2FMP  ADB2FMT  ADB2MSK  ADB2MSQ  ADB2OVW  ADB2PA
  ADB2PA3  ADB2PA4  ADB2PA5  ADB2PA6  ADB2PA7  ADB2PCO  ADB2RE
  ADB2REE  ADB2REG  ADB2REH  ADB2REM  ADB2REP  ADB2REU  ADB2REY
  ADB2REZ  ADB2RGC  ADB2RPT  ADB2WCL  ADB2WIN  ADB2WVL  ADB33
  ADB44    ADB7000  ADB80    ADBASW   ADBCCM   ADBCCMM  ADBCDTS
  ADBCEST  ADBCHST  ADBCP    ADBCRCR  ADBCSPG  ADBCVC   ADBCVCT
  ADBCVEY  ADBCVIC  ADBCVOC  ADBDAT   ADBDK    ADBE7ALT ADBGDDL
  ADBGMP   ADBGMSP  ADBH1SA  ADBH1SAR ADBH1TA  ADBH1TAV ADBH7C
  ADBH7CA  ADBH7CPV ADBHPCO  ADBLI    ADBNSPB  ADBP7AD  ADBPA
  ADBPA1   ADBPPDC  ADBSPCO  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

• RD10 PSY UO04303

     UP25/07/31 P F507  

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.