Results 1 to 5 of 5
  1. #1
    Join Date
    May 2003
    Posts
    369

    Unanswered: sysfun error in DB2 UDB 7.2 on AIX 5.2

    We keep getting a sysfun.right error during processing when a stored procedure runs in our DB2 UDB 7.2 FP6 database on AIX 5.2L (both 32 bit) as follows:

    SQL0444N Routine "SYSFUN.RIGHT" (specific name "SQL0105151325") is implemented with code in library or path "...sqllib/function/db2clifn", function "CLI_udfRIGHT1" which cannot be accessed. Reason code: "9". SQLSTATE=42724


    Data TitleQLCA PID:112978 Node:000
    sqlcaid : SQLCA sqlcabc: 136 sqlcode: -444 sqlerrml: 70
    sqlerrmc: SYSFUN.RIGHT SQL0105151325 ...sqllib/function/db2clifn CLI_udfRIGHT1
    9
    sqlerrp : sqlriuld
    sqlerrd : (1) 0xFFFF877E (2) 0x00000000 (3) 0x00000000
    (4) 0x00000000 (5) 0x00000000 (6) 0x00000000
    sqlwarn : (1) (2) (3) (4) (5) (6)
    (7) (8) (9) (10) (11)
    sqlstate:

    Does anyone have any suggestions on how to resolve this problem with the stored procedure? Thanks!

    Scott

  2. #2
    Join Date
    May 2003
    Posts
    113

    Re: sysfun error in DB2 UDB 7.2 on AIX 5.2

    User Response: Given for each reason code:
    .....

    9 There was insufficient memory to
    resolve the function name
    function-code-id in the library identified
    in library-or-path. Contact the routine
    creator or your database administrator
    to make sure the library containing the
    function was correctly linked. The
    system configuration may need to be
    changed to make more memory
    available to DB2 Server.

    Originally posted by mixxalot
    We keep getting a sysfun.right error during processing when a stored procedure runs in our DB2 UDB 7.2 FP6 database on AIX 5.2L (both 32 bit) as follows:

    SQL0444N Routine "SYSFUN.RIGHT" (specific name "SQL0105151325") is implemented with code in library or path "...sqllib/function/db2clifn", function "CLI_udfRIGHT1" which cannot be accessed. Reason code: "9". SQLSTATE=42724


    Data TitleQLCA PID:112978 Node:000
    sqlcaid : SQLCA sqlcabc: 136 sqlcode: -444 sqlerrml: 70
    sqlerrmc: SYSFUN.RIGHT SQL0105151325 ...sqllib/function/db2clifn CLI_udfRIGHT1
    9
    sqlerrp : sqlriuld
    sqlerrd : (1) 0xFFFF877E (2) 0x00000000 (3) 0x00000000
    (4) 0x00000000 (5) 0x00000000 (6) 0x00000000
    sqlwarn : (1) (2) (3) (4) (5) (6)
    (7) (8) (9) (10) (11)
    sqlstate:

    Does anyone have any suggestions on how to resolve this problem with the stored procedure? Thanks!

    Scott

  3. #3
    Join Date
    May 2003
    Posts
    369

    thanks

    I checked the memory parameters in DB2 and reset the process and it ran fine. Thanks for the help

    -scott

  4. #4
    Join Date
    Mar 2004
    Location
    Hamburg Germany
    Posts
    5

    same Problem

    I have the same Problem with AIX5.2 and DB2 7.2.8.
    The Problem occurs only sometimes. If I use functions like replace or mod.
    When I restart the SQL mostly it runs correct.

    I thing some of the Memory Parameters have to change. can anyone help me which one ???

  5. #5
    Join Date
    May 2003
    Posts
    369

    sysfun errors and performance

    We solved this problem by changing the BUFFERPOOL size and several of the database instance parameters for shared memory.

Posting Permissions

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