Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Need detail about DSNUTILB utility

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: Need detail about DSNUTILB utility
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    Post subject:
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: 238
Location: USA

PostPosted: Thu Mar 18, 2004 2:59 pm    Post subject:
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts DB2 - TERMINATE utility vasanthz DB2 5 Mon May 15, 2017 11:49 pm
No new posts Check if any Detail records and extra... V S Amarendra Reddy SYNCSORT 19 Mon May 08, 2017 8:54 pm
No new posts HLIST Utility In Batch Virendra Shambharkar TSO/ISPF 4 Fri Apr 07, 2017 3:38 pm
No new posts TSO or command line utility to genera... kishpra JCL & VSAM 3 Thu Mar 09, 2017 1:11 am
No new posts TAPE VERIFY utility?? MrExtraordinare JCL & VSAM 3 Fri Dec 09, 2016 10:57 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us