DSXchange

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

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.