|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.
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 connect to <database-name>
db2 bind /db2schema.bnd blocking all grant public sqlerror continue
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? Please add it below. Your name and tip will appear at the
end of the document text.