APAR status
Closed as program error.
Error description
CREATE CLUSTER INDEX physically rebuilds the table and all indices which already exist on a table. This may take a long time for large tables. For performance reasons these statements should be written before all other CREATE INDEX statements For Example: Current dbschema output: create table "informix".mytab ( id integer, a1 char(5), b1 integer ); revoke all on "informix".mytab from "public" as "informix"; create index "informix".aidx on "informix".mytab (a1) using btree; create index "informix".bidx on "informix".mytab (b1) using btree; create cluster index "informix".cidx on "informix".mytab (id) usingbtree ; Required dbschema output: { create table "informix".mytab ( id integer, a1 char(5), b1 integer ); revoke all on "informix".mytab from "public" as "informix"; create cluster index "informix".cidx on "informix".mytab (id) usingbtree ; create index "informix".aidx on "informix".mytab (a1) using btree; create index "informix".bidx on "informix".mytab (b1) using btree;
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * IDS 11.50 users performing CREATE CLUSTER INDEX * **************************************************************** * PROBLEM DESCRIPTION: * * dbexport should write out CREATE CLUSTER INDEX before all * * other CREATE INDEX statements/ * **************************************************************** * RECOMMENDATION: * * Upgrade to IDS 11.50.xC6 and above. * ****************************************************************
Problem conclusion
Problem first fixed in IDS 11.50.xC6 After the fix, dbexport will write out CREATE CLUSTER INDEX before all other CREATE INDEX statements.
Temporary fix
Comments
APAR Information
APAR number
IC62598
Reported component name
IBM IDS ENTRP E
Reported component ID
5724L2304
Reported release
B15
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-08-18
Closed date
2009-10-23
Last modified date
2009-10-23
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
IBM IDS ENTRP E
Fixed component ID
5724L2304
Applicable component levels
RB15 PSY
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B15","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
23 October 2009