Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2004
    Posts
    67

    Answered: "Failed to get current schema" in db2diag.log

    DB2 9.7.6
    Windows 2008

    Since 2 days ago I receive messages like this in db2diag.log:

    2015-08-04-04.20.25.955000-240 I726841F408 LEVEL: Error
    PID : 7736 TID : 8572 PROC : db2bp.exe
    INSTANCE: DB2 NODE : 000
    APPID : 10.3.1.33.55423.150804082025
    EDUID : 8572
    FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
    MESSAGE : Failed to get current schema , -572, 0000000000000000, Detected in
    file:sqluimpp.C, Line:1157


    diaglevel is 3


    We changed on other servers from DB2 9.7.6 to 10.5.5 but not on this server.


    How can I fix this?

  2. Best Answer
    Posted by mark.b

    "sqlcode -572 is about inoperative package.
    Seems that some package needed for import is inoperative.

    Try to rebind the corresponding package list:
    Code:
    cd ~${DB2INSTANCE}/sqllib/bnd
    db2 connect to mydb
    db2 bind @db2ubind.lst blocking all grant public
    Then run some test import command to check if the import utility works."


  3. #2
    Join Date
    May 2012
    Location
    Canberra, Australia
    Posts
    176
    Provided Answers: 6
    hmm, might be worth a question via a service request
    Andy

    "All parts should go together without forcing. You must remember that the parts you are reassembling were disassembled by you. Therefore, if you can’t get them together again, there must be a reason. By all means, do not use hammer.” — IBM maintenance manual, 1975 "

  4. #3
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    sqlcode -572 is about inoperative package.
    Seems that some package needed for import is inoperative.

    Try to rebind the corresponding package list:
    Code:
    cd ~${DB2INSTANCE}/sqllib/bnd
    db2 connect to mydb
    db2 bind @db2ubind.lst blocking all grant public
    Then run some test import command to check if the import utility works.
    Regards,
    Mark.

  5. #4
    Join Date
    Nov 2004
    Posts
    67
    Thank you, Mark.

Posting Permissions

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