db_check

The db_check utility provides the following information about Control-M/EM databases:

  • Size of the database

  • Availability of space in the database

  • Verification of database integrity

  • Automatic database and transaction log monitoring

The db_check utility can only be invoked in Control-M/Enterprise Manager. The db_check utility is not relevant for Windows. It is not available for an Oracle Server.

Running the db_check Utility

This procedure describes how to run the db_check utility, which provides information about Control-M/EM databases.

Begin

  1. Do one of the following:

    • UNIX: Log in to a Control-M/EM account.

    • Windows: Open a command prompt window where Control-M/EM is installed.

  2. Enter the following command:

    db_check [-d <dbThreshold%>] [-l <logThreshold%>] [-p <password>] [-n] [-h]

    The user name is derived from the $EM_USER environment variable.

db_check Utility Parameters

The following table describes the db_check utility parameters:

Parameter

Description

-d <dbThreshold%>

Determines the maximum percentage of database use.

When this percentage is exceeded, a message is displayed alerting you to extend the database.

The -d must be lowercase.

-l <logThreshold%>

Determines the maximum percentage of transaction log use.

When this percentage is exceeded, a message is displayed alerting you to extend the transaction log.

The -l must be lowercase.

-p <password>

Defines the password for the Control‑M/EM administrator.

If not specified, you are prompted to supply this information when the utility runs.

The-p must be lowercase.

‑n

Indicates that db_check does not verify the total database integrity.

The -n must be specified in lowercase.

‑h

Indicates that db_check displays the amount of database space that is in use.

The -h must be specified in lowercase.

db_check Utility Example

The following is an example of the db_check utility:

Copy 
db total = 29000.0 KB (data= 23500.00, log= 5500.00)data used = 1928 KB (8%).
log used = 0 KB (0%).
Checking database...
Database is OK.

The db_check utility is not relevant for Windows and works only with databases on a Sybase Adaptive server. This utility is not available for Oracle server.