Application Perf Mgmt (BAC / BSM) Practitioners Forum
Showing results for 
Search instead for 
Do you mean 

How to configure Sitescope to monitor all tablespace in DB2?

Occasional Collector

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

4 REPLIES
Valued Contributor

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

Occasional Collector

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

Highlighted
Honored Contributor Honored Contributor

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.
Regular Advisor

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

Hi , Can you please help me to get details from below url.

 

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