PH31554: DB2 V12 FL 508

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Db2 v12 FL 508
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR provides enhancements to      *
  *                      support Db2 12 function level 508.      *
  *                                                              *
  *                      Changes are in the following            *
  *                      areas:                                  *
  *                                                              *
  *                      1. ALTER (Move Table)                   *
  *                      2. GEN                                  *
  ****************************************************************
  The following enhancements support Db2 12 function level 508:
  
  1. ALTER (Move Table):
  The new primary and line command MOVETB is available on panels
  ADB21D 'Databases' and ADB21S 'Table spaces'. MOVETB allows
  moving tables from multi-table table spaces to
  partition-by-growth (PBG) table spaces. This operation is
  implemented by using the following Db2 statement:
  ALTER TABLESPACE <multi-tb TS> MOVE TABLE <table> TO
  TABLESPACE <PBG TS>
  
  The new panel ADB2MVT1 'Move Table Options' allows specifying
  the following table space options:
  Buffer pool, Storage group, Lock size, Tables per REORG,
  REBINDs for affected packages
  
  The subsequent new panel ADB2MVT2 'Move Tables to PBGs'
  displays attributes of the new tables. This panel allows
  navigating to related objects, checking for the existence of
  selected new table spaces, and checking for pending changes
  on selected multi-table table spaces. From this panel, the
  batch job is generated with the selected user options to
  execute the MOVE TABLE operation.
  
  2. GEN:
  When Db2 MOVE TABLE pending changes exist, the GEN
  command generates the ALTER statements for the pending
  changes based on the option of 'Include DB2 pending chgs'
  on the ADB2GEN panel. If the option is set to YES or ALTER,
  the same set of statements are generated.  The ALTER statements
  for MOVE TABLE pending changes are listed at the end.
  
  An additional change is delivered to remove trailing spaces in
  the value of the SET CURRENT APPLICATION COMPATIBILITY statement
  when issuing GEN on a deprecated table space.
  
  An additional change is delivered to remove trailing spaces in
  the value of the SET CURRENT APPLICATION COMPATIBILITY statement
  when issuing GEN on a deprecated table space.
  

Problem conclusion

Temporary fix

Comments

• ×**** PE21/04/30 PTF IN ERROR. SEE APAR PH34739  FOR DESCRIPTION
  

APAR Information

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

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

  UI73496

Modules/Macros

• ADB21D   ADB21S   ADB27AC  ADB28MC  ADB2CID  ADB2CM3  ADB2CME
  ADB2CMF  ADB2CMO  ADB2CMP  ADB2CMR  ADB2CMS  ADB2CMT  ADB2CMU
  ADB2FMT  ADB2MSK  ADB2MSQ  ADB2MVT1 ADB2MVT2 ADB2MVT3 ADB2PA
  ADB2PA3  ADB2PA4  ADB2PA5  ADB2PA6  ADB2PA7  ADB2PSQL ADB2REG
  ADB2REH  ADB2REM  ADB2UOPS ADB2WCL  ADB2WIN  ADB2WVL  ADBASW
  ADBCCM   ADBCCMM  ADBCDTS  ADBCEST  ADBCHST  ADBCRCR  ADBCSPG
  ADBDAT   ADBDK    ADBEMVT2 ADBEMVT3 ADBEMVTC ADBH1D   ADBH1S
  ADBHMVT1 ADBHMVT2 ADBHMVT3 ADBLI    ADBM30   ADBMAIN  ADBNSPB
  ADBPA    ADBPA1   ADBSMVT3 ADBSMVTO ADBTEP2  ADBTEPI  ADBTEPR
  ADBTEPU  ADBV99   ADBVERS
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI73496

     UP21/01/20 P F101

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.