Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / DB2 Topics / November 2007

Tip: Looking for answers? Try searching our database.

Question on health indicator

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
datapro01 - 26 Nov 2007 20:31 GMT
Running DB2 8.2.5 and 9 with fix pack 2.

Is there any way to update a table space level health indicator
command line or do you have to use the Health Monitor.

I want to shut down the ts.ts_op_status health indicator.

Thanks in advance.

Gerry
Serge Rielau - 27 Nov 2007 04:40 GMT
> Running DB2 8.2.5 and 9 with fix pack 2.
>
> Is there any way to update a table space level health indicator
> command line or do you have to use the Health Monitor.
>
> I want to shut down the ts.ts_op_status health indicator.

I inquired with the experts:
db2 update alert cfg for tablespaces using ts.ts_op_status set
thresholdschecked no

That turns it off for all tablespaces in the instance.  To turn it off
per tablespace, use the "for tablespace <name> on <db>" clause.

Cheers
Serge
Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.