A fix is available
APAR status
Closed as new function.
Error description
APPLCOMPAT-related support for VIEWs, SYNONYMs, and HASH-ORGANIZED TABLEs.
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 * * manage APPLCOMPAT for views, synonyms, * * and hash-organized tables. * **************************************************************** This enhancement provides the following support at the indicated function levels: 1. Function level 500 and later: Create view - The GEN and DDL line commands set the view APPLCOMPAT value prior to CREATE VIEW statements, and restore the value back to the target function level after the view is created. If the target function level is lower than the view APPLCOMPAT value, the target function level is displayed instead. 2. Function level 504 and later: Create synonym and hash-organized table - The APPLCOMPAT value is set to function level 503 prior to creating synonyms and hash- organized tables, and restored back to the target function level after the object is created.
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
PH28566
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-08-17
Closed date
2020-11-05
Last modified date
2020-12-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI72419
Modules/Macros
ADB1000 ADB2CM1 ADB2CM2 ADB2CM3 ADB2CME ADB2CMF ADB2CMO ADB2CMP ADB2CMR ADB2CMS ADB2CMT ADB2CMU ADB2GEN ADB2GEN6 ADB2GENS ADB2GENX ADB2IGN ADB2MSK ADB2REG ADBCDTS ADBVFC ADBVFCA ADBVFCF ADBVVFG
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
RC10 PSY UI72419
UP20/11/10 P F011
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.
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"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"}]
Document Information
Modified date:
12 February 2021