-
Title
SQL Statements not appearing on Client Application Analysis drilldown or Top SQL -
Description
User had Spotlight on DB2 v 6.7.2 connecting to production database, Client Application screen shown data but Top SQL
If connected to QA database, it shown ok on both client application and Top SQL screens.
User has mentioned that his co-worker could see data on Top SQL screen because she had launched Spotlight before production database up.
User connected to production database and waited for 15 minutes, Spotlight shown data on Top SQL but client application did not show SQL statement.
It was a large database with many users.
-
Cause
Monitor heap size and asl heap size were too small
-
Resolution
STATUS
Waiting for a fix with CR 78700 on a future release of Spotlight on DB2.
WORKAROUND:
Suggest to review the DB2 documentation for recommendations on the asl_heapsz and mon_heapsz(http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.db2.udb.admin.doc/doc/r0000264.htm)
-
Defect ID
CR 78700