Error while trying to access db2 mainframe tables

[shsandeep]

I am able to connect to a Z/OS thru an AIX gateway, but when I try to do

select 1 from sysibm.sysdummy1

I get the following error:

[IBM][CLI Driver][DB2] SQL0551N "AOPSXS" does not have the
privilege to perform operation "EXECUTE PACKAGE" on object
"NULLID.SYSSH200". SQLSTATE=42501

The Security team granted execute privilege on that package, but the
problem still persists.
Any thoughts on this?

Cheers,
San.

[Jeroen van den Broek]

"shsandeep" <sa**********@gmail.com> schreef in bericht
news:8d******************************@localhost.ta lkaboutdatabases.com...

I am able to connect to a Z/OS thru an AIX gateway, but when I try to do

select 1 from sysibm.sysdummy1

I get the following error:

[IBM][CLI Driver][DB2] SQL0551N "AOPSXS" does not have the
privilege to perform operation "EXECUTE PACKAGE" on object
"NULLID.SYSSH200". SQLSTATE=42501

The Security team granted execute privilege on that package, but the
problem still persists.
Any thoughts on this?

Cheers,
San.

I guess the packages for db2cli haven't been bound against the zOS database.
Try:
db2 bind @db2cli.lst grant public

--
Jeroen