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’]

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.

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;

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

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

The tasks include directives to drop procedures, tables, and views involved if failures occur, ensuring the system is not left in a cluttered state.

The job implementation includes detailed procedures for managing the collection of uptime data:
Inserts event data into the uptime history and data tables.

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.

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.