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

Pls help , unable to understand the following DB2 JCL


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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: 2146
Location: At my coffee table

PostPosted: Thu Apr 10, 2008 2:44 am
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
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: 2146
Location: At my coffee table

PostPosted: Thu Apr 10, 2008 3:21 am
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

Superior Member


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

PostPosted: Thu Apr 10, 2008 3:44 am
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
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
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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Infosphere Optim - unable to save Col... IBM Tools 0
No new posts Try to understand IMS control block IMS DB/DC 0
No new posts DFHCSDUP EXTRACT unable to open outpu... CICS 5
No new posts Unable to connect FTP over TLS from z... All Other Mainframe Topics 5
No new posts Unable to retrieve Datasets Names usi... CLIST & REXX 20
Search our Forums:

Back to Top