Database probes

A database probe opens one or more databases, performs database operations, and then closes the database.

Before you configure a Database - Compact probe or Database - Design probe, make sure that you are familiar with the Compact task and with updating database designs.

When configuring the Database - Error Monitoring probe, use the Errors to ignore field to specify errors that the probe should ignore. This probe provides visibility to unusual NSF and NIF errors on local servers. When this probe is enabled, and an error is encountered, the error code is checked against items in the list. If the error code is on the list, no further action is taken. If the error is not on the list, a DDM event is generated. The event identifies the operation that failed, the issuing server, the database name, and the specific error code. DDM automatically appends information that pertains to the error code, such as the probable cause and corrective action, if any.

This table lists probe names and descriptions of the database probes that you can define.

Table 1. Types of probes

Database probe name

Description

Database -- Compact

Reports errors that occur when a database is compacted.

Database -- Design

Reports errors that occur when the design of a database is updated.

Database -- Error monitoring

Monitors key APIs in NSF and NIF, which are used to perform database operations and generates events for errors that occur.

Database -- Scheduled Checks

Reports if the named database cannot be opened. The probe can also check for unused space in the database and for database inactivity.