IBM Support

DB2 LUW - Online reorganization on partitioned table

Question & Answer


Question

Is online reorganization on a partitioned table permitted in DB2 for Linux, Unix and Windows?

Answer

No, currently none of the DB2 LUW versions allow Online or Inplace reorganization on a partitioned table. You may submit an enhancement request at the IBM RFE community: https://www.ibm.com/developerworks/rfe/?BRAND_ID=184

Document reference:


INPLACE
Reorganizes the table while permitting user access.
In place table reorganization is allowed only on nonpartitioned and
non-MDC tables with type-2 indexes, but without extended indexes and
with no indexes defined over XML columns in the table.
https://www.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0001966.html

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Data Movement - Reorg\/Rebalance","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;9.7","Edition":"Advanced Enterprise Server;Advanced Workgroup Server;Enterprise Server;Express;Personal;Workgroup Server","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21985911

Page Feedback