Question & Answer
Question
How do I change the multi-cluster index column of a partitioned DB2 table?
Cause
The ORGANIZE BY clause is part of the core CREATE TABLE statement and cannot be altered.
Answer
You would need to create a new table with the new changes you wish and populate this new table either by a) a SELECT * from old-table, INSERT INTO new-table or b) use "LOAD FROM CURSOR" method into the new-table.
[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Database Objects\/Config - Tables","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"10.1;10.5;11.1;9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21989370