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
 
How to do online REORGs? what risks and advantages in it

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

New User


Joined: 05 May 2006
Posts: 27

PostPosted: Wed Mar 14, 2007 7:07 am    Post subject: How to do online REORGs? what risks and advantages in it
Reply with quote

Can someone point me to a book on how to do online reorgs? what risks and advantages it may have versus offline reorgs.
Thanks
Back to top
View user's profile Send private message

wanderer

Active User


Joined: 05 Feb 2007
Posts: 199
Location: Sri Lanka

PostPosted: Wed Mar 14, 2007 12:16 pm    Post subject:
Reply with quote

DB2 developer's guide by Craig Mullins had a section on online reorg and how to do for it.

Although you can refer to IBM manual here for indepth coverage.
http://publib.boulder.ibm.com/cgi-bin/bookmgr/BOOKS/dsnugh18/2.21?DT=20061201100238

This doesn't separately discuss online-reorg, but rather uses various options of REORG control statement to tell you REORG as a complete utility.

The obvious advantage is that table can be accessed most of the time while the reorg is running. And if the utility fails due to some reason, the tablespace won't need to be recovered. So it is clean and cost of it is same as offline reorg.

I suppose disadvantage would be that you will require additional space amounting to the same that the original tablespace occupies. And there is a mapping table to be created.

There are several more restrictions and dependencies. See the manual above for more.
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 Writing a file using online program grvtomar PL/I & Assembler 3 Fri Jun 30, 2017 1:06 pm
No new posts Execute TSO ACF commands from COBOL-I... supreethi.srid TSO/ISPF 0 Tue Feb 21, 2017 5:19 pm
No new posts 24x7 online logs using DSN1LOGP (simi... SRICOBSAS DB2 3 Thu Aug 18, 2016 11:52 am
No new posts Updating online Db2 table kishpra DB2 3 Fri Aug 12, 2016 2:44 pm
No new posts Online Assembler Program Starting point Aditya.Srivastava PL/I & Assembler 4 Fri Jul 08, 2016 6:48 pm

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