IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Need detail about DSNUTILB utility


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
shakti

New User


Joined: 20 Jan 2004
Posts: 42

PostPosted: Tue Mar 16, 2004 6:36 pm
Reply with quote

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
View user's profile Send private message
bluebird

Active User


Joined: 03 Feb 2004
Posts: 127

PostPosted: Wed Mar 17, 2004 6:14 pm
Reply with quote

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
View user's profile Send private message
mdtendulkar

Active User


Joined: 29 Jul 2003
Posts: 237
Location: USA

PostPosted: Thu Mar 18, 2004 2:59 pm
Reply with quote

Hello shakti,

Checkout the following link for more details.

DB2 Utility Guide & Referance

Hope this helps,

Regards
Mayuresh Tendulkar
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Unloading Data from DECIMAL(n,0) Colu... DB2 6
No new posts Any JCL or VSAM Utility to get number... JCL & VSAM 1
No new posts DATA SET LIST UTILITY screen TSO/ISPF 6
No new posts Which SORT utility can improve the Pe... DFSORT/ICETOOL 16
No new posts COBOL VS SORT Utility for file format... COBOL Programming 7
Search our Forums:

Back to Top