DBMS uptime
Job details
Name: |
DBMS uptime |
Platform: |
Sybase |
Category: |
Availability |
Description: |
Collects database uptime statistics. |
Long description: |
|
Version: |
1.2 |
Default schedule: |
* * * * |
Requires engine install: |
Yes |
Compatibility tag: |
.[type=‘instance’ & databasetype=‘sybase’]/instance[maj_version > ‘11′ & hasengine=‘YES’] |
Parameters
Name |
Default value |
Description |
dbw username |
dbwatch |
Database user name used by the dbWatch Server when connecting to the dbWatch Engine. |
dbw user id |
0 |
Database user id used by the dbWatch Server when connected to the dbWatch Engine. |
end availability timestamp |
00:00 |
Availability timestamp (hh:mm), used to define start of allowed DBMS shutdown period. |
end availability duration |
180 |
Availability duration in minutes, used to define length of allowed DBMS shutdown period. |
Job Summary
- Purpose: The primary purpose of this monitoring job is to collect and manage database uptime statistics for Sybase instances with a major version greater than 11 and having an engine specified. It helps in monitoring the availability and runtime of the database systems by tracking when the database starts, stops, and its activity in between.
- Why: This job is crucial for maintaining high availability and performance of the database systems. It informs the administrators about the uptime and downtime, enabling them to make necessary adjustments to improve efficiency and minimize disruptions.
- Manual Checking: To manually check database uptime, one can pull records from the uptime history and data tables using the following SQL commands:
SELECT * FROM dbw_dbms_uptime_data;
SELECT * FROM dbw_dbms_uptime_histr;
Job Technical Description
- This job is defined under the category “Availability,” making it a priority for maintaining the operational status of the database.
- The task object is identified as “dbw_dbms_uptime,” with a comprehensive set of dependencies to ensure data integrity and availability. Dependencies include:
- Tables: dbw_dbms_uptime_data, dbw_dbms_uptime_histr
Dependencies and Cleanup
Dependencies
Object |
Object Type |
Description |
dbw_dbms_uptime_data |
Table |
Primary data table for storing uptime events |
dbv_dbms_monitored |
View |
Aggregates monitored data over periods |
dbv_dbms_up |
View |
Summarizes periods when DBMS was up |
Cleanup on Failure
- The tasks include directives to drop procedures, tables, and views involved if failures occur, ensuring the system is not left in a cluttered state.
Implementation Details
- The job implementation includes detailed procedures for managing the collection of uptime data:
- Inserts event data into the uptime history and data tables.
Reporting
- The job utilizes the dbwatch control center’s reporting templates to visually represent uptime data through various views and summaries. These reports depict the uptime statistics, availability, and period analysis for effective monitoring.
- Tables within the report include metrics like total uptime, the period of monitoring, down times, and calculated uptime percentages for a comprehensive understanding of database availability.
Additional Notes
- This job, while robust, assumes that the database environment has certain configurations and permissions set, like providing necessary SELECT privileges to the procedure owner from SYS views and dynamic performance views, crucial for compiling and executing the involved tasks efficiently.