DB2-DSN1COPY-Useful Info

All you have to know on DSN1COPY

DSN1COPY - To Sample same DBID, PSID and OBID
//JS001 EXEC PGM=IKJEFT01,
// DYNAMNBR=20
//STEPLIB DD DSN=DB2SYS.PRODLIB,
// DISP=SHR
// DD DSN=DB2SYS.DSNLOAD,
// DISP=SHR
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSIN DD DUMMY
//SYSTSIN DD *
DSN SYSTEM(SSID) RETRY(2)
RUN PROGRAM(DSNTEP2) PLAN(DSNTEP2)
-STOP DATABASE(DBANAME) SPACENAM(TSNAME)
END
/*
//*
//JS002 EXEC PGM=DSN1COPY,
// PARM='CHECK,FULLCOPY,RESET'
//STEPLIB DD DSN=DB2SYS.DSNLOAD,
// DISP=SHR
// DD DSN=DB2SYS.DSNLOAD,
// DISP=SHR
//SYSUT1 DD DSN=IC dataset,
// DISP=OLD,
// VOL=(,RETAIN)
//SYSUT2 DD DSN=VCAT.DSNDBC.DBNAME.TSNAME.I0001.A001,
// DISP=OLD
//SYSPRINT DD SYSOUT=*
//*
//JS003 EXEC PGM=IKJEFT01,
// DYNAMNBR=20
//STEPLIB DD DSN=DB2SYS.PRODLIB,
// DISP=SHR
// DD DSN=DB2SYS.DSNLOAD,
// DISP=SHR
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSIN DD DUMMY
//SYSTSIN DD *
DSN SYSTEM(D2P2) RETRY(2)
RUN PROGRAM(DSNTEP2) PLAN(DSNTEP2)
-START DATABASE(DBANAME) SPACENAM(TSNAME)
END
/*


To Recovery data of droped table ( DDL backup is available)
If to different DBID,PSID and OBID

Query to get DBID, PSID and OBID for DSN1COPY from Catalog Table

SELECT S.DBNAME,S.NAME,T.NAME,S.DBID,S.PSID,T.OBID,P.PARTITION,
P.VCATNAME,S.SEGSIZE
FROM
SYSIBM.SYSTABLESPACE S,
SYSIBM.SYSTABLEPART P,
SYSIBM.SYSTABLES T
WHERE
S.DBNAME = 'DBNAME' ----> Give the database name here
AND S.DBNAME = T.DBNAME
AND S.NAME = T.TSNAME
AND S.DBNAME = P.DBNAME
AND S.NAME = P.TSNAME
AND T.TYPE ='T'
JCL Change :

Use PARM = 'FULLCOPY,OBIDXLAT,RESET' for DSN1COPY.

and

* SYSXLAT CARD
* 1 : SOURCE(SSID), TARGET(SSID) DATABASE (DBID) (DATABASE)
* 2 : SOURCE(SSID), TARGET(SSID) PAGE SET IDS (PSID) (TABLESPACE)
* 3 : SOURCE(SSID), TARGET(SSID) TABLES (OBID) (TABLE)
Example
//SYSXLAT DD *
316,316
07,45
08,49
//*



To get the DBDID ,PSID and OBID from the IC use DSN1PRNT utility
//DS1PRINT EXEC PGM=DSN1PRNT,
// PARM='FORMAT,PRINT'
//* PARM='FORMAT,NODATA'
//SYSPRINT DD SYSOUT=*
//SYSUT1 DD DSN=IC dataset,DISP=SHR

Get DBDID and PSID from HPGOBID (2 bytes each) and OBID from PGSOBD.