Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Location
    kualaumpur
    Posts
    33

    Question Unanswered: SP deployment problem ..pls help !!!!

    OS : win XP
    Db2 udb v 7.2.8

    I have created SP sucessfully using Stoered proc builder but when trying to
    deploy using the command after connecting to DB

    db2 "get routine into test from procedure UPDATE_XYZ"

    i am getitng the ERROR....

    SQL1109N The specified DLL "SYSFUN.GET_ROUTINE_SAR" could not be loaded.

    i have checked the LIBPATH and setted to ...\sqllib\function
    but still the same ....


    Any help solving this will be highly appted.

    TIA

    Trinmoy

  2. #2
    Join Date
    Apr 2003
    Location
    Singapore
    Posts
    59
    Not sure if the below will help...

    got it from this link
    http://www.developer.ibm.com/tech/fa...al?oid=2:32279


    Why am I not able to use "GET ROUTINE" or "PUT ROUTINE" after applying a fixpack?

    A: After applying a fixpack to a v7.1 or v7.2 database you may get an error similar to the following: "SYSFUN.GET_ROUTINE_SAR" could not be loaded. There are several functions that require an update to the system catalog after a fixpack is installed. You may receive errors with built-in functions ABS, DECRYPT_BIN, DECRYPT_CHAR, ENCRYPT, GETHINT, MULTIPLY_ALT, and ROUND.

    The built-in procedures GET_ROUTINE_SAR and PUT_ROUTINE_SAR may not be enabled.

    To correct problems with these functions and procedures, you can run db2updv7 -d <db_name>. This executable will update the system catalogs to correct or enable these functions.

    Please be aware that the database cannot be used with an earlier version of DB2 after running this procedure. For more information see the release notes for the fixpack.

    cheers brat

  3. #3
    Join Date
    Nov 2003
    Location
    kualaumpur
    Posts
    33

    Thumbs up Thanks its works

    Millions thanks to you Brat....

    Its works according to ur suggestion ....solved the issue .

    Thanks once again....

    rgds

    Trinmoy

  4. #4
    Join Date
    Apr 2003
    Location
    Singapore
    Posts
    59
    glad to be of help.

Posting Permissions

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