SAS and permissions

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Troels Arvin - 08 Jan 2007 12:41 GMT

Involved OS: AIX.
Involved DBMS: DB2 v8.1.1.96

User u1 can connect to DB d1 and run "LIST TABLES" without problem when
running from a terminal session. But when trying to work through SAS, he
gets the following error:

ERROR: Error retrieving table list: [IBM][CLI Driver][DB2/6000]
SQL0443N Routine "SYSIBM.SQLTABLES" (specific name "TABLES") has returned an error SQLSTATE with diagnostic text "SYSIBM:CLI:-805". SQLSTATE=38553

It seems that SAS would like to have special permissions to query the
SYSIBM.SQLTABLES routine. Does that make sense? How can I give the user
access through SAS? Does this indicate that something needs to be
installed or adjusted on the DB2 installation?

Signature

Troels Arvin

Reply to this Message

Ian - 11 Jan 2007 02:38 GMT

> Involved OS: AIX.
> Involved DBMS: DB2 v8.1.1.96
[quoted text clipped - 10 lines]
> access through SAS? Does this indicate that something needs to be
> installed or adjusted on the DB2 installation?

Troels,

It looks like you may need to BIND the database utilities to the
database. You can get more information about the -805 error code
by giving the command,

db2 "? sql0805n"

Good luck,

Reply to this Message