Very large table reorg

[Former Member]

Hi All,

I have a question, we have a table of around 900 GB size. We have been thinking of reorging the table in the window given by the business.

We wont be getting a window of more than 12 hours.

So what approach would you folks suggest for the same?

[maria_shen]

Hello,

If you are considering options other than reorg, it is recommended to use DB6CONV tool (instead of direct call of stored procedure). But I am afraid it may not finish within 12 hrs for a 900GB table movement either.

Kind regards
Maria

[ImtiazKaredia]

HI,

Perform online reorganization.

Refer: IBM Knowledge Center

Thanks

Imtiaz

[Former Member]

Hi Can we perform online reorg in multiple phases.

Like this weekend we will try to complete 30 % and then the next window we will complete 30 % and the next weekend we will complete 40 %.

Is that feasible?

[Former Member]

Hi,

If you have 12 hours of downtime than why not perform offline reorg.

For Online reorg cannot be done in batches -- not required, as during online reorg your table will be used by the system/users as normal (No downtime in other sense)

The only problem during online reorg is it will run for longer time and may have performance problem as table will be live and usable.

You can try to schedule reorg using DB13 or directly at OS level.

Regards,

Prithviraj

[former_member182505]

Hi

You can use the AMT refer the links

Performance considerations of the DB2 for Linux, UNIX, and Windows stored procedure ADMIN_MOVE_TABLE

How to move tables online using ADMIN_MOVE_TABLE procedure - DB2 administration and application dev...

Using ADMIN_TABLE_MOVE or DB6CONV to move VBDATA | SCN

  1543745 - DB6: Using and troubleshooting ADMIN_MOVE_TABLE

Thanks

Sadiq