DB2-Load Utility.

krunalbafna · Active User Joined: 18 Jan 2010 Posts: 143 Location: Pune

Hi,
While executing DB2 load utility-DSNUTILB, I am getting following:
OUTPUT START FOR UTILITY, UTILID = MODIFY
PROCESSING SYSIN AS EBCDIC
LOAD DATA INDDN SYSREC LOG NO RESUME YES INTO TABLE "ABC"."ABQ"
THE LOAD UTILITY IS PART OF A SEPARATELY LICENSED
PRODUCT WHICH WAS NOT FOUND ON THIS SYSTEM

The job is gettgin abended with MAXCC=8. May you help plz.

Krunal

enrico-sorichetti · Posted: Fri Nov 11, 2011 2:46 pm

dick scherrer · Posted: Sat Nov 12, 2011 12:04 am

Hello,

Are you using a job that has previously worked (i.e. is "standard" for the system or did you create your own?

If you have created your own, suggest you compare what you created against one that works correctly.

If the product is supposed to be "there" it may have been configured incorrectly or is "down" for some reason.

As always, your systemsupport people would be the best source of site-specific info.

db2sysdba.zos · New User Joined: 04 Oct 2011 Posts: 25 Location: INDIA

Hi krunalbafna,

"THE LOAD UTILITY IS PART OF A SEPARATELY LICENSED
PRODUCT WHICH WAS NOT FOUND ON THIS SYSTEM "

It means ,
"DB2 could not find the specified utility
in the load library concatenation specified in the
submitted JCL. The specified utility is part of an
optional feature of DB2."

So that you have to install optional utility feature (JDB991K)

I would recommend you to go through the following links.

publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=%2Fcom.ibm.db2z9.doc.ugref%2Fsrc%2Ftpc%2Fdb2z_utlpackaging.htm

www-01.ibm.com/support/docview.wss?uid=isg1_DB2910_JDB991K

Hope this will help you.