MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Information needed for jcl required for a db2 program

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database
View previous topic :: View next topic  
Author Message
coolguy2005
Beginner


Joined: 22 Mar 2005
Posts: 22
Topics: 16

PostPosted: Tue Mar 22, 2005 3:03 am    Post subject: Information needed for jcl required for a db2 program Reply with quote

I have a JCL coded like this , can anyone help me with the clarifications

Code:

//DXTV2     EXEC PGM=IKJEFT01,REGION=4096K
//DBRMLIB   DD  DSN=AVE3915.DBRM.LOADLIB,DISP=SHR
//DXTPRINT  DD  SYSOUT=(O,,J000)
//SYSTSPRT  DD  SYSOUT=(O,,J000),DCB=BLKSIZE=132
//SYSABEND  DD  SYSOUT=(O,,J000)
//SYSUDUMP  DD  SYSOUT=(O,,J000)
//DSNTRACE  DD  SYSOUT=(O,,J000)
//SYSOUT    DD  SYSOUT=(O,,J000)
//DXTDUMP   DD  SYSOUT=(O,,J000)
//DATAOUT1  DD  DSN=CLAS.SIG.DATA.UNLOAD,
//          DISP=(NEW,CATLG,DELETE),
//          UNIT=(SYSDA,5),
//          SPACE=(CYL,(500,100),RLSE),
//          DCB=(RECFM=FB,LRECL=129)
//SYSTSIN   DD  DSN=CLAS.PROD.CARDS(AWSRF110),DISP=SHR
//DXTIN     DD  DSN=CLAS.PROD.CARDS(AWSEDA1),DISP=SHR
/*

What does the following reserved words mean actually ?
Code:

DXTPRINT
SYSTSPRT
SYSABEND
SYSUDUMP
DSNTRACE
DXTDUMP
SYSTSIN
DXTIN


IN THE CARDS,when i open the member name ,the member contains as THE PLAN NAME IS NOT THE SAME AS THE PROGRAM NAME ? IS IT IS POSSIBLE & WHAT IS ITS SIGNIFICANCE ? WHY IS IT coded like that what does it mean ?


what is the meaning of SYSOUT=(0,,J000) this statement ?
Back to top
View user's profile Send private message
SureshKumar
Intermediate


Joined: 23 Jan 2003
Posts: 211
Topics: 21

PostPosted: Tue Mar 22, 2005 8:25 am    Post subject: Reply with quote

coolguy2005,
This is unfair. You cannot expect the forum to provide you all the information for every JCL card. Please refer to the JCL manual. Some of the JCL cards are just user provided DD names.
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose

PostPosted: Tue Mar 22, 2005 8:55 am    Post subject: Reply with quote

coolguy2005,


The DXTPRINT DD statement defines a required message data set. The DXTPRINT data set's record length (LRECL) must always be 121 bytes and cannot contain carriage control characters.

The SYSTSPRT DD statement specifies the print data set for TSO messages.

The SYSABEND DD statement specifies a dump data set in case of abnormal termination.

The SYSUDUMP DD statement defines a data set for a standard dump of the program's virtual storage in case of abnormal termination. The SYSUDUMP data set's record length (LRECL) must always be 121 bytes.

The DSNTRACE DD statement specifies the DB2 trace data set.

The DXTDUMP DD statement defines a data set in which the DEM records debugging information. This statement is required only if the DEBUG level is greater than 1 on the extract request or on the INITDEM command. The DXTDUMP data set's record length (LRECL) must always be 121 bytes; it cannot contain carriage control characters.

The SYSTSIN DD statement specifies a DB2 subsystem (DSN) and other information for execution (such as running DVRE0000, DSNTEP2, DSNTIAUL).

The DXTIN DD name identifies where to find the DXT commands you want executed.

Quote:

IN THE CARDS,when i open the member name ,the member contains as THE PLAN NAME IS NOT THE SAME AS THE PROGRAM NAME ? IS IT IS POSSIBLE & WHAT IS ITS SIGNIFICANCE ? WHY IS IT coded like that what does it mean ?


DXT is a very old program from IBM which extracts data from a Source Database or file and formats it for the target database or file. DXT uses the program DVRE0000 and the plan name is DXT. I guess back in those days , IBM did not have the naming convention of having the same plan name for its utilities. IBM no longer supports this utility. From the later releases IBM decided to have the same program name and plan for its utilities. You can notice that for DSNTEP2 AND DSNTIAUL utilities which are also data extraction utilities.
Quote:

what is the meaning of SYSOUT=(0,,J000) this statement ?


Check this link which explains the sysout parameter in detail along with examples.

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/IEA2B631/12.59?DT=20030423085347


Hope this helps...

Cheers

kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group