Unix Technical Forum

DB2 V7 TS Partition level reorg with NPIs

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


Go Back   Unix Technical Forum > Database Server Software > DB2

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-26-2008, 03:58 PM
Srihari Mupparaju
 
Posts: n/a
Default DB2 V7 TS Partition level reorg with NPIs

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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 07:50 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com