Hello,

reading

https://www.ibm.com/docs/en/db2/11.5?topic=commands-reorg-table

makes me wonder, if I do a reorg on a partition are other partitions still writeable? Ifso, does this include reorgs on a parttion on the non-partitioned index?

regards,

Alexander Al

------------------------------
Alexander Al
------------------------------

Hi Alexnder,

What I do usually for any maintenance on a partitioned table, I detach the particular partition and do the required maintenance then attach it again, and keep other partitioned in peace.

It depends also how did you define the table, If you are using global index I believe this option is not valid in this case.

Thanks ..

Khalid

------------------------------
Khalid Qrines
------------------------------

Hi Alexander,  I believe it also depends on the command options used for the reorg.  This piece of the documentation might be helpful

This table might be helpful as well:

Regards

-Andy

------------------------------
Andy McLaughlin
Great American Insurance
Cincinnati
------------------------------