SQL Performance dashboard in DB2 cartridge does not display the Top SQL statements for DB2 versions below 9.7.0.10
An error in the FMS log similar to the following could be found when the DB2 dashboard was being accessed.
WARN [http-exec-3] script.dbwc_db2_activity_top_sqls_v20.getTopNSQLStatementsWithFilterSQLText - Find 0 topSQLObjects due to topSQLsTextMap is empty. paramStr:db2TopologyObject:foglight-5:DB2_Partition:615857b7-0065-43ab-aa42-58874765daaa:17 datasource=foglight-5:foglight-5, topN:25, topSQLsTextMap.size():0, specificTimeRange:June 21, YYYY 3:07:38 PM CST^&%June 21, YYYY 4:07:38 PM CST^&%-1^&%500.
WORKAROUND
None
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center