hi DBAs,

To take full advantage of HADR, I've finished upgrading our Web Sphere
application to use the new JDBC Type 4 Driver. The new driver consists of
an alternate server information which allows applications to be
automatically rerouted to the standby server if primary server has failed
over to the standby server.

To cut a long story short, I was able to complete this setup on all my
development and test databases except one.

WebSphere general.log has a message: does not have the privilege to
perform operation "EXECUTE" on object "NULLID.SYSSN200"

I did a quick fix by GRANT EXECUTE ON PACKAGE NULLID.SYSSN200 TO PUBLIC
and it seems to fix the database problem.

However, I'd like to get a better understanding of

who is NULLID?
what does package SYSSN200 do?
will BINDALL apply here?
is there something need to be done in the database when upgrading client
driver from version 7 to JDBC Type 4 driver?

It seems strange to me that this package is missing the grant in just one
database but not the other. It tells me a step was missed somewhere
earlier and now I'm paying for it :)

Thanks for your suggestion or pointing me in the right direction.

Regards
Ray

DB2 & UDB email list listserv db2-l LazyDBA home page