WinSQL » Knowledge base

Document information

Document ID: 746
Subject: Problems getting DB2 catalog information after applying 8.1 fixpack 10 or higher
Creation date: 7/29/09 11:22 AM
Last modified on: 7/29/09 11:23 AM


Problems getting DB2 catalog

When using DB2 for Linux Unix and Windows (LUW), if you upgrade to DB2 8.1 fixpack 10 (8.2 fixpack 3) or higher, you may get errors when you try to execute catalog calls such as SQLTables or SQLColumns. With WinSQL DB2 Wire Protocol, the error is:

[DataDirect][ODBC DB2 Wire Protocol driver][UDB DB2 for Windows, UNIX, and Linux]An error occurred executing function or procedure SYSIBM.SQLTABLES with the following parameters: (TABLES). Refer to the joblog for more information regarding the detected error. SYSIBM:CLI:-805

With the IBM DB2 CLI driver the error is:

[IBM][CLI Driver][DB2/NT] SQL0443N Routine "SYSIBM.SQLTABLES" (specific name "TABLES") has returned an error SQLSTATE with diagnostic text "SYSIBM:CLI:-805". SQLSTATE=38553

How to resolve this issue

This is a known issue documented on IBM's site: http://www-1.ibm.com/support/docview.wss?uid=swg21215626 .

You can resolve this issue by opening a DB2 command prompt and executing the following:

db2 terminate
db2 connect to <database-name>
db2 bind /db2schema.bnd blocking all grant public sqlerror continue
db2 terminate





Add a comment to this document

Do you have a helpful tip related to this document that you'd like to share with other users?

Important: This area is reserved for useful tips. Therefore, do not post any questions here. Instead, use our public forums to post questions.

Navigation

Social Media

Powered by 10MinutesWeb.com