Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2005
    Posts
    4

    Unanswered: 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.

  2. #2
    Join Date
    Apr 2005
    Location
    USA
    Posts
    130
    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.

  3. #3
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •