MVSFORUMS.com

Master

Hi all,

I am using BMCCOPY utility to copy the image copy of the database (i.e., copying the already taken primary image copy datasets into a tape). we do bring in the tapes to a different loaction to restore the database on a different subsystem (both are similar but on different systems). In this database all the tablespaces are non-partitooned except one table space. The partitioned tablespace has 31 partitions in it. We are planning to use BMCRECOV utility to restore the all the tablespaces (one step for each table space) in the remote location. In BMCRECOV, I am using the TOCOPY parameter to specify the imagecopy dataset to which the tablespace has to be restored. And using INCOPY parameter to specify the image copy dataset as it is not registered in DB2 catalogs of the remote DB2 subsystem. Here the problem is..I could not figure out how to specify all image copy datasets(31 datasets) for the partitioned tablespace in TOCOPY and INCOPY parameters. For non-partitioned datasets i can specify the single dataset name in INCOPY and TOCOPY parameters. Could you suggest me on how to specify the image the copy datasets in TOCOPY and INCOPY parameters for partitioned tablespace?

Thanks !! Smile

_________________
Enjoy learning. But don't be greedy of learning.

kolusu · Posted: Mon Mar 13, 2006 9:56 am Post subject:

Master,

Check these links for manuals which explains with examples pag3 53

RECOVER PLUS for DB2 Reference Manual

RECOVER PLUS for DB2 User Guide

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

Master · Posted: Mon Mar 13, 2006 10:58 pm Post subject:

I have read those manuals but could not find the required info from those.
_________________
Enjoy learning. But don't be greedy of learning.

abc2000 · Beginner Joined: 22 Mar 2006 Posts: 18 Topics: 9

you need write 31 lines RECOVER statement,
one for one data sets