A fix is available
APAR status
Closed as program error.
Error description
The DB2 Administration Tool for z/OS' ALT command built a CREATE TABLE statement with an invalid PRIMARY KEY clause resulting in a SQLCODE -104 / SQLCODEN104 error: sqlerror on CREATE command, PREPARE function DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL """". SOME SYMBOLS THAT MIGHT BE LEGAL ARE: <IDENTIFIER> DSNT418I SQLSTATE = 42601 SQLSTATE RETURN CODE DSNT415I SQLERRP = DSNHSMUD SQL PROCEDURE DETECTING ERROR DSNT416I SQLERRD = 13 0 0 -1 594 502 SQL DIAGNOSTIC INFORMATION DSNT416I SQLERRD = X'0000000D' X'00000000' X'00000000' X'FFFFFFFF' X'00000252' X'000001F6' SQL DIAGNOSTIC INFORMATION
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Administration Tool for * * z/OS who use the 'Alter Table ALT' (ALT) * * function to delete a column and the column * * is the first column in the primary key * * definition of the table. * **************************************************************** * PROBLEM DESCRIPTION: In DB2 Administration Tool for z/OS, * * when using the ALT function to delete * * a column from a table, and the column * * is the first column in the primary key * * of the table, the ALT APPLY job failed * * with RC8 / return code 8 and an * * SQLCODEN104 / SQLCODE = -104: * * * * DSNT408I SQLCODE = -104, * * ERROR: ILLEGAL SYMBOL """". * * SOME SYMBOLS THAT MIGHT * * BE LEGAL ARE: >IDENTIFIER<. * * ADB5185E The run is ending due to * * errors. * **************************************************************** * RECOMMENDATION: * **************************************************************** In DB2 Administration Tool for z/OS, when deleting a column which is the first column within the primary key definition of the table, the ALT APPLY job failed to apply changes and fails with a RC8 / return code 8 and SQLCODEN104 / SQLCODE = -104 because an illegal symbol """" was found in the primary key definition.
Problem conclusion
Problem has been resolved. Additionally, when using the ALT function to delete multiple columns from a table, including the column which is the last one in the primary key definition, the user may receive an ADBC200E error: ADBC200E Internal error. Max prim key seq = #key cols This problem will be addressed in APAR PM78162.
Temporary fix
Comments
APAR Information
APAR number
PM72154
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
A10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-09-04
Closed date
2012-12-14
Last modified date
2013-01-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
ADBCCMM
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
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":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
02 January 2013