PH22951: SUPPORT FOR DB2 FUNCTION LEVEL 504.

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• SUPPORT FOR DB2 FUNCTION LEVEL 504.
  
  
  
  
  
  
  Keywords:  DEPRECATED; SET APPLCOMPAT; ADMIN_INFO_SYSPARM
  

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 level 504.         *
  *                                                              *
  *                      Changes are in the following areas:     *
  *                      1. GEN                                  *
  *                      2. Change Management(CM) /              *
  *                         Object Compare                       *
  *                      3. CM batch                             *
  *                      4. ADBTEP2                              *
  *                      5. MIG                                  *
  *                      6. Catalog Copy                         *
  ****************************************************************
  Function level 504 enhancements:
  Objects that were deprecated in FL 504 can be still be processed
  by Db2 Admin Tool and Object Compare. If you need to process
  deprecated objects, you must set additional parameters for
  certain functions as follows:
  
  1. GEN
     Set the 'Target Function Level' field on the panel ADB2GEN
     'Generate SQL from DB2 catalog' to 503 or lower, to support
     creating or altering (DROP/CREATE) segmented or partitioned
     (non-UTS) tables spaces.
  
     GEN will lower the function level (SET APPLCOMPAT) to
     function level 503, execute the SQL statement, and then
     restore the original function level.
  
     Many components, such as Object Compare, Cloning
     and Migrate, use GEN to accomplish its function.
  
  2. Change Management / Object Compare
     Set the 'DB2 function level' field on the panel ADB2PCO
     'Options for Change Functions' to 503 or lower, and set the
     'Target Function Level' field on the panel ADB2GEN 'Generate
     SQL from DB2 catalog' to 503 or lower.
  
  3. CM batch
     Add TGT_DB2FL = '503' in your batch job to create deprecated
     table space types.
     By default, ADBTEP2 retries a failed SQL statement
     (SQLCODE = -20008, unsupported feature) at a lower Db2
     function level (SET APPLCOMPAT as above). If you do
     not want to retry these statements that fail with SQLCODE
     -20008, add ADBTEP2_RETRY_DEPRECATED_OBJ = NO.
  
  4. ADBTEP2
     By default, ADBTEP2 retries a failed SQL statement
     (SQLCODE = -20008, unsupported feature) at a lower Db2
     function level (SET APPLCOMPAT as above). If you do not want
     to retry the statements that fail with SQLCODE -20008, set
     the 'Retry Deprecated Obj' field on the panel ADB2UPA
     'Batch Job Utility Parameters' to NO when using the online
     interface or set RETRY_DEPRECATED_OBJ = NO in the
     ADBTEP2 job.
  
  5. MIG (Migrate)
     To migrate deprecated objects in FL 504 or above:
     - If the source system is bound at function Level 503 or
       lower, the target system must be bound at FL 503 or lower.
     - If the source system is bound at function level 504 or
       above, the target system must be bound at the same
       function level.
     Non-deprecated objects can be processed with all function
     levels.
  
  Note: The requirements for setting additional function level
  parameters in all of the above functions will be removed in
  a future APAR.
  
  Additionally, Db2 Admin Tool has been changed to call the
  ADMIN_INFO_SYSPARM stored procedure, instead of the
  DSNWZP stored procedure, to get Db2 subsystem parameter
  values. DSNWZP is deprecated in Db2 v12. Please ensure that
  ADMIN_INFO_SYSPARM is operational.
  

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:

  UI69880

Modules/Macros

• ADB1000  ADB2000  ADB27AC  ADB28MC  ADB2CID  ADB2CM1  ADB2CM2
  ADB2CM3  ADB2CME  ADB2CMF  ADB2CMO  ADB2CMP  ADB2CMR  ADB2CMS
  ADB2CMT  ADB2CMU  ADB2DEP  ADB2GEN  ADB2ISQ  ADB2LCC  ADB2MSK
  ADB2MSQ  ADB2PA   ADB2PA3  ADB2PRP  ADB2RE   ADB2REE  ADB2REG
  ADB2REH  ADB2REM  ADB2REP  ADB2RER  ADB2RES  ADB2RET  ADB2REU
  ADB2REY  ADB2REZ  ADB2RGC  ADB2TEP  ADB2UPA  ADB2WCL  ADB2WIN
  ADB2WVL  ADB2ZP   ADB2ZPV  ADB2ZZ   ADB2ZZMN ADB2ZZV9 ADB2ZZVA
  ADB2ZZVB ADB2ZZVC ADBALT   ADBBIND  ADBCCM   ADBCCMM  ADBCDCH
  ADBCDTS  ADBCIMV  ADBCMBIV ADBCMPDB ADBCMTP  ADBCMTU  ADBCP
  ADBCRCA  ADBCRCM  ADBCRCR  ADBCSQL  ADBCSRV  ADBCUPC  ADBCVEY
  ADBCVIC  ADBCVIM  ADBDAT   ADBDET   ADBEALT  ADBHUPA  ADBLI
  ADBLIOB  ADBRPTL  ADBTEP2  ADBVERS  ADBVFC   ADBVFCA  ADBVFCF
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI69880

     UP20/06/06 P F006

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.