IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

what is ONLINE REORG


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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

Moderator Emeritus


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

PostPosted: Wed Apr 22, 2009 10:08 pm
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
Reply with quote

i'm reading newly, can tell about online reorg ?
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


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

PostPosted: Wed Apr 22, 2009 11:46 pm
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

Moderator Emeritus


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

PostPosted: Fri Apr 24, 2009 12:31 am
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
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

Moderator Emeritus


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

PostPosted: Fri Apr 24, 2009 1:22 am
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Reorg abended with REASON=X'00E40347' DB2 2
No new posts Underscore was not populated to onlin... CICS 1
No new posts Trying to change copybook in online c... CICS 4
No new posts Batch call online program, EXCI task ... CICS 3
No new posts Error while trying to access Online I... CA Products 2
Search our Forums:

Back to Top