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
 

 

what is ONLINE REORG

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

New User


Joined: 03 Mar 2009
Posts: 10
Location: chennai

PostPosted: Wed Apr 22, 2009 10:05 pm    Post subject: what is ONLINE REORG
Reply with quote

what is online reorg and when we want to use. what was the diffrence between ONLINE REORG and REORG....
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: Wed Apr 22, 2009 10:08 pm    Post subject:
Reply with quote

Hello,

What does your dba say about this?
Back to top
View user's profile Send private message
kavinkumar_s

New User


Joined: 03 Mar 2009
Posts: 10
Location: chennai

PostPosted: Wed Apr 22, 2009 10:27 pm    Post subject:
Reply with quote

i'm reading newly, can tell about online reorg ?
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: Wed Apr 22, 2009 11:46 pm    Post subject:
Reply with quote

Hello,

Where are you reading this?

It may help if you post the link or some of the info found. Someone here may be able to clarify.
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: Fri Apr 24, 2009 12:31 am    Post subject:
Reply with quote

Hello,

Quote:
can you tell me how to run ONLINE REORG and when to run
It is best to continue discussion in the topic rather than via PM. PM limits a response to only one person, is not available to the rest of the forum, and may cause extended delay if the person is not available at that time.

As i asked before, where did you read this? If you post the link or some of the actual text, it will help someone help you.

Reorgs are a "single-user", background process, so i'm confused by the question.

As it has been over 24 hours and there have been no replies, i suspect that others who might be able to offer a suggestion are looking to you for more detail.
Back to top
View user's profile Send private message
Craq Giegerich

Senior Member


Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA

PostPosted: Fri Apr 24, 2009 1:08 am    Post subject:
Reply with quote

Reorg is listed in the DB2 Utilities Manual as an online utility. I have never seen an offline reorg refered to but I guess it would be an unload, sort of the unload, and reload with the sorted unload file.
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: Fri Apr 24, 2009 1:22 am    Post subject:
Reply with quote

Hello,

Quote:
but I guess it would be an unload, sort of the unload, and reload with the sorted unload file.
Yup, that is the way that every database system i've ever supported have performed reorgs (when reorgs were even done - usually not).

Of course, these were not db2 implementations - my clients could not afford to use db2 for large systems/databases because of the system and people overhead. . . Thanks to the bigger/faster cpus, the bigger/faster/cheaper dasd, and the long-in-arriving improvements in the db2 system, many larger projects are now possible.

What db2 considers "online" is not what most of us consider online. Most of us consider something running at a terminal as online. Here is what db2 says:
Quote:
DB2 online utilities run as standard batch jobs or stored procedures, and they require DB2 to be running. They do not run under control of the terminal monitor program (TMP); they have their own attachment mechanisms. They invoke DB2 control facility services directly.
From the DB2 V8 Utilities manual.
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 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
No new posts JES Dataset for Input to Online System amitc23 JCL & VSAM 1 Mon Apr 25, 2016 4:02 pm
No new posts GSAM from IMS online Appu IMS DB/DC 4 Tue Dec 29, 2015 6:25 pm


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