[solved] DB2 SQL0443N problem on SYSIBM.SQLTABLES

[ogmios]

This is problem I already solved, but just in case someone else encounters the same (or I forget in a couple of months ).

In DataStage v7 in combination with DB2 v8 I got the following error message while importing table definitions:

DSR.MetaGeta(GET.TABLES)(SQLTables): BCI Error:
SQLSTATE=38553,CODE=-443,[DataStage][SQL Client][ODBC][IBM][CLI
Driver][DB2/SUN64] SQL0443N Routine "SYSIBM.SQLTABLES" (specific name "TABLES") has returned an error SQLSTATE with diagnostic text
"SYSIBM:CLI:-727". SQLSTATE=38553

Even giving the executing user DBA rights on the DB2 database did not help.

I found the solution after a while on the IBM DB2 support website as follows:

Cause
The db2schema.bnd file has not been bound to the database server.

Solution
To resolve the error perform the following steps from your client
machine:

1) cd to \sqllib\bnd directory (if on Unix /sqllib/bnd)
2) db2 connect to <database>
3) db2 bind db2schema.bnd blocking all grant public sqlerror continue
4) db2 terminate

Ogmios

[garthmac]

Thanks Ogmios

Your advice on this topic was very helpful. We had the same problem today, and thanks to DSXchange, this is no longer a problem.