467,888 Members | 1,620 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,888 developers. It's quick & easy.

Error code when using DB2 Command Center

Hi ,

connect to Blah user blah using blah

------------------------------------------------------------------------

Database Connection Information

Database server = DB2/6000 7.2.3
SQL authorization ID = Blah
Local database alias = Blah
I recieved this error message when using the DB2 command center.

--------------------------- Command entered ----------------------------
select *
from Db2inst1.test
------------------------------------------------------------------------

SQL0551N "Blah" does not have the privilege to perform operation "EXECUTE"
on
object "NULLID.SQLC2D01". SQLSTATE=42501

It's weird because I can do anything with that account on Lotus Approach or
WinSQL.
Thank you for your help.
Nov 12 '05 #1
  • viewed: 5143
Share:
1 Reply
"Doug Ly" <de******@dev.null> wrote in message
news:GT******************@newssvr23.news.prodigy.c om...
Hi ,

connect to Blah user blah using blah

------------------------------------------------------------------------

Database Connection Information

Database server = DB2/6000 7.2.3
SQL authorization ID = Blah
Local database alias = Blah
I recieved this error message when using the DB2 command center.

--------------------------- Command entered ----------------------------
select *
from Db2inst1.test
------------------------------------------------------------------------

SQL0551N "Blah" does not have the privilege to perform operation "EXECUTE" on
object "NULLID.SQLC2D01". SQLSTATE=42501

It's weird because I can do anything with that account on Lotus Approach or WinSQL.
Thank you for your help.

Lotus is probably using the ODBC interface, and the Command Center is using
the CLI. Try rebinding the packages using the Client Configuration Assistant
or grant execute on the package to public (or whatever). The rebind should
have been performed with each fixpak upgrade, but it may have been missed.
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Andrew V. Romero | last post: by
1 post views Thread by Sean C. | last post: by
19 posts views Thread by Azzy | last post: by
reply views Thread by MrMoon | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.