On the DB2 Instance Home Page - DB2 9.7, the Tablespace info is not displaying
Received the following alarm. "10/06/2010 10:37:08 [IBM][CLI Driver][DB2/AIX64] SQL0551N "FOGLIGHT" does not have the privilege to perform operation "EXECUTE" on object "NULLID.SYSSH200". SQLSTATE=42501",
From the logs you may see errors as such : DB2 SQL error: SQLCODE: -551, SQLSTATE: 42501, SQLERRMC: FOGLIGHT;EXECUTE;NULLID.SYSSH200
Grant the foglight user privilege EXECUTE on object NULLID.SYSSH200. The forcing grant permission is required since it is not working for some reason for "sysadm".
It is not related to our SQL's since it is a system collection, this is why it is related to IBM and not to us.
In addition it can be that our collections will start appearing if the execution will start working now but there is no guarantee.
If this doesn't work, IBM would need to get involved.