If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > MainFrame MVS DB2 V6 Reorg Question

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 11-17-03, 16:23
midlothianjoe midlothianjoe is offline
Registered User
 
Join Date: Nov 2003
Posts: 1
MainFrame MVS DB2 V6 Reorg Question

Im setting up a DB2 reorg job for an application that has sveral Tablespaces. My question is there anyway to use VTS to stack all the sysrecs and sortout datasets on unit=vts. Is there a parameter to stop the opening and closing of the DSN while the reorg go from one tablespace to the next tablespace?
Reply With Quote
  #2 (permalink)  
Old 11-18-03, 14:54
gsreejith gsreejith is offline
Registered User
 
Join Date: Sep 2003
Location: Massachusetts
Posts: 27
I am not sure I understood what u wanted..

why do u need to bother abt stacking up SYSRECs for a Reorg ? As far a Reorg is considered, SYSREC is temporary. It just facilitates unloading and reloading of the data.
__________________
"It is Monday morning 3:02 AM. What is your SQL response time ?"
Reply With Quote
  #3 (permalink)  
Old 12-11-03, 05:45
tupiex tupiex is offline
Registered User
 
Join Date: Dec 2003
Location: Johannesburg, South Africa
Posts: 18
Unhappy DB2 Information

I think you are doing a REORG to tape, if this is the case you just need to ask the operators to stack your tapes that you create in there specific order,and then they will then automatically load as required.

I do not know whta the operator command is but they should be able to assign your job to a particular tape device.
__________________
Divvy
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On