"EXECUTE" on object "NULLID.SYSSH200"

[liqunli]

Hi,

I am trying to execure a SELECT query thru my java application connecting to DB2 database, which is in AIX machine.
When i try to execute a query from my java application it's giving the following exception

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

What could be the problem?

 

[BrianTyler]

I seem to remember having problems in this area when converting from v7 to v8. Check for compatability between your ODBC version and the database.

 

[mixmouse]

I have the same problem. I just upgraded my DB2 connect from V7.2 to V8.1. After I rebind the DRDB datase, I still had the same error in WAS systemout.out logs. But I can connect to database and select data from db2 command line using the same user.

Is there anyone knows how to dis it?