Search
Related topics are listed below.
Engine jobs
Using Control Center » Monitoring » Job concepts » Job types » Engine jobs
Engine jobs Each engine Job consists of a set of objects (procedures, tables, etc) that are installed on the monitored database instance. The main procedure will be triggered by the dbWatch Server, This procedure will then perform a check or collect statistics…
Control Center Jobs
Using Control Center » Monitoring » Control Center Jobs
Jobs (older dbWatch versions Tasks and alerts) are the cornerstone of the dbWatch Monitoring module. Jobs perform the actual monitoring of the database instance. There are two types of Monitoring in dbWatch. The Basic and Standard monitoring. To see each monitoring…
No-engine jobs
Using Control Center » Monitoring » Job concepts » Job types » No-engine jobs
No-engine jobs No-engine jobs consists of a series of steps (defined in xml files), and each step retreives data and/or performs some computation on the data. The last step will also set a status and a text describing the current state of the job. The steps can be a…
Jobs for PostgreSQL
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL
Control Center Jobs Description Availability Backup check – pg_dump Checks that there exists an up to date backup file. Backup check – WAL Checks that the WAL files have been backed up. DBMS…
Jobs for MySQL
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MySQL
Control Center Jobs Description Availability DBMS uptime Collects uptime statistics in the database. MySQL aborted connects Checking if there is many aborted connects MySQL max connections Checking if the system…
Jobs for MariaDB
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB
Control Center Jobs Description Availability DBMS uptime Collects uptime statistics in the database. Aborted connects alert Collects uptime statistics in the database. Maximum connections alert Collects uptime…
Jobs for Sybase
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Sybase
Control Center Jobs Description Availability Database backup Checks backup status of all databases. Database status Checks status of all databases defined on the system. The following incidents triggers a warning or an…
Example engine jobs
Customization » Monitoring » Editor for engine jobs » Example engine jobs
Example jobs To simplify development efforts for customers we provide example jobs with comments that should help development efforts. To use, right-click on the link and save as. Make sure its an xml file, with the name you want. You can edit it as its xml to change…
No-engine jobs
Customization » Monitoring » No-engine jobs
No-engine jobs No-engine jobs are monitoring jobs that does not run in the database engine. No-engine jobs are jobs that run on the dbWatch Server, and typically run a SQL statement and process the result of this statement in javascript. Example code for different…
Properties on Jobs
Advanced Topics » FDL – Farm Data Language » Available properties » Properties on Jobs
Jobs are available under instance through the task property server/instance[name = '...']/task The available properties are: Name Description Return type Typical values Extra name The name of the job String Blocking…
DBA jobs check
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » DBA jobs check
Name: Dba Jobs check Platform: Oracle Category: Availability Description: Detecting failed scheduled jobs in old style dba_jobs. Long description: The BROKEN column in the Oracle dictionary view DBA_JOBS is used…
Agent Jobs Check
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Agent Jobs Check
Name: Agent Jobs Check Platform: Sqlserver Category: Availability Description: Checks whether there exists jobs on the SQL server which have not been executed, or have failed during execution. Long description: …
Jobs for Oracle
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle
Control Center Jobs Description Availability Alert log check This check reads and looks for errors in the database alert log. Alert log check This check reads and looks for errors in the database alert log. Alert…
Editor for engine jobs
Customization » Monitoring » Editor for engine jobs
How to get here Example jobs We have some example jobs to make the development easier here. Edit Existing To edit an existing Task or Alert open the Task/Alert Editor by right clicking on any task or alert and select Edit task from the popup menu. Create new…
Install jobs with CCC
Advanced Topics » Control Center Commandline » Install jobs with CCC
Prerequisites Before installing jobs through CCC you need to go through the steps described in Setting up a CCC node ← Set metadata with CCC / Get instance configuration with CCC →
Jobs grouped by category
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by category
Jobs by category Jobs in Control Center are grouped by category to make it easier for users to locate the right monitoring job. The categories are: Availability Jobs that checks that the database and database related processes are functioning Capacity – Jobs…
Agent Jobs Check (MS2000)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Agent Jobs Check (MS2000)
Name: Agent Jobs Check (MS2000) Platform: Sqlserver Category: Availability Description: Checks whether there exists jobs on the SQL server which have not been executed or have failed during execution. Long…
Jobs grouped by platform
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform
Go to the individual platforms to see the jobs for that database platform Jobs for Oracle Jobs for MS SQLServer Jobs for MySQL Jobs for MariaDB Jobs for PostgreSQL Jobs for Sybase ← Control Center Jobs / Jobs for Oracle →
Jobs for MS SQL Server
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server
Control Center Jobs Description Availability Agent Jobs Check Checks whether there exists jobs on the SQL server which have not been executed, or have failed during execution. Agent Jobs Check for MS2000 Checks whether there…
Edit Report Templates
Using Control Center » Reporting » Edit Report Templates
Report Selection When you click on Server -> “Reporting” on the toolbar and then select “Edit Report Template”, you will see a list of all available report templates. Select the report template you wish to edit and click “OK”.…
Monitoring
Customization » Monitoring
Custom monitoring and editing monitoring jobs dbWatch has two types of monitoring jobs that can detect issues in the database instances. They are referred to as Engine jobs and “No-engine jobs”. Engine jobs are jobs that run inside the database engine,…
Job templates
Customization » Monitoring » Job templates
Creating templates Template functionality makes it possible to automate installation and configuration of jobs across the entire database farm you are managing. The configuration interface is available in the menu Server -> Server Configuration -> Edit job…
Properties
Customization » Monitoring » Editor for engine jobs » Properties
The properties section defines the main settings for the job. Once a job is created the “Task name”, “Company” and “Compatibility” is specified. “Task name” is the visible job name when you install a job or when its…
dbWatch alerts
Using Control Center » Management » Management on SQL Server » dbWatch alerts
dbWatch alerts is a list of monitoring jobs in the database in warning or alarm state for this database instance. Example: This is handy so you know you are working on the right database instance when you are correcting issues. You can interact with the…
Job menus
Using Control Center » Monitoring » Job menus
Each job has a set of menus. They can be accessed if you right-click on a job. This gives you several options. “Run now” will trigger the job now, outside of the normal schedule. “Details” will open the job report, providing details about…
Customization
Customization
dbWatch Control Center is designed to be customizable and much of the contents are developed inside the product In this section, we will go over how you can customize different parts of the product. To proceed, click on of the topics below: Customize dbWatch Views…
Customize View using FDL
Customization » Monitoring » Customize View using FDL
Before proceeding to this section, you must be familiar with Farm Data Language. To give you an overview, Farm Data Language is a type of query dbWatch uses to read and display data to its user. Think of it as your query tool when using dbWatch. How to edit…
Job types
Using Control Center » Monitoring » Job concepts » Job types
There are currently two types of jobs, engine jobs, and no-engine jobs. The main difference between them is where processing occurs. Engine jobs do the processing in the database instance engine, and no-engine jobs do the processing on the Control Center Instance…
Job concepts
Using Control Center » Monitoring » Job concepts
This section will try to explain more in-depth some of the concepts used in monitoring jobs in Control Center. There are currently two types of jobs, engine jobs, and no-engine jobs. The main difference between them is where processing occurs. Engine jobs do the…
Versioning
Using Control Center » Monitoring » Job concepts » Versioning
All jobs and most resource files in Control Center have a version to differentiate between new and old jobs. It is used to upgrade jobs, and most jobs are auto-upgraded. Engine jobs have upgrade scripts built in, to alter tables and update changes to PL/SQL or TSQL…
Instance details
Using Control Center » Monitoring » Instance details
When navigating to an individual database instance, you get the instance details overview: This dashboard is intended to give an overview of what monitoring jobs are installed and how they are performing. The top tabs let you switch between the instance details…
Parameters
Using Control Center » Monitoring » Job concepts » Parameters
Most of the monitoring jobs will have parameters. This is used controllable thresholds to adjust the monitoring job behavior and to better align it with the database instance and the preferences of the DBA. This is an example from the “Agent jobs check”…
Report
Using Control Center » Monitoring » Job concepts » Report
Each job has a job report that is generated when you use the job menu and choose “Details”. The job report, here an example from the CPU load details on Oracle, provides a set of graphs, pie charts, and tables. It uses previously generated history…
Installation of the Security and Compliance package
Installing and using premium packages » Security and Compliance package » Installation of the Security and Compliance package
Installation of the Security and Compliance package The Security and Compliance package is a premium package that comes with extra cost. If you want to get this package and its not part of your current license, please contact sales@dbwatch.com. To install the…
Pause
Using Control Center » Monitoring » Pause
Monitoring in dbWatch have two “levels” of pause. You can pause the monitoring on an instance altogether, meaning that the monitoring jobs will not execute. Or you can pause the alert forwarding, meaning that the jobs will execute but dbWatch will not send…
Consolidation
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by category » Consolidation
Jobs in the Consolidation category Control Center Jobs Description MS SQL Server Optional Database statistics This procedure gathers statistics per database.
Security and Compliance package on SQL Server
Installing and using premium packages » Security and Compliance package » Security and Compliance package on SQL Server
The Security and Compliance package The Security and Compliance package provides a detailed evaluation of your Microsoft SQL Server’s security and compliance, managed via dbWatch Control Center. It offers in-depth insights into your server’s security and…
Compliance
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by category » Compliance
Jobs in the Compliance category Control Center Jobs Description MS SQL Server Optional MS SQL Server patch status Checks latest updates for Microsoft SQL Server.
Job scheduling check
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Job scheduling check
Name: Job scheduling check Platform: Oracle Category: Availability Description: Detecting failed scheduled jobs. The STATUS column in the Oracle dictionary view DBA_SCHEDULER_JOB_RUN_DETAILS is used to detect scheduled jobs…
SQL Server Agent
Using Control Center » Management » Management on SQL Server » SQL Server Agent
SQL Server agent allows you to check the status of the agent, look into agent jobs and its statistics, and create new agent jobs. ← Security / Operating System Manager →
Migration
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by category » Migration
Jobs in the Migration category Control Center Jobs Description Oracle Optional Statistics migration Migrates statistics from a number of tasks from dbWatch version 12 to dbWatch CC. MS SQL…
Available properties
Advanced Topics » FDL – Farm Data Language » Available properties
Properties available on dbWatch Servers Properties on instances Properties available on jobs Properties available on internal ← orderby function / Properties on dbWatch Servers →
Adding a MySQL Instance
Using Control Center » Instance management » Adding a MySQL Instance
How to get here To open the “Add Instance Wizard”, click on the “Plus (+)” sign on the bottom left of the dbWatch Client. This will bring up the “Add Instance” wizard, which will guide you through the following steps. Select Instance Type and Input…
MV Refresh Group(s)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » MV Refresh Group(s)
Name: MV Refresh Group(s) Platform: Oracle Category: Cluster and Replication Description: Checks refresh date of scheduled jobs in refresh group(s). Long description: Task checks refresh date of all scheduled…
Job details
Using Control Center » Monitoring » Job details
When you click on one of the jobs in the job tree, you can see a more detailed job overview. The idea of this overview is to show current and historical state, configured parameters and how the job is behaving on other database instances. In the top left…
Adding a PostgreSQL Instance
Using Control Center » Instance management » Adding a PostgreSQL Instance
How to get here To open the “Add Instance Wizard”, click on the “Plus (+)” sign on the bottom left of the dbWatch Client. This will bring up the “Add Instance” wizard, which will guide you through the following steps. Select Instance Type and Input…
Set metadata with CCC
Advanced Topics » Control Center Commandline » Set metadata with CCC
Prerequisites Before settings metadata through CCC you need to go through the steps described in Setting up a CCC node Metadata is defined in a file (default “metadata.properties”) ← Add instance with CCC / Install jobs with CCC…
Cleanup MSDB history tables
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Cleanup MSDB history tables
Name: Cleanup MSDB history tables Platform: Sqlserver Category: Maintenance Description: This task deletes entries in the MSDB database history tables which holds statistics of backup/restore, jobs and maintenance plan…
Adding a SQLServer Instance
Using Control Center » Instance management » Adding a SQLServer Instance
How to get here To open the “Add Instance Wizard”, click on the “Plus (+)” sign on the bottom left of the dbWatch Client. Select Instance Type and Input Connection Details Specify the host and port number. dbWatch will attempt to…
Acknowledgement system
Using Control Center » Monitoring » Job concepts » Acknowledgement system
The acknowledgment system is designed to make sure that jobs that have had alarms in the past, but now have changed status, is known to the DBA. By default we list all un-acknowledged warnings or alarms in the “Alert Acknowledgement History” view. If…
Get instance configuration with CCC
Advanced Topics » Control Center Commandline » Get instance configuration with CCC
Prerequisites Before you can get instance configuration through CCC you need to go through the steps described in Setting up a CCC node Getting instance configuration get_instance.script has the following input parameters: server – specify server IP and port,…
Database uptime
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Database uptime
Name: Database uptime Platform: Oracle Category: Availability Description: Collects database uptime statistics for all instances mounted on the database. Long description: Collects database uptime statistics for…
Release notes
About dbWatch Control Center » Release notes
dbWatch Control Center (2024-03-11) Download Important note Linux release is available as an apt repository, see Linux install guide All clients and servers need to be upgraded in a multi-server setup before the connection will resume due to network…
Properties on Instances
Advanced Topics » FDL – Farm Data Language » Available properties » Properties on Instances
Instances are available under server through the instance property server/instance All instances have the following properties: Name Description Return type Typical values Extra name The given name of the instance String…
Dashboards
Customization » Web server » Dashboards
Dashboard overview The main page for the dashboards: User and login To view dashboards, you need to login with a user that has at least read privileges on web. Default dashboards These are the default dashboards: Instance status: This dashboard…
Property System
Customization » Property System
There are several types of properties in dbWatch. Predefined properties Predefined properties are always present. For example, instances have properties called name and host. For more details see available properties Metadata properties Metadata properties are…
Adding an Oracle Instance
Using Control Center » Instance management » Adding an Oracle Instance
Oracle Prerequisites !1. Oracle databases need to have a listener process running and also allow for an external login with sysdba user or user with enough privileges. 2. You need a privileged user, such as sys as sysdba, another user with sysdba privileges or…
DBMS uptime
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » DBMS uptime
Name: DBMS uptime Platform: Oracle Category: Availability Description: Collects uptime statistics in database. Long description: Task collects uptime statistics in…
Notes
Using Control Center » Monitoring » Job concepts » Notes
Notes on jobs are information that DBA’s and the Control Center system save to better document a system setup and known behaviour. When you open notes on a job, it will start off as a blank note. The top field is for personal notes and the contents are stored…
Control Center Commandline
Advanced Topics » Control Center Commandline
CCC.exe – the Control Center Commandline CCC.exe is a command intended to run on the commandline or terminal to trigger USL scripts. The intention of CCC is to use it for integration and automation purposes to access the capabilities of dbWatch for other 3rd…
Alert log check
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Alert log check
Name: Alert log check Platform: Oracle Category: Availability Description: This check reads and looks for errors in the database alert log. Long description: This check reads and looks for errors in the database…
Post implementation
Customization » Monitoring » Editor for engine jobs » Post implementation
“Post implementation “is used to do actions after implementation steps. It can be recompiling code, fixing issues in data, or adding data to tables. In this example, it is a procedure that goes through the parameters configured and makes sure they are…
Email and SMS
Customization » Extensions and 3rd party integrations » Email and SMS
Configure In the dbWatch Monitor, go to the “Server”->”Server Extensions” menu. An item called “E-mail extension” should now be visible (v 5.2 or later). To configure the extension, select it and click “Configure”. You should now see the initial…
Status
Using Control Center » Monitoring » Job concepts » Status
Jobs can have four different statuses. Additionally, the instance can have the “Lost connection” state, blue, that takes precedence over job statuses. Green for OK, Yellow for Warning, and Red for Alarm. Tasks can be without status, and the no-status icon…
Schedule
Using Control Center » Monitoring » Job concepts » Schedule
The scheduling in Control Center has two modes, cron schedule, and interval schedule. Cron schedule The cron schedule is loosely based on the crontab format used on Unix systems. We have 4 fields that can be set, “Minute”, “Hour”,…
Availability
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by category » Availability
Jobs in the Availability category Control Center Jobs Description Oracle Alert log check This check reads and looks for errors in the database alert log. Alert log check This check reads and looks for errors in the database…
Definition Mapping
Troubleshooting Guide » Definition Mapping
dbWatch 12 dbWatch Control Center Definition Changes Tasks and Alerts Jobs Tasks provide statistics and growth rates for your database, which allows for better planning and performance analysis of how your system is behaving.…
Installation of SQL Performance package
Installing and using premium packages » SQL Performance package » Installation of SQL Performance package
Requirements for installation dbWatch Control Center release 2022-09-29 / 501 or newer License that includes SQL Performance module. It can be as the separate “SQL Performance Package” license or as part of a larger licence package. It is included in…
Monitoring
Using Control Center » Monitoring
In this section, we’ll be familiarized with how the Monitoring Module works. When opening the monitoring module on its initial state, you get the status dashboard: The status dashboard is intended to provide a quick overview of the current state of your…
difference function
Advanced Topics » FDL – Farm Data Language » Functions » difference function
(Available from september 2023 release) The difference function finds the values that are in set A but not in set B Description Finds the difference of two sets Example Finds the elements in the first set that are not part of the second set. difference( …
Main procedure SQL Server
Customization » Monitoring » Editor for engine jobs » Implementation » Main procedure SQL Server
We will use the “Test alert” as example code, as its only purpose is to generate alarms and warnings, but uses many underlying functions. We go through it in steps, and include the full routine at the end. For historical reasons some code will refer to…
Management
Using Control Center » Management
In this section, we’ll be familiarized with how the Management Module works. Examples in this documentation are from Microsoft SQL Server, but this is available on all platforms, however, contents are platform and license dependent. When opening the management…
Maintenance
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by category » Maintenance
Jobs in the Maintenance category Control Center Jobs Description Oracle Framework Engine framework is used when upgrading earlier versions of dbWatch. Ensures the dbWatch Engine and dbWatch Server run compatible…
About dbWatch Control Center
About dbWatch Control Center
dbWatch Control Center is a highly scalable software solution that helps enterprises monitor and manage large database servers efficiently, providing total control over all database operations, performance, and resource usage. dbWatch Control Center will give you the…
The modules of Control Center
Using Control Center » The modules of Control Center
We have seven default modules available when you start dbWatch Control Center. This article will only introduce you to what these instances are and give a brief description of them. You need to be familiar with the navigation tree to better understand how these modules…
Cluster and replication
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by category » Cluster and replication
Jobs in the Cluster and replication category Control Center Jobs Description Oracle Blocking detector for RAC Checks if a session is waiting on a TX (transaction) lock. (RAC only) Memory session load for RAC Records the…
Privileges and actions map
Using Control Center » Domain Configuration » Privileges and actions map
Overview of actions and required privilege Instance is the specific database instance. Instance system is a predefined security group controlling the overall instance monitoring and management. Domain configuration is a predefined security group controlling the…
Reports
Customization » Reports
Before proceeding to this topic, you must be familiar with generating a report. You can check it out by click on the link. Customizing your Report by changing the logo and Company Name To customize, your report. First click “Server” on the upper ribbon of…
Using Control Center
Using Control Center
In this section, we will cover the user interface, the different modules, and how they are used. When we start dbWatch Control Center we will by default start-up in the monitoring view: We have the top menu, where we find the configuration of client connections…
Reporting
Using Control Center » Reporting
Control Center comes bundled with a series of report templates that you can use to generate standard reports on various aspects of your database environment. It also allows you to edit the templates or create your own for fully customizable reporting which will be…
Scheduled reports
Using Control Center » Reporting » Scheduled reports
Scheduled reports are defined to be generated at specified intervals, and can be automatically emailed to you when they are completed. Create a scheduled report To create a scheduled report see Generate Report. Configure a scheduled report Once a report has been…
Web configuration
Customization » Web server » Web configuration
To enable the Web server, go to the “Server” -> “Domain Configuration” menu. Expand the domain, Nodes, Server, and right-click on the server you want to run the webserver on. Select “Edit webserver” In the Configure…
Metadata properties
Customization » Property System » Metadata properties
You can put metadata on instances, and this metadata will be automatically available in FDL. To add metadata to an instance, right click on it and select “Configure”. Then click on the “Metadata” tab. Here you can add key/value pairs by…
Instance Configuration
Using Control Center » Instance management » Instance Configuration
How to get here Instance Configuration can be accessed by going to Server > Server Configuration > Instance Configuration, or by right clicking on an instance and selecting Configure Instance from the popup menu. Main view The instance configuration view consists…
Formatting table results
Customization » Management » Formatting table results
When you are displaying a table result based on an SQL query, you have the same render hints that are offered as part of dbwql. To use these hints, add a “result-table-format” tag to the result. select a, b, c from sometable TABLE …
Report
Customization » Monitoring » Editor for engine jobs » Report
The report section of a job is a lightweight version of the reporting engine in Control Center. It supports SQL queries that can be used in multiple output formats, such as graphs and tables. You can right-click on the “Report” item, add new…
Initial Domain Setup
Getting Started » Initial Domain Setup
All dbWatch Servers are part of a domain. This domain is unique for each customer and it is specified in the dbWatch license. Every dbWatch installation must have one of the dbWatch Servers specified as the Domain Controller. The first time a you start the dbWatch…
Maintenance periods
Using Control Center » Management » Management on SQL Server » Configuration » Uptime statistics » Maintenance periods
This is where you can add maintenance periods to correct the uptime report for known scheduled maintenance periods that should not count as part of the report. Right click on the maintenance periods to create a new known maintenance period. This allows you fine…
Properties on dbWatch Servers
Advanced Topics » FDL – Farm Data Language » Available properties » Properties on dbWatch Servers
The available properties for server are: Name Description Return type Typical values Extra name, displayname The name of the dbWatch Server Entity dbWatch Control Center instance All the instances…
Bulk installing instances
Using Control Center » Instance management » Bulk installing instances
CSV File Format You can add instances in bulk. The prerequisite is to have a CSV file with the following…
JDBC Properties
Using Control Center » Instance management » Instance Configuration » JDBC Properties
It is possible to set properties for the JDBC driver on specific instances. You can find this under “Advanced Driver Setup” when adding SQL instances or under “Edit parameters” in the JDBC panel in the Configure Instance dialog. The driver…
Anonymous webaccess
Customization » Web server » Anonymous webaccess
Configuring Anonymous Web Access in dbWatch This guide outlines the updated process for configuring anonymous web access in dbWatch. The configuration is now managed through the ‘tuning.properties’ file, which simplifies the setup process. Step 1: Create…
Exporting configuration from 12 to CC
Advanced Topics » Exporting configuration from 12 to CC
Exporting database instance configuration from dbWatch 12 to CC A version of 12.9.1 or above is needed for this. The idea is that you can export the instance configuration from a dbWatch 12.9.x installation to install the same instances in dbWatch Control Center, as…
Capacity
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by category » Capacity
Jobs in the Capacity category Control Center Jobs Description Oracle ASM disk statistics Checks ASM disks for status and statistics. ASM diskgroup space Checks ASM diskgroups space statistics. Monitor SYS.AUD$…
Importing resources
Customization » Importing resources
Much of the functionallity in dbWatch is defined in xml files, including report specifications, task specifictions and management specifications. That means that functionallity can be modified by supplying new xml files to dbWatch. There are two ways of doing…
Generate Reports
Using Control Center » Reporting » Generate Reports
When you click on Report Module, the report wizard will be started. In the first step you will be asked to select the database instance you wish to generate a report for. The instance that does not have a user/login set for generating the report content, will be shown…
Creating a user
Using Control Center » Domain Configuration » Managing users » Creating a user
To create a user, right click on the “Users” element in the tree in “Domain Configuration” This will open the add user dialog: Where you add a username and password: If you want to add a user that uses Active Directory for password…
Installing on Linux
Getting Started » Installing on Linux
dbWatch Server Prerequisites Installation of dbWatch on Linux requires X11 for the graphical installation. Installation executable will fallback to console installation if X11 is not available, otherwise console installation is available with -c switch after…
The property file format
Customization » Property System » The property file format
Any queriable node in the dbwatch server can have properties. These can be statically set values or dynamically created. This document describes the format used to define dynamic properties. The file header Oracle…
Performance
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by category » Performance
Jobs in the Performance category Control Center Jobs Description Oracle Blocking detector Checks if a session is waiting on a TX (transaction) lock. Buffer cache statistics Gets data cache statistics for buffer cache in…