Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003

    Unanswered: 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?

  2. #2
    Join Date
    Sep 2003
    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 ?"

  3. #3
    Join Date
    Dec 2003
    Johannesburg, South Africa

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts