Unidac and db 9.0

Daril · Post by **Daril** » Tue 01 Nov 2011 12:42

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

AlexP · Post by **AlexP** » Wed 02 Nov 2011 15:45

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.

Daril · Post by **Daril** » Mon 07 Nov 2011 07:11

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

AlexP · Post by **AlexP** » Fri 11 Nov 2011 14:21

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.

davort · Post by **davort** » Mon 14 Nov 2011 10:37

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\.