A fix is available
APAR status
Closed as new function.
Error description
Provide AL functionality into ALT.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of Db2 Administration Tool for z/OS * **************************************************************** * PROBLEM DESCRIPTION: This APAR provides enhancements in the * * ALT(alter) process flow to view, add, * * or drop foreign keys and check * * constraints. * **************************************************************** This APAR provides the following improvements: - Panel ADBP7CN 'Constraints' lists foreign keys and check constraints, in addition to primary and unique keys. - The ADD primary command on panel ADBP7CN is replaced with ADDU (add unique or primary) to distinguish it from other constraints. - The new field ENFORCED is added on panel ADB21TAF 'Alter Foreign Key Constraint'. - The new primary command ADDC is added on panel ADBP7CN to allow adding check constraints. - The new line command 'D' (drop) is added on panel ADBP7CN to allow dropping foreign key and check constraints.
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
PH52343
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-02-02
Closed date
2023-04-13
Last modified date
2023-05-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI91446
Modules/Macros
ADB21T ADB21TAF ADB21TAH ADB21TAK ADB21TAL ADB21TFK ADB27C ADB27C0 ADB27CA ADB27CAA ADB27CMR ADB27CX ADBE7CTP ADBE7FK0 ADBH1TFK ADBH7C ADBH7CN ADBP7CN ADBP7CTP
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
RD10 PSY UI91446
UP23/04/18 P F304
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:
03 May 2023