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
 

 

Pls help , unable to understand the following DB2 JCL

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
sunny_io

New User


Joined: 11 Jul 2007
Posts: 68
Location: noida

PostPosted: Thu Apr 10, 2008 2:35 am    Post subject: Pls help , unable to understand the following DB2 JCL
Reply with quote

Hello All

i am quite new to jcl and db2 and having hard time understanding the following attached JCL which is a conversion job.
I get flat file from customer and load the db2 tables based on the data in it.

i have added my limited understanding of it in the document attached . pls correct me if i'm wrong and add further to it .

Solicited help is deeply appreciated.

Thanks a ton

i have attcahed the proc . the jcl is as follows

//SSS0900R JOB
// CLASS=G,MSGCLASS=9,NOTIFY=&SYSUID,
// REGION=0M,TIME=10,
/*JOBPARM COPIES=001,LINES=999
//JLIB JCLLIB ORDER=(EVJN.PROCLIB)
// INCLUDE MEMBER=UCSENV
// INCLUDE MEMBER=UCSSYMB3
// SET BKPTYPE='EOD' * BACKUP TYPE-'CNV' CONVERSION
// SET DAYN='2' * SYSTEM TEST DAY
// SET DYYMMDD='D080409B'
//JS010 EXEC UCS0900,
// GDG1='+1'
//PS005.SORTIN DD DSN=EVJN.P3.UCSEXID.D91CADI.SSS,BLKSIZE=,DISP=SHR
Back to top
View user's profile Send private message

CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2150
Location: At my coffee table

PostPosted: Thu Apr 10, 2008 2:44 am    Post subject: Re: Pls help , unable to understand the following DB2 JCL
Reply with quote

sunny_io wrote:
Code:
//SSS0900R JOB                   
// CLASS=G,MSGCLASS=9,NOTIFY=&SYSUID,       
// REGION=0M,TIME=10,                                               
/*JOBPARM      COPIES=001,LINES=999                                 
//JLIB  JCLLIB ORDER=(EVJN.PROCLIB)                                 
//     INCLUDE MEMBER=UCSENV                                       
//     INCLUDE MEMBER=UCSSYMB3                                     
//         SET BKPTYPE='EOD'       * BACKUP TYPE-'CNV' CONVERSION   
//         SET DAYN='2'              * SYSTEM TEST DAY             
//         SET DYYMMDD='D080409B'                                   
//JS010   EXEC UCS0900,                                             
//             GDG1='+1'                                           
//PS005.SORTIN DD DSN=EVJN.P3.UCSEXID.D91CADI.SSS,BLKSIZE=,DISP=SHR
It looks like normal JCL, listing the proc UCS0900 (probably in EVJN.PROCLIB) and the two includes (probably environmental definatins and additional symbols) would help you explain much....
Back to top
View user's profile Send private message
sunny_io

New User


Joined: 11 Jul 2007
Posts: 68
Location: noida

PostPosted: Thu Apr 10, 2008 3:17 am    Post subject: i have attached the proc as an attachment. pls chck that thx
Reply with quote

hello
the proc is attached with the post only

thanks
Back to top
View user's profile Send private message
CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2150
Location: At my coffee table

PostPosted: Thu Apr 10, 2008 3:21 am    Post subject: Re: i have attached the proc as an attachment. pls chck that
Reply with quote

sunny_io wrote:
the proc is attached with the post only
Without the full expansion, I don't think anyone can shed additional light on its function......
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Thu Apr 10, 2008 3:44 am    Post subject:
Reply with quote

Hi,

A little what I undestand..in this
Code:
//PS004   EXEC PGM=DSNUTILB


DSNUTILB is used to run checks, reorgs, or image copies and usually DSN1CPY is used to restore from image copies.

I think, above setp takes image copy of TABLESPACE of EVJNUCS3.DCSEK in the file against the DD name //DCSEK.
Back to top
View user's profile Send private message
sunny_io

New User


Joined: 11 Jul 2007
Posts: 68
Location: noida

PostPosted: Thu Apr 10, 2008 3:45 am    Post subject: HELP solicited on a db2 job
Reply with quote

hello

I just re attached the version which runs . the exact expanded version

though it looks fairly bulkier now. so iterating my questions here only
---------------------
Ps001 one just allocates the GDG’s , but how is it specified I don’t know ?
Where should I look for the parm = ‘ucsdummy’ ? any specific system library
As I understand Ikjeft01 is TSO batch processor and performs functions based on parm passed but with what kinof parm what happens , how can I learn about that
---------------------
PS002: the data in d090002 which is highlighted in yellow is
"DELETE ('"NVSM"."GRP"BDB2.DCSEK."BKTYPE||DAYN"."DYYMMDD"') NONVSAM"
I saw in spool when the job executes ,
DELETE ('EVJN.P3.BDB2.DCSEK.EOD2.D080409B') NONVSAM is what it converts to, hence this data set is deleted if its present.
-----------------------
ps003 :

I can’t seem to understand what this step is doing. How does one identify what does the parameters mentioned for IKJEFT01 mean
The data in d090003 is:
COPY TABLESPACE <UCS>.DCSEK COPYDDN DCSEK
<ucs> gets replaced by EVJNUCS3
And in d090060 is:
RECOVER TABLESPACE <UCS>.DCSEK TOCOPY <NVSM>.<GRP>BDB2.DCSEK.TYPEDAY.DYYMMDD
RECOVER INDEX (ALL) TABLESPACE <UCS>.DCSEK
REPAIR SET TABLESPACE <UCS>.DCSEK NOCHECKPEND

<NVSM>.<GRP>BDB2.DCSEK.TYPEDAY.DYYMMDD ->>>>>>>>>
CONVERTS TO ------ EVJN.P3.BDB2.DCSEK.EOD2.D080409B
----------------------------------------------

ps004 no idea abt it either
“COPY TABLESPACE EVJNUCS3.DCSEK COPYDDN DCSEK “
Is what we have in file &NVSM..&GRP.UCS0900.D91INP1

-----------------------------------------------
Ps005 sorts based on parameters in d090005

Ps010 executes program mentioned in d090010 and that program writes to all the sdbs mentioned as output files below. Based on data from D91CADI file.
i am ok withe these steps and further until ps060

------------------------------------------

PS060 :
Data in “NVSM..&GRP.UCS0900.D91INP2(&GDG1), : is

RECOVER TABLESPACE EVJNUCS3.DCSEK
TOCOPY EVJN.P3.BDB2.DCSEK.EOD2.D080409B
RECOVER INDEX (ALL) TABLESPACE EVJNUCS3.DCSEK
REPAIR SET TABLESPACE EVJNUCS3.DCSEK NOCHECKPEND


What does it indicate please explain, in ps060 don we need the files which we had made in ps010 as input.

What seems to be happening with DCSEK is also a mystery to me.

thanks for the help
Back to top
View user's profile Send private message
sunny_io

New User


Joined: 11 Jul 2007
Posts: 68
Location: noida

PostPosted: Thu Apr 10, 2008 3:48 am    Post subject: created a new thread to add the fresh attachment
Reply with quote

hello all

i have created another thread with a fresh attachment of the full expanded job titled "HELP solicited on a db2 job "

thanks for the help in advance.

Sunny
Back to top
View user's profile Send private message
sunny_io

New User


Joined: 11 Jul 2007
Posts: 68
Location: noida

PostPosted: Thu Apr 10, 2008 4:25 am    Post subject: help solicited on db2 job
Reply with quote

Hello All

i am quite new to jcl and db2 and having hard time understanding the attached JCL which is a conversion job.

the aim is : I get flat file from customer and load the db2 tables based on the data in it. I have attached the expanded version which runs also.

It looks fairly bulkier now. so iterating my questions here only
---------------------
Ps001 one just allocates the GDG’s , but how is it specified I don’t know ?
Where should I look for the parm = ‘ucsdummy’ ? any specific system library
As I understand Ikjeft01 is TSO batch processor and performs functions based on parm passed but with what kinof parm what happens , how can I learn about that
---------------------
PS002: the data in d090002 which is highlighted in yellow is
"DELETE ('"NVSM"."GRP"BDB2.DCSEK."BKTYPE||DAYN"."DYYMMDD"') NONVSAM"
I saw in spool when the job executes ,
DELETE ('EVJN.P3.BDB2.DCSEK.EOD2.D080409B') NONVSAM is what it converts to, hence this data set is deleted if its present.
-----------------------
ps003 :

I can’t seem to understand what this step is doing. How does one identify what does the parameters mentioned for IKJEFT01 mean
The data in d090003 is:
COPY TABLESPACE <UCS>.DCSEK COPYDDN DCSEK
<ucs> gets replaced by EVJNUCS3
And in d090060 is:
RECOVER TABLESPACE <UCS>.DCSEK TOCOPY <NVSM>.<GRP>BDB2.DCSEK.TYPEDAY.DYYMMDD
RECOVER INDEX (ALL) TABLESPACE <UCS>.DCSEK
REPAIR SET TABLESPACE <UCS>.DCSEK NOCHECKPEND

<NVSM>.<GRP>BDB2.DCSEK.TYPEDAY.DYYMMDD ->>>>>>>>>
CONVERTS TO ------ EVJN.P3.BDB2.DCSEK.EOD2.D080409B
----------------------------------------------

ps004 no idea abt it either
“COPY TABLESPACE EVJNUCS3.DCSEK COPYDDN DCSEK “
Is what we have in file &NVSM..&GRP.UCS0900.D91INP1

-----------------------------------------------
Ps005 sorts based on parameters in d090005

Ps010 executes program mentioned in d090010 and that program writes to all the sdbs mentioned as output files below. Based on data from D91CADI file.
i am ok withe these steps and further until ps060

------------------------------------------

PS060 :
Data in “NVSM..&GRP.UCS0900.D91INP2(&GDG1), : is

RECOVER TABLESPACE EVJNUCS3.DCSEK
TOCOPY EVJN.P3.BDB2.DCSEK.EOD2.D080409B
RECOVER INDEX (ALL) TABLESPACE EVJNUCS3.DCSEK
REPAIR SET TABLESPACE EVJNUCS3.DCSEK NOCHECKPEND


What does it indicate please explain, in ps060 don we need the files which we had made in ps010 as input.

What seems to be happening with DCSEK is also a mystery to me.

thanks for the help
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 I am unable to use SWAPBAR ON command... mrsidhu12 TSO/ISPF 3 Thu Sep 01, 2016 1:10 pm
No new posts Unable to view Unloaded file using DC... Rohit Umarjikar DB2 4 Thu Dec 31, 2015 6:46 pm
No new posts Need to understand SQLCODE = 12 rohanthengal DB2 3 Thu Nov 05, 2015 11:22 am
No new posts Need documents or links to understand... sherlinpraveenkumar IDMS/ADSO 5 Wed Oct 28, 2015 4:40 pm
No new posts REXX EDIT MACRO unable to handle doub... anjali.bisht TSO/ISPF 10 Thu Mar 12, 2015 4:55 pm


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