471,075 Members | 667 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,075 software developers and data experts.

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
Jul 3 '08 #1
2 17178
check with !db2 ? sql0443 (if u havent)

Also please tell me if this one is a non fenced query or not ?
Jul 7 '08 #2
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
Jul 10 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.