bluebird
Active User
.jpg)
Joined: 03 Feb 2004
Posts: 127
|
|
|
|
DSNUTILB is DB2 utilty-run pgm usually coded in a procedure (JCL)
here is an example of the above mentionned proc :
| Code: |
//DSNUPROC EXEC PGM=DSNUTILB,REGION=0M,
// PARM=(&SYSTEM,'&UID','&UTPROC')
//STEPLIB DD DSN=&LIB,DISP=SHR
//SYSPRINT DD SYSOUT=*
//UTPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//* END OF PROC
|
this utility is used to run checks, reorgs, or image copies.
and usually DSN1CPY is used to restore from image copies.
use TSO batch monitor pgm (IKJEFT01) to start, display or stop tables.
HERE IS AN EXAMPLE OF INLINE DSUNPROC PROCEDURE FOR IMAGE COPY :
| Code: |
//userid JOB (USERJOB,DBA),'IMAGE COPY',
// MSGLEVEL=(1,1),REGION=6M,NOTIFY=&SYSUID
//JOBLIB DD DSN=your-db2-lib,DISP=SHR
//COPY PROC
//DSNUPROC EXEC PGM=DSNUTILB,REGION=0M,
// PARM=(&SYSTEM,'&UID','&UTPROC')
//SYSPRINT DD SYSOUT=*
//UTPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSC0001 DD DSN=hlq.YR-BKP-FILE,
// DISP=(NEW,CATLG),LABEL=(1,SL),
// UNIT=3490,VOL=(PRIVATE,RETAIN)
// PEND
//*
//COPY1 EXEC PROC=COPY
//COPY1.SYSIN DD *
COPY TABLESPACE YR-TBSPACE-NAME DSNUM ALL COPYDDN SYSC0001
/*
|
dsnutilb IS USED for checks recover and repair
HOPE IT HELPS |
|
