How to configure Sitescope to monitor all tablespace in DB2?
Version: HP SiteScope 11.10 32-bit JVM, Build 2929 DB2 version trying to monitor: DB2 v220.127.116.11
At Sitescope: Database Connection Test, by executing this query, notice that there are several table spaces e.g. table space id from 0 - 9 are listed. SELECT * FROM TABLE(SNAPSHOT_CONTAINER('GCMSSIT',-1)) AS SNAPSHOT_CONTAINER
When configure the monitor, I expect 10 table space names listed as the result of the SS monitoring since I can see there are 10 when executing query in Database Connection Test. However, notice that only the the readings of last table space is displayed as the result of SS monitoring.
How can I configure Sitescope to display the readings of each of the table space?
Re: How to configure Sitescope to monitor all tablespace in DB2?
As I understand, you want to increase the number rows returned in your query monitor. To return more results, set the following parameters in MASTER.CONFIG (and restart Sitescope). This is a performance intensive change, so increase this wisely only to a limited extent.