Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Reorg: Related to indexes

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
mailsaurabh.tripathi

New User


Joined: 22 May 2008
Posts: 56
Location: hyderabad

PostPosted: Mon Jul 05, 2010 6:01 pm    Post subject: Reorg: Related to indexes
Reply with quote

Hi All

I'm having a reorg job for a partioned tablespace(10 partitions). The tablespace is having non-patitioned indexes too. Now i have a doubt that when i do a reorg of this tablespace, in the rebuild phase how the non-patitioned indexes will be reorged.

thnx!!
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Jul 05, 2010 9:18 pm    Post subject:
Reply with quote

Hello,

When the reorgis done, the non-partitioned indexes should be handled automatically.

Possibly i don't understand the question.
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Tue Jul 06, 2010 9:04 pm    Post subject:
Reply with quote

The complete index will (have to) be rebuild. Even when you only reorg 1 partition.
Back to top
View user's profile Send private message
mailsaurabh.tripathi

New User


Joined: 22 May 2008
Posts: 56
Location: hyderabad

PostPosted: Thu Jul 08, 2010 9:02 pm    Post subject:
Reply with quote

Thank You GuyC. One more thing i want to ask, say my tablespace is having more than 1 partitions, then one the indexes have been rebuild for partition 1, will the NPI's will again be rebuild for second and other partitions?

If yes, what will be the best way to keep this repetative rebuilding at bay?

thanx again.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Identify top 30 big tables or indexes... ashek15 DB2 0 Fri Jun 16, 2017 10:01 am
No new posts SQL Order By related question Joseph K Thomas DB2 8 Fri Mar 18, 2016 12:53 pm
No new posts JCL sort related Mani453 DFSORT/ICETOOL 13 Sun Dec 20, 2015 1:04 pm
No new posts Query related to inserting an auto po... Gopalakrishnan V DB2 4 Fri Dec 18, 2015 12:09 am
No new posts Question: REORG on LOB tablespaces rakesh1155 DB2 1 Fri Aug 14, 2015 2:14 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us