Devart Forums

Hi,
i try run query
SELECT SCHEMANAME FROM SYSCAT.SCHEMATA

and i receive error
"
[IBM][CLI Driver][DB2/NT] SQL0443N Rutina "SYSIBM.SQLCOLUMNS" (specifický název "COLUMNS") vrátila chybový stav SQLSTATE s diagnostickým textem "SYSIBM:CLI:-727". SQLSTATE=38553
"
translate to english
"
[IBM][CLI Driver][DB2/NT] SQL0443N Routine "SYSIBM.SQLCOLUMNS" (specific name "COLUMNS") return error state SQLSTATE with diagnostic message "SYSIBM:CLI:-727". SQLSTATE=38553
"

I have all priviledges and when I try connect during ODBC(SQL direct component) it is OK.
I use D7 and win 7 64b.

Than you
Daril

Hello,

I cannot reproduce the problem. Try performing this query as a database administrator; if it is performed correctly, then you do not have sufficient priviledges.

Hi,
I'm login as administrator and still same error. I think it is not priviledge problem, because same query with other component(not unidac) is OK.
I hope with any settings of unidac.
Any suggestion?

Thank you Petr

Hello,

Unfortunately, we cannot reproduce this problem on our server. If you can provide us access to your server, we can try to reproduce this problem directly on your server.

That's what I found on an IBM forum, concerning the error 38553:

Bind the db2schema.bnd file against each database by entering the following commands at a command prompt:
db2 terminate
db2 connect to database-name
db2 bind path\db2schema.bnd blocking all grant public sqlerror continue
db2 terminate
where database-name is the name of the database to which the utilities must be bound, and path is the full path name of the directory where the bind files are located. For example, the default location on Windows® is C:\Program Files\IBM\SQLLIB\bnd\.