If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > DB2 user function problem

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 06-08-06, 10:48
manshadi manshadi is offline
Registered User
 
Join Date: Aug 2005
Posts: 4
DB2 user function problem

Hi everybody
I try to run one user define function on db2 zos.
this function is one of the sample db2 function on dsn710.sdsnsamp.

when i try to run this function i got following message:
DSNT408I SQLCODE = -444, ERROR: USER PROGRAM DSN8DUTI COULD NOT BE FOUND
DSNT418I SQLSTATE = 42724 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNX9CAC SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 0 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'00000000' X'00000000' X'00000000' X'FFFFFFFF'
X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION

I checked sysibm.sysrutins it was ok and extername was correct.

please help me.
Reply With Quote
  #2 (permalink)  
Old 06-08-06, 15:11
schintala schintala is offline
Registered User
 
Join Date: Apr 2005
Location: USA
Posts: 119
This error can also occur if you are invoking a WLM-managed stored
procedure that is not APF authorized, and the DB2 load libraries are not
in the STEPLIB concatenation because they are being loaded from LINKLIST.
In this case, if you want the stored procedure program to run
APF-authorized, link-edit it with AC=1 into an MVS APF authorized library.
If you do not want the stored procedure program to run APF authorized, add
the DB2 load library to the STEPLIB concatenation of the JCL used to start
the WLM-managed address space.

Make sure your WLM JCL concatenated with the right step libs in your shop.
Reply With Quote
  #3 (permalink)  
Old 06-22-06, 04:23
manshadi manshadi is offline
Registered User
 
Join Date: Aug 2005
Posts: 4
Thanks for your help

I checked all of these parameters my problem does not have any of this problem.

please help me
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On