Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Reorg on Index

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

New User


Joined: 03 Feb 2010
Posts: 9
Location: India

PostPosted: Tue Aug 21, 2012 1:02 pm    Post subject: Reorg on Index
Reply with quote

When do we run Reorg on Index? Reorg on the tablespace also rebuilds the index on build space. So what is use of reorg on index?

Can anyone please let me know.

Thanks,
JSN
Back to top
View user's profile Send private message

GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Tue Aug 21, 2012 3:03 pm    Post subject:
Reply with quote

sometimes reorg index is all you need, and then there is no point in wasting time and cpu to reorg everything.
Back to top
View user's profile Send private message
gylbharat

Active Member


Joined: 31 Jul 2009
Posts: 565
Location: Bangalore

PostPosted: Tue Aug 21, 2012 3:06 pm    Post subject:
Reply with quote

It depends what control card you are using...

REORG TABLESPACE - Reorganizes |all data and all indexes.
REORG TABLESPACE PART n - Reorganizes data for PART n of the table space and PART n of all partitioned indexes.
REORG TABLESPACE |PART n:m - Reorganizes data for PART n through PART m of the table space and PART n through PART m of all partitioned indexes.

If its a Partitioned table
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7315

PostPosted: Tue Aug 21, 2012 3:25 pm    Post subject:
Reply with quote

GuyC wrote:
sometimes reorg index is all you need, and then there is no point in wasting time and cpu to reorg everything.


I like that type of thinking. All too often, people are just too lazy to make a little change to just do what is needed, and not all the stuff which "doesn't matter if it is done anyway" but which takes time. Then they sit there pressing enter every 20 seconds, hoping for a NOTIFY.

GuyC is off out the door with work done, whilst the "lazy" is still hard-at-it pressing enter :-)
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 Confusion b/w index and subscript Deepak kumar25 Mainframe Interview Questions 7 Thu Aug 31, 2017 6:50 am
No new posts SQL - select data available in index Nileshkul DB2 3 Mon Jun 26, 2017 1:30 am
No new posts setting new limit Key values for inde... srilata83 DB2 1 Fri Feb 10, 2017 9:24 pm
No new posts Order BY AND Index Nileshkul DB2 2 Sat Dec 31, 2016 6:33 pm
No new posts Several errors during building altern... Andi1982 JCL & VSAM 11 Wed Jul 06, 2016 7:39 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us