Search - EnterpriseManager 12

DBWQL – dbWatch Query Language

Advanced Topics » DBWQL – dbWatch Query Language

Introduction to dbwql Dbwql is the query language used in dbWatch to find information about objects. This topic should be considered as the advanced part of dbWatch. It is also the central part from which many features in dbWatch are based and should be learned by…

Modifying the dbWatch Server

dbWatch Server Configuration » Modifying the dbWatch Server

Adding custom spring beans to the dbWatch server dbWatch provides some javabased hooks for customizing the behaviour of the dbwatch server. These hooks are injected into the server by the spring framework. Follow these steps to install custom classes into dbWatch…

About dbWatch

dbWatch is a highly scalable software solution helping enterprises monitor and manage large numbers of database servers efficiently, providing total control over all aspects of operation, performance and resource usage. dbWatch will give you the total overview you need…

dbWatch Navigation

In this section we will learn how to navigate and use functions within your dbWatch monitor.

Upgrading dbWatch

dbWatch Download and Installation – Getting Started » Upgrading dbWatch

dbWatch tests and supports upgrades from 11.x or 12.x to 12.x only. If you have an older installation, it is recommended that you remove the old dbWatch installation and schema in the database and install the latest dbWatch release. Steps for upgrade Contact dbWatch…

dbWatch Notes

dbWatch Navigation » dbWatch Notes

dbWatch allows you to attach notes to tasks, instances and servers. You can access the notes dialog by right clicking on a instance/task/server, and selecting “Notes” on the menu, The notes dialog has two tabs, one for public notes (visible to all…

dbWatch Logs

dbWatch Server Configuration » dbWatch Logs

Default setup [Users home]/monitor.log: The monitor will log events to this log. [install dir]/server.log : The server will log events to this log file. Eventlog: On windows systems the server will log login events, failed login events and disconnects to the…

Modifying dbWatch

Setup and Usage » Configuration » Modifying dbWatch

Adding custom spring beans to the dbWatch server dbWatch provides some javabased hooks for customizing the behaviour of the dbwatch server. These hooks are injected into the server by the spring framework. Follow these steps to install custom classes into dbWatch…

dbWatch Extensions

Advanced Topics » dbWatch Extensions

dbWatch supports many 3rd party products and external services. dbWatch currently provides these extension plugins: Email SMS HP Openview Nimsoft BigBrother Huntsman Nagios System Center Operations Manager IBM Tivoli Other systems trough SNMP Not all…

Overview of dbWatch

This topic will be covering setup and methods for the way we at dbWatch consider setting up dbWatch for Database Operations in the best possible way. It will be based on experience from our customers as well as our own database operations team. Architecture Tasks…

dbWatch Monitor Setup

This section contains information regarding the setup and usage of the dbWatch monitor.

dbWatch Server Configuration

Server Configuration The Server Configuration can be accessed through the Server->Server Configuration->Server configuration menu. The configuration values control the following: session-timeout: How long (in seconds) a session (SQL Worksheet) can be inactive…

Backup of dbWatch

Troubleshooting » Backup of dbWatch

When we think about backup of dbWatch, this involves several different parts of the software and installation: dbWatch Server and configuration files dbWatch Server is installed in a directory which is normally /usr/local/dbWatch/[version] on Unix/Linux and…

Devops with dbWatch

Database operations and devops Traditionally database operations has been a highly specialized field within it-operations. So much so that many organizations operate with platform specific dba teams. Because of the amount of platform specific know-how needed to…

Download and install dbWatch

dbWatch Download and Installation – Getting Started » Download and install dbWatch

Download dbWatch Instructions and license key will be sent thru your email when you sign up on this link – Get started with dbWatch The dbWatch installer can be downloaded here About the architecture dbWatch is a distributed system that consists of two…

dbWatch installation on Ubuntu

dbWatch Download and Installation – Getting Started » Installing on Linux » dbWatch installation on Ubuntu

Step by step guide To start off, prepare the installation directory of dbWatch. Execute the following commands: Create a new directory for dbWatch: sudo mkdir –p /usr/local/dbWatch Then input the root or super user password. Change the owner of the…

dbWatch Monitoring and Reporting

In this section we will learn how to monitor performance and generate reports with dbWatch.

Restore dbWatch configuration backup

Troubleshooting » Restore dbWatch configuration backup

The configuration files in dbWatch are continously backed up using git. Reverting to an old backup Step one If you don’t have git tools installed, you can download them here Step two After stopping the dbWatch Server, use a command prompt (that understands…

Adding instances with existing dbWatch schema

dbWatch Monitor Setup » Adding instances with existing dbWatch schema

If you have a database instance with an existing dbWatch schema and you want to use this you have to first add the instance with only the “Administration” module. Follow the normal procedure for adding the instance (click “Add” on the main…

dbWatch Download and Installation – Getting Started

In this section we will learn the supported platforms of dbWatch. dbWatch Prerequisites Before diving into installing dbWatch on your system, make sure that you have complied to the necessary requirements provided which you can access by opening the link…

dbWatch installation on Red Hat Enterprise Linux 8.1

dbWatch Download and Installation – Getting Started » Installing on Linux » dbWatch installation on Red Hat Enterprise Linux 8.1

Create the directory by executing the command: sudo mkdir –p /usr/local/dbWatch Change the owner of the directory: sudo chown dbwatch.dbwatch /usr/local/dbWatch Download the installer file by running the command (the file will be saved on your current…

Adding a new server to your dbWatch monitor

dbWatch Server Configuration » Adding a new server to your dbWatch monitor

dbWatch Monitor supports connecting to multiple monitors, which can be handy in setups where you have two seperate networks and need the databases in both networks monitored. This setup requires that the machine running dbWatch Monitor can see both the dbWatch Server…

Creating a custom dbWatch view using existing performance scripts

dbWatch Monitor Setup » Creating a custom dbWatch view using existing performance scripts

In this section we will learn the step by step process on how you can create a custom view using dbWatch properties and your existing monitoring scripts. In this example we will be creating a dbWatch property and sub properties which will be used to create a custom…

Protecting the communication

dbWatch Server Configuration » Protecting the communication

This page describes the communication between the dbWatch Monitor and the Server. The default setup To ensure the privacy of the user sessions, dbWatch wraps all communication between the monitors and the servers in ssl. During installation the installer generates…

The FString format

Development in dbWatch » The FString format

The FString format. FString is a format created to extract data from complex data structures in order to create well-formed files or strings. The basic FString - Any string is considered an FString. - Any parts of the string starting with ‘{$’ and…

The FString format

Advanced Topics » The FString format

The FString format. FString is a format created to extract data from complex data structures in order to create well-formed files or strings. The basic FString - Any string is considered an FString. - Any parts of the string starting with ‘{$’ and…

Protecting the communication

Setup and Usage » Configuration » Protecting the communication

This page describes the communication between the dbWatch Monitor and the Server. The default setup To ensure the privacy of the user sessions, dbWatch wraps all communication between the monitors and the servers in ssl. During installation the installer generates…

Formatting the output

Advanced Topics » Command Line » Formatting the output

Some dbWatch command line commands outputs table data. These commands have a parameter -format which lets you specify the output format of the command. The -format parameter refers to a set of user defined formats stored in the /.dbwatch/formats/ folder. The ability…

The property file format

Advanced Topics » 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…

The property file format

Development in dbWatch » 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…

Formatting tables results

dbWatch Navigation » Edit Management » Formatting tables 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 …

Formatting table results

Development in dbWatch » Edit 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 …

Property System

Advanced Topics » Property System

There are several types of properties in dbWatch. Predefined properties Predefined are always present. For example, instances have properties called name and host. Metadata properties Metadata properties are manually assigned to particular objects in dbWatch (like…

Property System

Setup and Usage » Property System

There are several types of properties in dbWatch. Predefined properties Predefined are always present. For example, instances have properties called name and host. Metadata properties Metadata properties are manually assigned to particular objects in dbWatch (like…

Modifying Monitoring View

dbWatch Monitoring and Reporting » Monitoring » Modifying Monitoring View

On the right side in the Monitoring tab, there are two different views. An instance view and a task view. Wich one depends on the selection in the navigation tree on the left side. Both these views can be modified by right clicking on the header, and selecting…

Modify Monitoring View

Setup and Usage » Modify Monitoring View

On the right side in the Monitoring tab, there are two different views. An instance view and a task view. Wich one depends on the selection in the navigation tree on the left side. Both these views can be modified by right clicking on the header, and selecting…

Instance Configuration

dbWatch Monitor Setup » Instance Configuration

How to get here The instance configuration view can be accessed by clicking on the Instances icon on the main toolbar, or by right clicking directly on an instance and selecting Configure from the pop-up menu. Main view The instance configuration view consists of…

Instance Configuration

Setup and Usage » Instance Configuration

How to get here The instance configuration view can be accessed by clicking on the Instances icon on the main toolbar, or by right clicking directly on an instance and selecting Configure from the pop-up menu. Main view The instance configuration view consists of…

Web Data Export

dbWatch Server Configuration » Web Server » Web Data Export

You can export data from dbWatch through http for easy access by others (tools or humans). Data can be made available in several formats, most notably html, json and csv. To create a simple export containing an overview of your environment, click “New” in…

CLI Examples

Advanced Topics » Command Line » CLI Examples

Moving an instance from Server A to Server B Get the configuration from the source server The following command gets the configuration of the instance called “MyInstanceName” from the local dbWatch Server and puts it in the file instance.xml dbw get -url…

Web data export

Setup and Usage » Web server » Web data export

You can export data from dbWatch through http for easy access by others (tools or humans). Data can be made available in several formats, most notably html, json and csv. To create a simple export containing an overview of your environment, click “New” in…

Dynamic Properties

Advanced Topics » Property System » Dynamic Properties

Dynamic properties are defined in xml files located in the [dbWatch Server]/server/resources/properties/ catalog. You cannot add files to this catalogue manually, but import them by placing them in the [dbWatch Server]/server/resources/import_area catalog. Examples…

Dynamic properties

Setup and Usage » Property System » Dynamic properties

Dynamic properties are defined in xml files located in the [dbWatch Server]/server/resources/properties/ catalog. You cannot add files to this catalogue manually, but import them by placing them in the [dbWatch Server]/server/resources/import_area catalog. Examples…

Tree Navigation

dbWatch Navigation » Tree Navigation

In the tree structures that you will find throughout dbWatch there are 2 components that lets you group and filter instances. On the top of the tree you have a “Grouping” panel that is minimized by default, and below that you have the quick text based…

Tree navigation

Setup and Usage » Tree navigation

In the tree structures that you will find throughout dbWatch there are 2 components that lets you group and filter instances. On the top of the tree you have a “Grouping” panel that is minimized by default, and below that you have the quick text based…

Item active

Development in dbWatch » Edit Management » Item active

You can hide or disable elements (typically nodes or menu items) by using the item-active tag You can specify multiple item-active tags, and all of them have to resolve to “active” in order for the element to be classified as active. The item-active tag…

Item active

Advanced Topics » Item active

You can hide or disable elements (typically nodes or menu items) by using the item-active tag You can specify multiple item-active tags, and all of them have to resolve to “active” in order for the element to be classified as active. The item-active tag…

Example: Restrict access to instances

Setup and Usage » Operator Configuration » Example: Restrict access to instances

Scenario I have a consultant coming in to do some work on our Oracle instances. I want to create a user for him so that he can only modify the Oracle instances. Solution First, to have a secure setup make sure that at least the following objects are secured. (Any…

Kerberos configuration

Advanced Topics » Kerberos configuration

The dbWatch server can be configured to authenticate to Oracle databases using Kerberos. Create a kerberos config file. Create a vmoptions file telling dbwatch where to find the kerberos config. If you want to authenticate using a ticket cache use the kinit…

Example: Restrict access to instances

dbWatch Monitor Setup » Operator Configuration » Example: Restrict access to instances

Scenario I have a consultant coming in to do some work on our Oracle instances. I want to create a user for him so that he can only modify the Oracle instances. Solution First, to have a secure setup make sure that at least the following objects are secured. (Any…

Database Centric Alerts for SQLServer

dbWatch Navigation » Tasks and Alerts » Database Centric Alerts for SQLServer

Instance Level Alert Except for Oracle platform all the dbWatch Alerts are returning status on the instance level and not on the database level. Although some of the dbWatch Alert return status about individual databases (like database backup or status) only one…

Commands

Setup and Usage » Commandline » Commands

help Prints out a manual page in the console Example dbw -h ping Checks if a dbWatch server accepts a login. -l -login Username used to authenticate. -p -password Password used to authenticate. -url The address of a dbWatch…

Commands

Advanced Topics » Command Line » Commands

help Prints out a manual page in the console Example dbw -h ping Checks if a dbWatch server accepts a login. -l -login Username used to authenticate. -p -password Password used to authenticate. -url The address of a dbWatch…

Web Dashboard

dbWatch Server Configuration » Web Server » Web Dashboard

The web dashboard feature To enable the web based dashbord, select “New” in the “Configure WebServer” view. This will bring up the “New url” dialog. Specify an url for the dashboard and select no.dbwatch.dashboard:dashboard as…

Web dashboard

Setup and Usage » Web server » Web dashboard

The web dashboard feature To enable the web based dashbord, select “New” in the “Configure WebServer” view. This will bring up the “New url” dialog. Specify an url for the dashboard and select no.dbwatch.dashboard:dashboard as…

Stacked Area Chart

dbWatch Navigation » Edit Management » Result Types » Graphical » Stacked Area Chart

Here is an example of a stacked area chart showing the relationship between active and inactive sessions over time. The specification for this chart: select number_of_processes_active as "Active", number_of_processes_total - number_of_processes_active as…

Stacked area chart

Development in dbWatch » Edit Management » Result types » Graphical » Stacked area chart

Here is an example of a stacked area chart showing the relationship between active and inactive sessions over time. The specification for this chart: select number_of_processes_active as "Active", number_of_processes_total - number_of_processes_active as…

Integrating with Active Directory

Setup and Usage » Configuration » Integrating with Active Directory

Setting up Active Directory authentication By default dbWatch authenticates users using it’s own internal username/password database. This section describes how to add Active Directory as a second user authentication provider. Connect to the server with the…

Integrating with active directory

dbWatch Server Configuration » Integrating with active directory

Setting up Active Directory authentication By default dbWatch authenticates users using it’s own internal username/password database. This section describes how to add Active Directory as a second user authentication provider. Connect to the server with the…

Release notes

About dbWatch » Release notes

New in dbWatch 12.9.2 17. Apr. 2023 – ( Download ) New features support for MS SQL Server 2022 support for Postgres 15 Improvements MS SQL Server -new version of “MS SQL Server patch status” (2.0) job – added patches up to 15th Mar.…

Issues and fixes

Troubleshooting » Issues and fixes

High CPU usage on database Occasionally when investigating resource-consuming SQL statements running on your system, you may find that some of them belong to the dbWatch application. For example, a SQL statement that has the highest value of spent CPU time. In most…

Issues and troubleshooting

Setup and Usage » Issues and troubleshooting

High CPU usage on database Occasionally when investigating resource-consuming SQL statements running on your system, you may find that some of them belong to the dbWatch application. For example, a SQL statement that has the highest value of spent CPU time. In most…

Tasks and Alerts

dbWatch Navigation » Tasks and Alerts

Tasks and Alerts are the cornerstone of the dbWatch Monitoring module. Tasks and Alerts perform the actual monitoring of the database instance. There are two types of Tasks and Alerts. The Standard Tasks and Alerts, and the Advanced Tasks and Alerts. Standard…

File Structure

Overview of dbWatch » File Structure

Files stored in the users home directory The monitor stores most of it’s configurations in the .dbwatch/monitor/ in the users home directory. This directory contains the following files: monitor.xml Stores various settings and preferences for the…

Configuration

Setup and Usage » Configuration

Server Configuration The Server Configuration can be accessed through the Server->Server Configuration->Server configuration menu. The configuration values control the following: session-timeout: How long (in seconds) a session (SQL Worksheet) can be inactive…

Edit tasks and alerts

dbWatch Navigation » Edit tasks and alerts

How to get 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 To create a new Task or Alert from scratch, go to the Manage tasks and alerts…

Edit Report Templates

dbWatch Monitoring and Reporting » Reporting » Edit Report Templates

Report Selection When you click on “Reports” 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”. Report…

Edit Tasks and Alerts

Development in dbWatch » Edit Tasks and Alerts

How to get 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 To create a new Task or Alert from scratch, go to the Manage tasks and alerts…

Operator Configuration

dbWatch Monitor Setup » Operator Configuration

Access to dbWatch is controlled through operators. Operators have a password and a set of privileges on dbWatch. How to get here The operator configuration view can be accessed by clicking on Operators on the main toolbar. Operators main view The operators view…

Operator Configuration

Setup and Usage » Operator Configuration

Access to dbWatch is controlled through operators. Operators have a password and a set of privileges on dbWatch. How to get here The operator configuration view can be going to Configure > Server Configuration > Manage Users and Roles Operators main view The…

Metadata Properties

Advanced Topics » Property System » Metadata Properties

You can put metadata on instances, and this metadata will be automatically available in dbwql. 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…

Metadata properties

Setup and Usage » Property System » Metadata properties

You can put metadata on instances, and this metadata will be automatically available in dbwql. 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…

Edit Report Templates

Development in dbWatch » Edit Report Templates

Report Selection When you click on “Reports” 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”. Report…

SQL Worksheet

dbWatch Navigation » SQL Worksheet

One of the truly unique features of dbWatch is its integrated SQL Worksheet, which, although simple in operation has some sophisticated applications, including cross-database queries. The SQL Worksheet is not developed from a developer-centric perspective and…

SQL Worksheet

Setup and Usage » SQL Worksheet

One of the truly unique features of dbWatch is its integrated SQL Worksheet, which, although simple in operation has some sophisticated applications, including cross-database queries. The SQL Worksheet is not developed from a developer-centric perspective and…

Installing on Linux

dbWatch Download and Installation – Getting Started » Installing on Linux

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 executable. dbWatch…

Architecture

Overview of dbWatch » Architecture

Architecture components The dbWatch installation consists of three components; the dbWatch Monitor which is the front end GUI. The dbWatch Server which is the core business logic and central hub of the system. And the dbWatch Framework where objects are stored in the…

Startup Configuration

dbWatch Server Configuration » Startup Configuration

There are two files that supply the startup configuration for dbWatch, both can be found in the root of the dbWatch installation catalog. monitor.conf Startup configuration for the dbWatch Monitor server.conf Startup configuration for the dbWatch…

Startup configuration

Setup and Usage » Configuration » Startup configuration

There are two files that supply the startup configuration for dbWatch, both can be found in the root of the dbWatch installation catalog. monitor.conf Startup configuration for the dbWatch Monitor server.conf Startup configuration for the dbWatch…

Running several Monitors in parallel

Setup and Usage » Running several Monitors in parallel

In order to run more than one dbWatch Monitor on a machine you have to tell them to use seperate paths for their files. Before making any changes to the files, make sure the the dbWatch Monitor is stopped. The dbWatch Monitor reads a file called monitor.conf on…

Auditing

Setup and Usage » Configuration » Auditing

There are two types of autiding that can be set up in dbWatch. Auditing of database statements, and auditing of user actions. Database statements DbWatch supports auditing of all statements that are executed on the database instances from dbWatch. There is…

Installing on Multihomed Systems

dbWatch Download and Installation – Getting Started » Installing on Multihomed Systems

Multihomed describes a computer host that has multiple IP addresses connected to networks. When the dbWatch Server runs on a multihomed computer, you have to specify which IP the Server should bind to. On windows Create/change the environment variable called…

Running several Servers in parallel

Setup and Usage » Running several Servers in parallel

In order to run more than one dbWatch Server on a machine there are two things you need to do. Make them listen to different ports, and use seperate paths for their files. Before making any changes to the files, make sure the the dbWatch Server is stopped. Change…

Fault Finding Guide

Troubleshooting » Fault Finding Guide

Errors before starting the installer The first step is to download the software. Once downloaded, errors may occur when the installer unpacks. The install executable or zip file might have been damaged during download, and if this is indicated, try first downloading…

Installing on Windows

dbWatch Download and Installation – Getting Started » Installing on Windows

dbWatch Server Prerequisites Windows Server (VMWare virtual server supported) 8 GB RAM 4 CPU cores 1 GB HD Space (for dbWatch) dbWatch Engine Prerequisites 100 Mb free space in each database instance. Engine – Server communication determined by each…

Command Line

Advanced Topics » Command Line

The dbWatch installation comes with a command line tool. Using this tool it is possible to expose dbwatch functionality to scripts and export data to be used for integrating with other systems. The dbw command is located in the [dbWatch installation]/dbw/bin/dbw…

FAQ

In this section – you will find the frequently asked questions regarding the dbWatch. Do you offer an evaluation copy of your product? - Yes, we do offer a 30-day trial for a maximum of 25 database instances of any database platforms supported. We can also…

Nagios

Advanced Topics » dbWatch Extensions » Extensions » Nagios

Introduction The dbWatch Nagios extension mechanism is included in the product and can be found under Configure->Extensions from dbWatch Monitor when connected to a dbWatch Server. This must be configured and enabled. A perl script needs to be added to your Nagios…

Commandline

Setup and Usage » Commandline

The dbWatch installation comes with a command line tool. Using this tool it is possible to expose dbwatch functionality to scripts and export data to be used for integrating with other systems. The dbw command is located in the [dbWatch installation]/dbw/bin/dbw…

Nimsoft/Nimbus

Advanced Topics » dbWatch Extensions » Extensions » Nimsoft/Nimbus

Installation Extensions for Nimsoft / Nimbus is found in the “Configure->Extensions” menu in the dbWatch Monitor. This should open the Extensions view, where you should see an entry called Nimbus Extension. You are now ready to configure the…

License terms

Licensing and policies » License terms

dbWatch End User License Agreement 1. PARTIES This License and Services Agreement (“Agreement”) is between dbWatch AS, organization number 991 500 456 (“dbWatch”) and the Customer which is the entity or person whose name and contact details as it appears on…

SNMP v3

Advanced Topics » dbWatch Extensions » Extensions » SNMP v3

Setup To enable the SNMPv3 extension, go to the “Server”->“Server extensions” menu in the dbWatch Monitor. Here you will find an entry called “SNMP extension”, select this and click “Configure” on the toolbar. This will bring up thefollowing …

Add a new server to your monitor

Setup and Usage » Configuration » Add a new server to your monitor

dbWatch Monitor supports connecting to multiple monitors, which can be handy in setups where you have two seperate networks and need the databases in both networks monitored. This setup requires that the machine running dbWatch Monitor can see both the dbWatch Server…

Application Modules

Advanced Topics » Application Modules

About application modules The dbWatch framework is easy to extend and expand with tasks, alerts, reporting and administration to support specific applications. An application module is a bundle of tasks, alerts, reports and administration xml files to allow dbWatch to…

Application Modules

Setup and Usage » Application Modules

About application modules The dbWatch framework is easy to extend and expand with tasks, alerts, reporting and administration to support specific applications. An application module is a bundle of tasks, alerts, reports and administration xml files to allow dbWatch to…

Reporting

dbWatch Monitoring and Reporting » Reporting

dbWatch comes bundled with a series of report templates that you can use to generate standard reports on various aspects of your database environment. dbWatch also allows you to edit the templates or create your own for fully customizable reporting. You can access…

Reporting

Setup and Usage » Reporting

dbWatch comes bundled with a series of report templates that you can use to generate standard reports on various aspects of your database environment. dbWatch also allows you to edit the templates or create your own for fully customizable reporting. You can access…

Special setup in NAT environments

dbWatch Server Configuration » Special setup in NAT environments

dbWatch 11 and 12 uses JAVA RMI with SSL for network communication, and the JAVA RMI Registry functionality will create a problem when connecting from the monitor client to the server, when the IP address of the actual dbWatch server host is different from the IP…

Configuring kerberos

Setup and Usage » Configuration » Configuring kerberos

The dbWatch server can be configured to authenticate to Oracle databases using Kerberos. Create a kerberos config file. Create a vmoptions file telling dbwatch where to find the kerberos config. If you want to authenticate using a ticket cache use the kinit…

Importing resources

Development in dbWatch » 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…