Question

DB2 image copy that is no longer in SYSCOPY on zOS operating system

DB2, SYSCOPY, z/OS

We have a tablespace that needs to be restored from an image copy which we have the problem is the image copy is not recorded in SYSCOPY. We also tried doing a UNLOAD FROMCOPY thinking if we got the data out of the image copy we would be able to load it back into the table. That also failed with message DSNU1227I DSNUULCB - THE CONTENT OF THE IMAGE COPY DATA SET IS INCONSISTENT WIH TABLE SPACE PRODDATA.CAC2006S. The backup was of the table we are trying to recovery but the entry in the SYSCOPY was removed I beleive this happened when we dropped above tablespace during a rerun of one of our batch jobs.

I am wondering if there is a way to record the image copy so DB2 will allow us to do the UNLOAD FROMCOPY or a RESTORE on the original tablespace.

Use the DSN1COPY Utility to copy the data back into the original tablespace. No translation required

or

Use the DSN1COPY utility to copy the data into a new tablespace from the Image Copy. You must know the old and new DBID, PSID and OBID

The Index Rebuild utility can be used to reconstruct the indexes.

To obtain the names, DBIDs, PSIDs, ISOBIDs, and OBIDs, run the DSNTEP2 sample application on both the source and target systems.
The following SQL statements yield the above information:
Note: The example for indexes yields the above information, along with an additional column of data.
Product-sensitive Programming Interface For table spaces:

SELECT DBID, PSID FROM SYSIBM.SYSTABLESPACE
WHERE NAME=’tablespace_name’
AND DBNAME=’database_name’;

SELECT NAME, OBID FROM SYSIBM.SYSTABLES
WHERE TSNAME=’tablespace_name’
AND CREATOR=’creator_name’;

|
|
For index spaces:
SELECT DBID, ISOBID, OBID FROM SYSIBM.SYSINDEXES
WHERE NAME=’index_name’
AND CREATOR=’creator_name’;