Sqlcode=-443, Sqlstate=38553 Sysibm:cli:-727

[fahimghauri]

Hi,

DB2 SQL Error: SQLCODE=-443, SQLSTATE=38553, SQLERRMC=SYSIBM.SQLCOLUMNS;COLUMNS;SYSIBM:CLI:-727, DRIVER=3.50.152


My developers receive this error trying to run queries on a DB2 V8.2 database on linux, through JDBC drivers, exactly like an IBM page describe this:

http://www-1.ibm.com/support/docview.wss?uid=swg1LI70279

But the strange thing is, that if the users has DBA authority then the error does not come. When I revoke DBA authority, the error appears.

Why this problem appear only related with DBA authority?

Please Help

Regards,
Fahim

[niladri123]

check with !db2 ? sql0443 (if u havent)

Also please tell me if this one is a non fenced query or not ?

[fahimghauri]

check with !db2 ? sql0443 (if u havent)

Also please tell me if this one is a non fenced query or not ?

Granting SELECT on SYSIBM tables solved the problem.

But. . .
It raised some more questions in my mind.

1. Why Non DBADM user requires access to SYSIBM tables (metadata)?
2. Why JDBC connection requires these privileges?
3. I have another server, On which same user exists, I have not explicitly granted select on sysibm tables to user on that server,
But even then the user can select on SYSIBM tables. Why it is so?

Regards,
Fahim