Results 1 to 8 of 8
  1. #1
    Join Date
    May 2004
    Posts
    25

    Unanswered: SQL0444N Routine "db2CfgSg" Error on V8.2

    Hi:
    We have a Windows 2000 Server box running with the latest service pack for version 8 (i.e. V8.2=v8.1.8.762).
    My problem is that when I try to run the Configuration Assistant for any given DB, it returns this error in the last step.

    SQL0444N Routine "db2CfgSg" [specific name "SQL050208135940020"] is implemented with code in library or path "\db2sg", function "db2CfgSg" which cannot be accessed reason code 4.

    Any idea..?

    Thanks....

  2. #2
    Join Date
    Mar 2004
    Posts
    448
    The SQL routine implementation has changed in 8.2.

    1. bind the package using db2rbind using all.
    2. Also check your db2diag.log file . You will get more information.

    regards

    Mujeeb

  3. #3
    Join Date
    May 2004
    Posts
    25
    bMujeeb:

    I am checking this tips.
    I'll let you know....

    Tnx.
    Last edited by javierfrank; 02-08-05 at 17:08.

  4. #4
    Join Date
    May 2004
    Posts
    25
    Here are my results:

    1) The command "db2rbind gtddb -l c:\log.txt all" is succesfully, but when I try to run Configuration assistant, it returns the same error from above (first post)

    2) I also checked db2diag.log and found no entries for this error.

    Any idea...

  5. #5
    Join Date
    Mar 2004
    Posts
    448
    I used it on solaris and the command was

    db2rbind <database_name > /l <logfile_name> all.

    I don't know what syntax you go with window, because of "/"

    regards

    Mujeeb

  6. #6
    Join Date
    Mar 2004
    Posts
    448
    Ok disregard my previous email.
    The problem is that library for that procedure is missing or not in their right
    place.The solution is to find the library name and path for that routine/procedure.


    regards

    Mujeeb

  7. #7
    Join Date
    Mar 2004
    Posts
    448

  8. #8
    Join Date
    May 2004
    Posts
    25
    OK. Thanks...
    very useful info.
    My DB2 Express Edition doesn't include those files..

Posting Permissions

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