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
[solved] DB2 SQL0443N problem on SYSIBM.SQLTABLES
Moderators: chulett, rschirm, roy
[solved] DB2 SQL0443N problem on SYSIBM.SQLTABLES
In theory there's no difference between theory and practice. In practice there is.