DB2 Load uitlity JCL

IBM's flagship relational database management system

Re: DB2 Load uitlity JCL

Postby BillyBoyo » Tue Sep 01, 2015 12:43 pm

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.
Global moderator
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: DB2 Load uitlity JCL

Postby Terry Heinze » Mon Sep 14, 2015 7:15 pm

In the future, please use the Code tags to preserve character spacing.
.... Terry
Terry Heinze
Posts: 239
Joined: Wed Dec 04, 2013 11:08 pm
Location: Richfield, MN, USA
Has thanked: 12 times
Been thanked: 11 times

Re: DB2 Load uitlity JCL

Postby pranav283 » Mon Oct 12, 2015 4:27 pm

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>

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.
Posts: 47
Joined: Sat Aug 30, 2014 3:52 pm
Has thanked: 2 times
Been thanked: 0 time


Return to DB2


  • Related topics
    Last post