View previous topic :: View next topic
|
Author |
Message |
sunny_io
New User
Joined: 11 Jul 2007 Posts: 68 Location: noida
|
|
|
|
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 |
|
|
CICS Guy
Senior Member
Joined: 18 Jul 2007 Posts: 2146 Location: At my coffee table
|
|
|
|
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 |
|
|
sunny_io
New User
Joined: 11 Jul 2007 Posts: 68 Location: noida
|
|
|
|
hello
the proc is attached with the post only
thanks |
|
Back to top |
|
|
CICS Guy
Senior Member
Joined: 18 Jul 2007 Posts: 2146 Location: At my coffee table
|
|
|
|
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 |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
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 |
|
|
sunny_io
New User
Joined: 11 Jul 2007 Posts: 68 Location: noida
|
|
|
|
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 |
|
|
sunny_io
New User
Joined: 11 Jul 2007 Posts: 68 Location: noida
|
|
|
|
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 |
|
|
sunny_io
New User
Joined: 11 Jul 2007 Posts: 68 Location: noida
|
|
|
|
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 |
|
|
|