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
 
Recover tablespace from imagecopy

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

New User


Joined: 02 Feb 2010
Posts: 41
Location: Bangalore

PostPosted: Thu Jun 24, 2010 1:01 pm    Post subject: Recover tablespace from imagecopy
Reply with quote

Hi

Can anyone help me to know the syntax to recover the table space using DSNUTILB utility with imagecopy taken on tape?. (ex. How to give the volume serial number,unit etc).

I have used the below sysin card but its failed with message "-D2DC DSNUCATO - TOCOPY DATASET NOT FOUND".

RECOVER TABLESPACE RDBDByyy.RDBSxxxx TOCOPY
RDBP.PDSRB.N.RDBDByyy.RDBSxxxx.FULL
REBUILD INDEX(ALL) TABLESPACE RDBDByyy.RDBSxxxx

Where RDBP.PDSRB.N.RDBDByyy.RDBSxxxx.FULL is imagecopy on tape dataset.

I wanted to restore the tablespace with perticular imagecopy tape which was taken few days back(i.e not to Lastcopy).

Regards,
Chandra
Back to top
View user's profile Send private message

ashimer

Active Member


Joined: 13 Feb 2004
Posts: 551
Location: Bangalore

PostPosted: Thu Jun 24, 2010 3:57 pm    Post subject:
Reply with quote

TOCOPY RDBP.PDSRB.N.RDBDByyy.RDBSxxxx.FULL
TOVOLUME vol-ser
Back to top
View user's profile Send private message
chandraBE

New User


Joined: 02 Feb 2010
Posts: 41
Location: Bangalore

PostPosted: Thu Jun 24, 2010 4:07 pm    Post subject:
Reply with quote

Hi,

Thank you for the information. I had tried using the TOVOLUME option. But it did not work for me. As my dataset is a multivolume dataset and can you please tell me how to provide multivolumes here?

Regards,
Chandra
Back to top
View user's profile Send private message
guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Thu Jun 24, 2010 4:13 pm    Post subject:
Reply with quote

From the FM

Quote:
TOVOLUME
Identifies the image copy data set.
CATALOG
Indicates that the data set is cataloged. Use this option only for an image
copy that was created as a cataloged data set. (Its volume serial is not
recorded in SYSIBM.SYSCOPY.)
RECOVER refers to the SYSIBM.SYSCOPY catalog table during execution.
If you use TOVOLUME CATALOG, the data set must be cataloged. If you
remove the data set from the catalog after creating it, you must catalog the
data set again to make it consistent with the record for this copy that
appears in SYSIBM.SYSCOPY.
vol-ser
Identifies the data set by an alphanumeric volume serial identifier of its
first volume. Use this option only for an image copy that was created as a
noncataloged data set. Specify the first vol-ser in the SYSCOPY record to
locate a data set that is stored on multiple tape volumes.
Back to top
View user's profile Send private message
ashimer

Active Member


Joined: 13 Feb 2004
Posts: 551
Location: Bangalore

PostPosted: Thu Jun 24, 2010 4:32 pm    Post subject:
Reply with quote

Thanks guptae.
@chandra - hope you got your answer.
Back to top
View user's profile Send private message
chandraBE

New User


Joined: 02 Feb 2010
Posts: 41
Location: Bangalore

PostPosted: Thu Jun 24, 2010 5:03 pm    Post subject:
Reply with quote

Thanks guptae.

I have used below card still I am getting message "D2DA DSNUCATO - TOCOPY DATASET NOT FOUND"

RECOVER TABLESPACE RDBDBXXX.RDBSYYYY TOCOPY
RDBP.PDSRB.N.RDBDBXXX.RDBSYYYY .FULL,
TOVOLUME 668567
REBUILD INDEX(ALL) TABLESPACE RDBDBXXX.RDBSYYYY

668567 is the first volume I can see in SYSCOPY.

Can you please tell me anything I missed here?

Regards,
Chandra
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 how to recover an uncataloged VSAM da... archanamuthukrishnan All Other Mainframe Topics 4 Wed Jan 11, 2017 6:18 pm
No new posts Image Copy of a tablespace that conta... Robin Sulsona DB2 4 Thu Jun 02, 2016 1:47 am
No new posts IBMHPU - Tablespace and Imagecopy chaitanya bharath DB2 1 Fri Apr 15, 2016 5:54 pm
No new posts Query on Image Copy Tablespace and QU... vickey_dw DB2 3 Fri Oct 23, 2015 10:55 am
No new posts UNLOAD from Image Copy Tablespace wit... alluri12 DB2 5 Wed Sep 23, 2015 7:00 pm

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