PH36790: EXTENDED FL508 SUPPORT

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Enhancements to FL508 support.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS                                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR provides a number of          *
  *                      enhancements and fixes related          *
  *                      to converting a non-UTS to a PBG UTS    *
  *                      via the Move Table function introduced  *
  *                      in FL 508.                              *
  ****************************************************************
  The following enhancements and issues are addressed in this
  APAR:
  
  Enhancements:
  
  The number of tables/REORGs allowed in the Move Table function
  is increased from 128 to 500.
  The result of running checks for duplicates or pending changes
  is now displayed in an error status field on the
  "Move Tables to PBGs" panel (ADB2MVT2).
  DDL changes for tables with an error in the error status field
  of panel ADB2MVT2 are now generated but are commented out in
  the generated job.
  
  Issues:
  
  An incorrect UTLREC template was generated if user-defined
  templates were not used.
  REORG SHRLEVEL REFERENCE/CHANGE was not generated if not
  specified by the user.
  Compare fails when converting  a non-UTS to PBG UTS using
  DROP/CREATE.
  
  Note:  If you want to create or drop/create a non-UTS table
  space without the conversion when running in FL504 or above,
  you need to to set "DB2 function level" field on the panel
  ADB2PCO "Options for Change Functions" to 503 or lower, or
  add TGT_DB2FL = "503" in CM Batch job, to create deprecated
  table space types.
  
  Compare fails if a DSSIZE change is attempted on a segmented
  table space.
  Compare loses INLINE LENGTH changes when converting a non-UTS
  to a PBG UTS.
  Compare attempted to alter a dropped LOB table space during a
  non-UTS to PBG UTS conversion.
  

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:

  UI76030

Modules/Macros

• ADB2CME  ADB2CMP  ADB2CMT  ADB2MVT1 ADB2REM  ADB7000  ADBCDTS
  ADBEMVT3 ADBSMVT3 ADBSMVTO ADBTEP2
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI76030

     UP21/06/25 P F106

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.