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 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: 1278
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: 7251

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 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
No new posts Drop building Alternate Index for a p... bhavin.mehta JCL & VSAM 6 Mon Jul 04, 2016 3:47 pm
No new posts VSAM Alternate Index in CICS jacobdng CICS 2 Fri May 06, 2016 1:41 pm
No new posts Rebuilding IMS secondary index withou... Hooman24 IMS DB/DC 6 Tue Mar 29, 2016 12:22 pm


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