Spectrum Protect Database
PATROL Class: TSM_DATABASE - Monitor Type: MONITOR - Monitor Category: System
No CDM Class defined.
Monitors the server database related information.
By default, database monitoring is disabled on storage agents and in passive multi-node mode.
Attributes (Parameters)
| Name | PATROL Name | Units | Default Thresholds | Description |
|---|---|---|---|---|
| Backup Elapsed | TSMDatabaseBackupElapsed | hours | None | Displays the percentage of space used by the file system where the catalog database resides. Value set by TSMDatabaseCollector. Note: This parameter is only available for the server database (db). Type: Statistics - Spikes expected - Baselining allowed - Default graph |
| Buffer Request Count | TSMDatabaseBufferRequestCount | count | None | Displays the cumulative number of requests for database pages since the buffer pool was last reset (or since the server was last started). Value set by TSMDatabaseCollector. Note: This parameter is only available for the server database (db). Type: Statistics - Spikes expected - Baselining allowed |
| Cache Hit Percent | TSMDatabaseCacheHitPercent | % | None | Displays (as a percentage of the total number of requests) the number of requests for a database pages that are already in the buffer pool. Value set by TSMDatabaseCollector. Note: This parameter is only available for the server database (db). Type: Statistics - Spikes expected - Baselining allowed - Default graph |
| Cache Wait Percent | TSMDatabaseCacheWaitPercent | % | None | Displays (as a percentage of the total number of requests) the number of requests for database buffer pool pages where no pages are available, because all pages are in use. Value set by TSMDatabaseCollector. Note: This parameter is only available for the server database (db). Type: Statistics - Spikes expected - Baselining allowed - Default graph |
| Filesystem Space Used Percent | TSMDatabaseFSSpaceUsedPercent | % | WARN ALARM |
Monitors the percentage of space used by the file system where the catalog database resides. Value set by TSMDatabaseCollector. Type: Statistics - Spikes expected - Baselining allowed - Default graph |
| Log Consumed Size | TSMDatabaseLogConsumedSize | MB | None | Displays the cumulative consumption of log space used by the server since the last reset of this parameter. Value set by TSMDatabaseCollector. Note: This parameter is only available for the server recovery log (log). Type: Statistics - Spikes expected - Baselining allowed |
| Log Pool Used Percent | TSMDatabaseLogPoolUsedPercent | % | None | Displays (as a percentage of all recovery log buffer pool pages) the number of buffer pool pages used to write changes to the recovery log after a transaction is committed. Value set by TSMDatabaseCollector. Note: This parameter is only available for the server recovery log (log). Type: Statistics - Spikes expected - Baselining allowed - Default graph |
| Log Pool Wait Percent | TSMDatabaseLogPoolWaitPercent | % | None | Displays (as a percentage of all recovery log buffer pool requests) the number of requests for buffer pool pages where no pages are available because all pages are in use. Value set by TSMDatabaseCollector. Note: This parameter is only available for the server recovery log (log). Type: Statistics - Spikes expected - Baselining allowed - Default graph |
| Pool Hit Percent | TSMDatabasePoolHitPercent | % | None | Displays (as a percentage of the total number of requests) the number of requests for database pages that are already in the buffer pool. Value set by TSMDatabaseCollector. Note: This parameter is only available for the server database (db). Type: Statistics - Spikes expected - Baselining allowed - Default graph |
| Reorg Elapsed | TSMDatabaseReorgElapsed | hours | None | Displays the elapsed time since the last database reorganization. Value set by TSMDatabaseCollector. Note: This parameter is only available for the server database (db). Type: Statistics - Spikes expected - Baselining allowed - Default graph |
| Space Available | TSMDatabaseSpaceAvailable | MB | ALARM WARN |
Monitors the percentage of space used by the file system where the catalog database resides. Value set by TSMDatabaseCollector. Type: Availability - Spikes expected |
| Space Changed | TSMDatabaseSpaceChanged | MB | None | Displays the database pages (in megabytes) that have changed since the last backup. Value set by TSMDatabaseCollector. Note: This parameter is only available for the server database (db). Type: Statistics - Spikes expected - Baselining allowed |
| Space Changed Percent | TSMDatabaseSpaceChangedPercent | % | None | Displays the percentage of database pages that have changed since the last backup. Value set by TSMDatabaseCollector. Note: This parameter is only available for the server database (db). Type: Statistics - Spikes expected - Baselining allowed - Default graph |
| Space Growth Rate | TSMDatabaseSpaceGrowthRate | MB/s | None | Displays the growth rate of the space used by the catalog database. Value set by TSMDatabaseCollector. Type: Statistics |
| Space Max Extension | TSMDatabaseSpaceMaxExtension | MB | None | Displays the maximum amount the database can be extended by. Value set by TSMDatabaseCollector. Type: Statistics - Spikes expected - Baselining allowed |
| Space Max Reduction | TSMDatabaseSpaceMaxReduction | MB | ALARM WARN |
Displays the maximum amount the database can be reduced by. Value set by TSMDatabaseCollector. Type: Statistics - Spikes expected - Baselining allowed |
| Space Used | TSMDatabaseSpaceUsed | MB | None | Displays the amount of space used by the catalog database. Value set by TSMDatabaseCollector. Type: Statistics - Spikes expected |
| Space Used Percent | TSMDatabaseSpaceUsedPercent | % | WARN ALARM |
Monitors the percentage of assigned space used by the IBM Spectrum Protect server database. Value set by TSMDatabaseCollector. Type: Statistics - Spikes expected - Baselining allowed - Default graph |
| Summary | TSMDatabaseSummary | N/A | None | Summarizes the database information as reported in the commands executed by the data collector. Value set by TSMDatabaseCollector. Type: Text |