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

DXT unload utility - DVRE0000


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

Active User


Joined: 28 Jan 2012
Posts: 316
Location: Room: TREE(3). Hilbert's Hotel

PostPosted: Thu Jul 07, 2016 4:56 pm
Reply with quote

Hi,

I came across this db2 program DVRE000 used in my shop. After searching i found out that its an obsolete IBM mutuality used for load/unlaod.

I need to replace this step with DSNTIAUL utility.

Code:
//XX8TEST EXEC PGM=IKJEFT01,DYNAMNBR=30,REGION=4096K       
//SYSPRINT DD  SYSOUT=*
//SYSDUMP  DD  SYSOUT=*
//SYSTSPRT DD  SYSOUT=*
//DSNTRACE DD  SYSOUT=*
//DSQPRINT DD  SYSOUT=*
//SYSOUT   DD  DUMMY                                       
//SYSTSIN  DD  *                                           
 DSN SYSTEM(XXXX) RETRY(0) TEST(0)                         
 RUN PROGRAM(DVRE0000) -                                   
     PLAN(DXT) -                                           
     LIBRARY('DB2.XXXXXXX.XXXX.DVRLOAD')                   
 END                                                       
/*                                                         
//TESTEXT  DD  DSN=XXXXXX.XX8TEST(+1),DISP=(,CATLG,DELETE),
//             UNIT=PRD,SPACE=(0,(200,100),RLSE),           
//             DCB=(DCO01.DSCB,RECFM=FB,LRECL=20,BLKSIZE=0)
//DB2LOAD  DD  DSN=XXXXXX.PROD.CNTLLIB(XXDUMMYJ),DISP=SHR   
//SYSIN    DD  DSN=XXXXXX.PROD.CNTLLIB(XX8TEST),DISP=SHR   


The job has one DD statment as

//DB2LOAD DD DSN=XXXXX.XXXX.CNTLLIB(XXDUMMYJ),DISP=SHR

This member XXXXX.XXXX.CNTLLIB(XXDUMMYJ) has a DSNUPROC step to repair the tablespace (remove the copy pending status) but I'm not sure how its being invoked. Could anyone please help me to understand the use of this D2LOAD statement. Is it just a dummy statement?

Unfortunately no one knows about it neither there are any documentation available at our shop

Could you please help me with where I can find more information about this utility?
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 3048
Location: NYC,USA

PostPosted: Thu Jul 07, 2016 11:40 pm
Reply with quote

5668-788 Data Extract (DXT) Version 2 Release 5 see if you get an understanding.
Quote:
but I'm not sure how its being invoked.

Should be by DVRE0000 but not in service since '99
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 Load new table with Old unload - DB2 DB2 6
No new posts Remote Unload of CLOB Columns DB2 6
No new posts Multiple table unload using INZUTILB DB2 2
No new posts REASON 00D70014 in load utility DB2 6
No new posts changing defaults in db2 admin - Unlo... DB2 0
Search our Forums:

Back to Top