A fix is available
APAR status
Closed as program error.
Error description
Panel ADB21XAR is not completely stopping the end user with an error message when a VARCHAR column index is defined as PADDED NO and an INDEX ordering is changed to RANDOM. It still generates wrong ALTER INDEX syntax and fails with -628. According to the customer , we should not let the user leave the panel ADB21XAR if PADDED is set to NO and chooses to change the order to RANDOM.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of Db2 Administration Tool for z/OS * * who create or alter an index * **************************************************************** * PROBLEM DESCRIPTION: The Create/Alter Index panel (ADB21XAR) * * does not restrict the invalid Db2 * * combination of the RA (random) line * * command on a VARCHAR column and the * * PADDED=NO option. * **************************************************************** The Db2 restriction for RANDOM column ordering when PADDED=NO was not validated correctly in the following scenario on panel ADB21XAR: - The user specifies the RA line command on a VARCHAR column when PADDED=YES or blank. - The user specifies PADDED=NO and issues NEXT. This lack of validation can result in an incorrect Db2 statement and SQL code -628. This APAR adds a fix to validate this Db2 restriction. If the selected options violate this restriction, error message ADB722E is returned, so that you can correct it: ADB722E <Option 1> is not allowed with <Option 2>. Keywords: SQLCODE628N ADB722E
Problem conclusion
The problem has been resolved.
Temporary fix
Comments
APAR Information
APAR number
PH56964
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
D10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2023-09-14
Closed date
2023-10-16
Last modified date
2023-11-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI94034
Modules/Macros
ADB21XAR ADB26CX
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
RD10 PSY UI94034
UP23/10/19 P F310
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:
02 November 2023