This is a discussion on DB2 V7 TS Partition level reorg with NPIs within the DB2 forums, part of the Database Server Software category; --> Dear All, I am looking for some information on any efficient way to reorgs DB2 tablespace partitons for a ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Dear All, I am looking for some information on any efficient way to reorgs DB2 tablespace partitons for a Table with NPIs. The table space has 254 partitons and it has close to 350 million rows. The partition level reorgs take for ever even for 1 partiton (trying to update the NPI). Does anyone know of a tool/utility/software that handles the partiton level reorgs on tablespaces with NPIs efficiently ? Also, we are looking to do this with Share level Change to increase the table and the index availability. Thanks. Srihari |