Search
Related topics are listed below.
Domain Configuration
Using Control Center » Domain Configuration
How to get here The Domain Configuration can be accessed by going to Server > Domain Configuration. Overview The Domain Configuration dialog lets you configure domain-wide settings. The concepts listed for each domain on the left side tree are: Nodes –…
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…
Cloud router security
Product Overview » Architecture » Cloud router » Cloud router security
Introduction Robust Security Despite Exposure to Threats: Designed for internet accessibility, the cloud router operates under the assumption that it could be compromised. This perspective has shaped its security architecture to ensure that users remain protected,…
Fresh Installation of dbWatch Control Center
Troubleshooting Guide » Fresh Installation of dbWatch Control Center
After installing a newer version of dbWatch Control Center, you may encounter problems such as an expired license or a locked account due to forgetting the admin credentials. Here’s a simple guide on doing a fresh installation of dbWatch Control Center.…
Crypto catalog
Advanced Topics » Product Security » Crypto catalog
Crypto catalog The files in the config/crypto catalog are as follows: On the domain controller: File Description /ca/dbw_dc_cert.pem domain controllers certificate /ca/dbw_dc_pub.pem domain controllers public key …
User integration with Active Directory
Using Control Center » Domain Configuration » Managing users » User integration with Active Directory
The user integration with Active Directory offloads the password verification and storage from the dbWatch Control Center domain controller to Active Directory. Port openings To allow the correct communications between the dbWatch Server and the Active Directory…
Managing security groups
Using Control Center » Domain Configuration » Managing security groups
Security groups This is were you define the groups that users and roles can have privileges on. There are some predefined security groups: Security group name Privilege All instances A list of instances containing all instances added to…
Getting Started
Getting Started
Downloading the latest version of Control Center You can get a download link to the latest version of dbWatch Control Center by registering for a free evaluation copy Wait for dbWatch’s Confirmation Email. Follow the steps and link in that email. There are…
File Structure
Product Overview » File Structure
Files stored in the users home directory The dbWatch Monitor stores files in the “.dbwatch/.monitor/” catalog in the users home directory. This directory contains the following directories: config Config files crypto Cryptographic keys data Currently…
Service groups
Using Control Center » Instance management » Service groups
In dbWatch you can organize instances in servicegroups Instances placed in the same servicegroup should provide a common service of some sort. For example this can be instances belonging to the same cluster. Servicegroups may also be placed inside other…
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…
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…
Adding or changing license
Using Control Center » Domain Configuration » Adding or changing license
Adding or changing license To add or change the license, you need to start the domain configuration window. (Server->Domain Configuration) In this window, click on “Upload license” and point it to the license .json file you received from dbWatch.…
Certificate infrastructure
Advanced Topics » Product Security » Certificate infrastructure
Certificate infrastructure Domain root The root certificate of the domain. In order to be trusted by external domains this certificate must be signed by dbWatch. User identity certificate This certificate is used by the domain to sign user certificate…
Architecture
Product Overview » Architecture
Architecture components The dbWatch installation consists of three components: dbWatch Monitor/Client serves as the front-end GUI dbWatch Server is the core business logic and central hub of the system dbWatch Framework contains stored objects in the registered…
Managing users
Using Control Center » Domain Configuration » Managing users
Starting the domain configuration The user management is in the domain configuration. For specific privileges look at the Privilege and actions map ← Managing roles / Creating a user →
Adding SQLServer instances with kerberos
Using Control Center » Instance management » Adding a SQLServer Instance » Adding SQLServer instances with kerberos
Using the kerberos authentication option requires some additional setup. We need dbwatch user added to the domain: First we create a dbwatch user that is a normal domain user. We set a passord, and make sure it dont expire. And we must add this user to the…
Installing on Windows
Getting Started » Installing on Windows
dbWatch Server Prerequisites Windows Server (VMWare virtual server or AWS EC2 supported) Windows Server 2008, 2012, 2016, 2019, and 2022 Windows 10 or Windows 11 8 GB RAM 4 CPU cores 10 GB hard drive space dbWatch Engine Prerequisites 500 Mb free space in…
Managing nodes
Using Control Center » Domain Configuration » Managing nodes
Nodes In the node configuration there are 2 editable fileds. The displayname and the approved checkbox. This is were you approve new Servers that want to join the domain. In addition you can see the type (currently server and/or domaincontroller) and id for the…
Network and communications
Product Overview » Network and communications
Network and communications Default ports and protocol dbWatch Control Center uses by default port 7100/tcp for client to node and node to node connections. This can be configured to a different port. On each node there is a node.connections file that both lists what…
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…
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…
Managing roles
Using Control Center » Domain Configuration » Managing roles
Roles In the roles configuration you can add, delete and configure roles. In this example we have created a “Dev” role that has Read, Write and Configure on the security group “Test instances”, aswell as “Read” on “Dev…
Internal Control Center firewall
Advanced Topics » Internal Control Center firewall
The internal firewall Mostly used for advanced configurations, where nodes are placed in locations facing internet traffic, there is a built-in firewall in Control Center. You access the firewall configuration in the domain configuration dialog for each node.…
Console installation on Ubuntu
Getting Started » Installing on Linux » Console installation on Ubuntu
Before You Start Before installing the dbWatch Control Center, note that the installer requires root privileges. For simplicity, this documentation demonstrates steps executed as the root user. You may use ‘sudo’ as an alternative. This guide is for…
Example architecture designs
Product Overview » Architecture » Example architecture designs
Basic setup The most basic setup is where a dbWatch Server service is configured with all functions in the same node, and the client is either local or installed on a separate computer. Example drawing: The pictured architecture is similar to the design and setup…
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.…
Product Overview
Product Overview
Product Overview In Product Overview, we will look into architecture and structure and give an overview of how the application operates. Chapters: Architecture File Structure Network and communications Database Operations Philosophy Monitor Dashboards and…
Network Controls
Advanced Topics » Product Security » Network Controls
Network Controls dbWatch Control Center deploys several methods of network control. 1. Node authentication (clients and servers) using certificate infrastructure built up around the Domain CA system 2. The built-in firewall to restrict incoming connections on an IP…
Setting up a CCC node
Advanced Topics » Control Center Commandline » Setting up a CCC node
To setup a ccc node you first need to download the ccc scripts and extract them in a catalog that you want to be the ccc workarea. In the following example we have downloaded the scripts to “E:/tmp/scripts” and our Control Center installation is located in…
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…
Resetting dbWatch Control Center Admin Account
Troubleshooting Guide » Resetting dbWatch Control Center Admin Account
Before resetting your admin account, you must be familiar with your working directory. By default, dbWatch Control Center will create a directory in C:\ProgramData\dbWatchControlCenter .If you are not sure, you can open the dbWatch Logo or go to Help > About dbWatch.…
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…
concat function
Advanced Topics » FDL – Farm Data Language » Functions » concat function
Description Concats a number of strings Example Get all hosts and append the domain “.dbwatch.com” instance/concat(host, '.dbwatch.com') Syntax concat(string1, string2, …) ← trim function / capitalize function…
Product Description
Advanced Topics » Product Security » Product Description
Product Description dbWatch Control Center is a database operations software intended to monitor, manage, maintain and report on database instances across multiple database platforms and physical locations. A dbWatch Control Center environment has at its core a…
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…
Cloud router
Product Overview » Architecture » Cloud router
Introduction The dbWatch Control Center is structured around a network of nodes dedicated to managing server infrastructure. While these nodes effectively communicate within a single network, cross-network communication poses a unique challenge. To address this, we…
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,…
Register instance configuration with CCC
Advanced Topics » Control Center Commandline » Register 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 Registering instance configuration register_instance.script has the following input parameters: server – specify server IP…
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…
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…
Network Ports and Services
Advanced Topics » Product Security » Network Ports and Services
Network Ports and Services Default ports and protocol dbWatch Control Center uses by default port 7100/tcp for client to node and node to node connections. This can be configured to a different port. If enabled the webserver can run. Default port is 8080. On each…
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…
FDL with CCC
Advanced Topics » Control Center Commandline » FDL with CCC
Prerequisites Before running fdl through CCC you need to go through the steps described in Setting up a CCC node First we need to specify the fdl query to execute. This is done by editing the “fdl.script” file. The query is specified after the query?=…
Add instance with CCC
Advanced Topics » Control Center Commandline » Add instance with CCC
Prerequisites Before adding instances through CCC you need to go through the steps described in Setting up a CCC node The properties for the instance to add are defined in a file (default is “instance.properties”). The syntax is key/value pairs seperated…
Upgrade dbWatch
Using Control Center » Domain Configuration » Upgrade dbWatch
If you have dbWatch version 2023-06-27 or later, it is possible to semi automatically upgrade the dbWatch Servers. *Only available for Windows Servers. For linux, look here. In the Domain Configuration dialog, select the Upgrade tab. Click on the Check button to…
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…
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…
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…
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…
Graphical installation on Ubuntu
Before you start The installer for dbWatch Control Center requires root to run. However, when we want to run the software under a different user once installed. I will run all the first steps as user root for documentation simplicity. You can use sudo instead. This…
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…
Defining Autodiscover Ports
Using Control Center » Autodiscover » Discovering Database Instances » Defining Autodiscover Ports
By default autodiscover scans the following ports: MS SQL Server: 1433 Oracle: 1520, 1521, 1522, 1523, 1524, 1526, 1527 Sybase: 4998, 4999, 5000, 5001, 5002 MySQL: 3304, 3305, 3306, 3307, 3308 PostgreSQL: 5429, 5430, 5431, 5432, 5433, 5434 You can override the…
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…
Alert log check (8i)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Alert log check (8i)
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…
Listener log check (8i)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Listener log check (8i)
Name: Listener log check Platform: Oracle Category: Availability Description: This checks and reads errors from the database listener log. Using Oracle native code to read. Long description: This checks and …
Listener log check
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Listener log check
Name: Listener log check Platform: Oracle Category: Availability Description: This checks and reads errors from the database listener log. Using Oracle native code to read. Long description: This checks and …
Listener log check (10g)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Listener log check (10g)
Name: Listener log check Platform: Oracle Category: Availability Description: This checks and reads errors from the database listener log. Using Oracle native code to read. Long description: This checks and …
Listener log check (9i)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Listener log check (9i)
Name: Listener log check Platform: Oracle Category: Availability Description: This checks and reads errors from the database listener log. Using Oracle native code to read. Long description: This checks and …
Listener log check (11g)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Listener log check (11g)
Name: Listener log check Platform: Oracle Category: Availability Description: This checks and reads errors from the database listener log. Using Oracle native code to read. Long description: This checks and …
Alert log check (9i)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Alert log check (9i)
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…
Backup log check (old style 8i)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Backup log check (old style 8i)
Name: Backup log Check 8i(‘old style’ backups) Platform: Oracle Category: Availability Description: Checks for errors in a log file (e.i. backup log). For backups not using RMAN. Long…
Backup log check (old style 10g)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Backup log check (old style 10g)
Name: Backup log Check 10g (‘old style’ backups) Platform: Oracle Category: Availability Description: Checks for errors in a log file (e.i. backup log). For backups not using RMAN. Long description: …
Backup log check (old style 9i)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Backup log check (old style 9i)
Name: Backup log Check 9i (‘old style’ backups) Platform: Oracle Category: Availability Description: Checks for errors in a log file (e.i. backup log). For backups not using RMAN. Long…
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…
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”.…
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…
Export log Check (‘old style’ backups)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Export log Check (‘old style’ backups)
Name: Export log Check (‘old style’ backups) Platform: Oracle Category: Availability Description: Checks for errors in a log file (i.e. export log). Long description: Task checks for errors in the…
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…
FDL – Farm Data Language
Advanced Topics » FDL – Farm Data Language
Introduction to Farm Data Language Farm Data Language or FDL for short is the query language used in dbWatch to find information about objects. FDL is formerly known as DBWQL. This topic should be considered as the advanced part of dbWatch. It is also the central…