A fix is available
APAR status
Closed as new function.
Error description
Internal APAR for parser improvements (tablespace).
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of Db2 Administration Tool for z/OS * **************************************************************** * PROBLEM DESCRIPTION: This APAR provides enhancements to * * improve parser support for table space * * DDL. * **************************************************************** Some processes in Db2 Admin Tool accept DDL as input. The DDL is parsed to identify the keywords and values, but currently the syntax, semantics, and values are not verified. Therefore, errors will not be detected until the DDL is applied to Db2 much later in the process. The parser is being enhanced in stages to detect and report basic errors in the parsed DDL. This APAR adds the following checks for CREATE and ALTER TABLESPACE statements: - Check whether an attribute is specified more than once - Verify that exclusive options for ALTER TABLESPACE (such as DSSIZE) are not specified with any other option - Verify value ranges for some options. For example: - MAXPARTITIONS is in range 1-4096 - FREEPAGE is in range 0-255 - Verify that CREATE LOB TABLESPACE does not contain options that are not valid (such as SEGSIZE) - Verify some dependences between options. For example: - DSSIZE on partition level can be specified only if PAGENUM RELATIVE is specified - LOCKPART YES requires NUMPARTS
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
PH56326
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-08-11
Closed date
2023-09-11
Last modified date
2023-10-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI93533
Modules/Macros
ADB21SAR ADB2PA ADB2PA3 ADB2PA4
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
RD10 PSY UI93533
UP23/09/14 P F309
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 October 2023