| Author |
Message |
shakti
New User
Joined: 20 Jan 2004
Posts: 35
|
|
|
|
Hi Guru's,
Can you give me some useful references for DSNUTILB utility with examples.
Any sort of help will be highly appreciated.
Thanks
Shakthi |
|
| Back to top |
|
 |
References
|
 Posted: Tue Mar 16, 2004 6:36 pm Post subject: Re: Need detail about DSNUTILB utility |
|
|
|
|
bluebird
Specialist
Joined: 03 Feb 2004
Posts: 144
|
|
|
|
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 |
|
| Back to top |
|
|
mdtendulkar
Active User
Joined: 29 Jul 2003
Posts: 259
Location: USA
|
|
| Back to top |
|
|
|
|
|
