A fix is available
APAR status
Closed as program error.
Error description
In DB2 Administration Tool, using CC ( Copy Catalog ) function in DB2 v8 CM (Compatibility Mode) results in SQLCODE614 from CREATE INDEX DSNDUX01 on table IPLIST . Index key length exceeds 255 maximum length allowed in DB2 v8 CM.
Local fix
Remove the DDL for the CREATE UNIQUE INDEX aaaaaa.DSNDUX01 from the SYSIN dataset referenced in step CRTIX6 in the JCL in member DDLBND00 .
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 Administration Tool, who * * use Catalog Copy function in DB2 V8 * * in CM or ENF mode, may be affected. * **************************************************************** * PROBLEM DESCRIPTION: Create of index fails with SQLCODE614 * * due to unsupported attributes when in * * V8 CM or V8 ENF mode. * **************************************************************** * RECOMMENDATION: * **************************************************************** See Problem Description.
Problem conclusion
The index cannot be created until DB2 V8 is in New Function Mode. The CREATE INDEX DDL must be removed from the DDL file built by the Catalog Copy job. .* The problem has been fixed.
Temporary fix
Comments
APAR Information
APAR number
PK08621
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
510
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2005-07-08
Closed date
2005-08-17
Last modified date
2005-09-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
ADB2CCI ADB2CJDB
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":"5.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
02 September 2005