A fix is available
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 number
PH22951
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
C10
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-03-06
Closed date
2020-06-04
Last modified date
2020-07-06
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.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.1.0","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
12 February 2021