By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,071 Members | 1,244 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,071 IT Pros & Developers. It's quick & easy.

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

fahimghauri
P: 8
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
Share this Question
Share on Google+
2 Replies


P: 8
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

fahimghauri
P: 8
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.