DB2 Load uitlity JCL
-
- Global moderator
- Posts: 3805
- Joined: Tue Jan 25, 2011 12:02 am
- Skillset: Easytrieve Plus, Cobol, Utilities, that sort of stuff
- Referer: Google
Re: DB2 Load uitlity JCL
Presumably DSNUTILB is not in the default search-chain for loadmodules. Talk to your support. They will know where it is and if you should be using it.
-
- Posts: 239
- Joined: Wed Dec 04, 2013 11:08 pm
- Skillset: COBOL, JCL, ISPF.
- Referer: While searching the Internet for answers.
- Location: Richfield, MN, USA
Re: DB2 Load uitlity JCL
gauravfrankly,
In the future, please use the Code tags to preserve character spacing.
In the future, please use the Code tags to preserve character spacing.
.... Terry
-
- Posts: 47
- Joined: Sat Aug 30, 2014 3:52 pm
- Skillset: JCL, COBOL, DB2, CICS, VSAM, MQ
- Referer: Internet
Re: DB2 Load uitlity JCL
Just a tip gaurav,
When you perform a load, make yourself aware of 'LOG' and 'ENFORCE' option of the Load's sysin card so that the tablespace (in which your table resides) doesn't land up in either check pending or copy pending statuses.
Moreover, I believe this is an incomplete JCL. You should accomodate the STEPNAME with suitable PARM parameters too, at least I do it.
For an instance, PARM=<DB2ID>, <UID>, <UTPROC>
where:
DB2ID = the DB2 system where you want your table to be 'loaded'
UID = a unique job identifier which is stored by SYSIBM.SYSUTIL table to store the metadata/status of the online utility that runs/once ran and successfully completed/ once ran but abended and so terminated explicitely.
UTPROC = signifies how and from which phase you want to execure/re-execute your job.
However, I believe the reason for S806- module not found is that you might have forgot to mention the load lib in your job/proc.
Please check whether in your environment, the load libraries are defined within an 'INCLUDE' group. If yes, then please include that in your jcl.
When you perform a load, make yourself aware of 'LOG' and 'ENFORCE' option of the Load's sysin card so that the tablespace (in which your table resides) doesn't land up in either check pending or copy pending statuses.
Moreover, I believe this is an incomplete JCL. You should accomodate the STEPNAME with suitable PARM parameters too, at least I do it.
For an instance, PARM=<DB2ID>, <UID>, <UTPROC>
where:
DB2ID = the DB2 system where you want your table to be 'loaded'
UID = a unique job identifier which is stored by SYSIBM.SYSUTIL table to store the metadata/status of the online utility that runs/once ran and successfully completed/ once ran but abended and so terminated explicitely.
UTPROC = signifies how and from which phase you want to execure/re-execute your job.
However, I believe the reason for S806- module not found is that you might have forgot to mention the load lib in your job/proc.
Please check whether in your environment, the load libraries are defined within an 'INCLUDE' group. If yes, then please include that in your jcl.
-
- Similar Topics
- Replies
- Views
- Last post
-
-
How to identify ASM load modules in a load lib
by Misha786 » Thu May 16, 2024 7:08 pm » in Assembler - 0
- 2357
-
by Misha786
View the latest post
Thu May 16, 2024 7:08 pm
-
-
-
Find the version of a cobol program through its load module
by vinigim » Fri Oct 30, 2020 3:16 am » in IBM Cobol - 5
- 5154
-
by chaat
View the latest post
Sat Nov 07, 2020 8:40 am
-