PH22698: SUPPORT FOR DB2 V12 FUNCTION LEVELS 502 (KEY LABELS) and 503 (Db2ZAI)

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• SUPPORT FOR DB2 V12 FUNCTION LEVELS 502 (key labels) and 503
  (Db2ZAI).
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS and Object Comparison Tool for z/OS.    *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR provides enhancements to      *
  *                      support Db2 function levels 502         *
  *                      (key labels) and 503 (Db2ZAI).          *
  *                                                              *
  *                      Changes are in the following            *
  *                      areas:                                  *
  *                                                              *
  *                      1.  Catalog navigation                  *
  *                      2.  Create and alter (AL/ALT)           *
  *                      3.  GEN                                 *
  *                      4.  DDL reader/merge                    *
  *                      5.  Compare                             *
  *                      6.  Masking                             *
  *                      7.  WSL cloning                         *
  *                      8.  Change Management (CM) import       *
  *                      9.  Formatter                           *
  *                      10. System administration (FL 503)      *
  ****************************************************************
  The following enhancements support Db2 function levels 502
  and 503:
  
  1. Catalog navigation
     The KEYLABEL column is displayed on catalog panels and
     interpretation panels for table, table space, stogroup and
     index. Panel ADB21G 'Storage Groups' is scrollable so it can
     display all catalog column values.
  
  2. Create and Alter (AL/ALT)
     A key label value can be specified during the following
     operations:
     - CREATE stogroup (on panel ADB26CG 'Create Storage Group')
     - ALTER stogroup (on panel ADB21GA 'Alter Storage Group')
     - CREATE table (on panel ADB26TOP 'Create Table Options')
     - ALTER table (AL) (on panel ADB21TA 'Alter Table')
     - ALTER table (ALT)
  (on panel ADBP7TOP 'Alter - Table Options').
  
  3. GEN
     When you generate SQL to re-create a table or
     storage group, Db2 Admin Tool can generate CREATE or ALTER
     statements that include the pending changes to the KEY LABEL
     clause.
  
  4. DDL reader/merge
     DDL reader and merge can parse and process (tokenize)
     the KEY LABEL clause in CREATE and ALTER statements.
  
  5. Compare
      Compare supports key label changes for storage groups
     and tables:
     - A key label change for a storage group is applied to the
       Db2 catalog only. The encryption status of the physical
       data set for a storage group is not changed until REORG
       is manually run on the table space.
     - A key label change for a table is applied to the Db2
       catalog. The encryption status of the physical data
       set for the table is updated when the
       'Run REORG/REBUILD' field is set to 'A' (All relevant)
       on the GOC5 panel.
  
  6. Masking
     New masking overwrites SGKEYLABL and TBKEYLABL are
     provided to overwrite the key labels for storage groups
     and tables.
  
  7. WSL cloning
     WSL cloning supports the new masking overwrites for
     key labels.
  
  8. Change Management (CM) import
     CM import supports the new masking overwrites for
     key labels.
  
  9. Formatter
     Db2 Admin Tool can format the KEY LABEL clause of CREATE
     and ALTER TABLE statements during WSL cloning and change
     management (CM) import with masking.
  
  10. System administration (FL 503)
     A new option '2M - Display/manage machine learning' is added
     on panel ADB2Z 'System Administration." This option allows
     you to issue the Db2 commands DISPLAY ML, START ML, and
     STOP ML.
  

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:

  UI69677

Modules/Macros

• ADB0     ADB21G   ADB21GA  ADB21GI1 ADB21S   ADB21SI1 ADB21T
  ADB21TA  ADB21TI1 ADB21X   ADB21XI1 ADB26CG  ADB26CTF ADB26TOP
  ADB27AC  ADB27C   ADB27C0  ADB27CA  ADB27CAA ADB27CMR ADB27CX
  ADB27DUP ADB28MC  ADB28MM  ADB2C21  ADB2C2L  ADB2CDC  ADB2CID
  ADB2CM1  ADB2CM2  ADB2CM3  ADB2CME  ADB2CMF  ADB2CMM  ADB2CMO
  ADB2CMP  ADB2CMR  ADB2CMS  ADB2CMT  ADB2CMU  ADB2DEP  ADB2FMT
  ADB2IGN  ADB2MASK ADB2MSK  ADB2MSQ  ADB2PA   ADB2PA3  ADB2PA4
  ADB2PA5  ADB2PA6  ADB2PA7  ADB2RE   ADB2REC  ADB2REE  ADB2REG
  ADB2REH  ADB2REM  ADB2REP  ADB2RER  ADB2RES  ADB2REU  ADB2REY
  ADB2REZ  ADB2RGC  ADB2RPT  ADB2WCL  ADB2WIN  ADB2WVL  ADB2Z
  ADB2Z2M  ADB2ZP   ADB2ZPV  ADB2ZZ   ADB2ZZMN ADB2ZZUT ADB2ZZV9
  ADB2ZZVA ADB2ZZVB ADB2ZZVC ADB7000  ADBASW   ADBCCM   ADBCCMM
  ADBCDTS  ADBCEST  ADBCEXP  ADBCHST  ADBCP    ADBCRCM  ADBCRCR
  ADBCRSP  ADBCSPG  ADBCVCT  ADBCVEY  ADBCVOC  ADBDAT   ADBDK
  ADBDT    ADBH017  ADBH018  ADBH1G   ADBH1TA  ADBH6TOP ADBH7TOP
  ADBHC2L  ADBHZ2M  ADBLI    ADBMAIN  ADBNSPB  ADBP7TOP ADBPA
  ADBPA1   ADBPX    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

• RC10 PSY UI69677

     UP20/05/28 P F005

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.