How to configure Sitescope to monitor all tablespace in DB2? (512 Views)
Reply
Occasional Collector
varmag
Posts: 2
Registered: ‎05-17-2012
Message 1 of 4 (512 Views)

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 v8.1.1.96


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?

Thanks,
Girish

Please use plain text.
Frequent Advisor
Tarif Louah
Posts: 57
Registered: ‎01-06-2010
Message 2 of 4 (504 Views)

Re: How to configure Sitescope to monitor all tablespace in DB2?

Try troubleshooting DB2 monitors :

 

http://support.openview.hp.com/selfsolve/document/KM189245 

 

Thx/Tarif

Please use plain text.
Occasional Collector
varmag
Posts: 2
Registered: ‎05-17-2012
Message 3 of 4 (502 Views)

Re: How to configure Sitescope to monitor all tablespace in DB2?

Hi Tarif,

 

I'm unable to access the link provided as I dont have a support contract information as I'm using an evaluation copy to try sitescope features. Can you please help me to solve this issue?

 

Thanks,

Girish

Please use plain text.
Honored Contributor
Rajasekhar Gundu
Posts: 1,085
Registered: ‎03-31-2008
Message 4 of 4 (476 Views)

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.

_databaseMaxColumns=10
_databaseMaxRows=10
_databaseMaxSummary=200


Regards,
Raj

Like this Post? Click Kudos! to show appreciation.
Is your issue addressed? Click "ACCEPT AS SOLUTION" against the post which helped you the most.
Please use plain text.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation