A fix is available
APAR status
Closed as new function.
Error description
(ADB) PH57692 Internal APAR to Manage APPLCOMPAT on Indexes
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of Db2 Administration Tool for z/OS * * and Db2 Object Comparison Tool for z/OS * **************************************************************** * PROBLEM DESCRIPTION: This APAR adds an enhancement for * * managing application compatibility for * * expression-based indexes and support * * for the ALTER INDEX REGENERATE USING * * APPLICATION COMPATIBILITY statement. * **************************************************************** The APPLCOMPAT and environment-related information for expression-based indexes is now displayed on panels ADB21X, ADB21XI1 and ADB21ENV. Panel ADB21ENV is now horizontally scrollable and contains SYSENV information. For expression-based indexes, the ENV line command displays environment information on the ADB21ENV panel, the AL line command allows you to regenerate the index and alter the APPLCOMPAT value, and the ALT line command allows you to alter the APPLCOMPAT value for the index. Object Compare now supports ignores of SYSENVIRONMENT.APPLCOMPAT on the ignore panels. For expression-based indexes, Object Compare checks for an APPLCOMPAT ignore before generating changes ALTER INDEX REGENERATE USING APPLICATION COMPATABILITY For views Object Compare checks for an APPLCOMPAT ignore before generating changes ALTER VIEW REGENERATE USING APPLICATION COMPATABILITY. For expression-based indexes, Object Compare now supports generating ALTER INDEX index_name REGENERATE USING APPLICATION COMPATIBILITY source_applcompat, when the source and target index are same, but the target APPLCOMPAT value is different than source APPLCOMPAT value.
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
PH57692
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
D10
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
YesSpecatt / New Function / Xsystem
Submitted date
2023-10-20
Closed date
2023-11-15
Last modified date
2023-12-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI94481
Modules/Macros
ADB1000 ADB21 ADB21A ADB21C ADB21D ADB21DC ADB21DI2 ADB21DS ADB21ENV ADB21G ADB21H ADB21K ADB21KD ADB21P ADB21S ADB21T ADB21TC ADB21TN ADB21TNC ADB21TPS ADB21TXC ADB21VV0 ADB21X ADB21XA ADB21XA0 ADB21XAR ADB21XAS ADB21XC ADB21XI1 ADB21XPS ADB21Z ADB21ZDS ADB21ZPS ADB25 ADB2CM2 ADB2CM3 ADB2CME ADB2CMP ADB2CMR ADB2CMT ADB2IGN ADB2PA ADB2REG ADBCCMM ADBCDTS ADBH1ENV ADBH1XAR ADBTEP2
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
RD10 PSY UI94481
UP23/11/18 P F311
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":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"D10","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
04 December 2023