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
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