db_check_space

The db_check_space utility provides the following information for Control-M/EM databases that use Oracle database servers.

  • Total size and availability of space in the /tmp directory

  • Total size and availability of space in the database

  • Percentage of total space in the database that is currently available

The db_check_space utility cannot be used for Oracle database client installations and is not relevant for Windows. The db_check_space utility can only be invoked in Control-M/Enterprise Manager.

Running the db_check_space Utility

This procedure describes how to run the db_check_space utility, which provides information for Control-M/EM databases that use Oracle database servers.

Begin

  1. Log in to a Control-M/EM account.

  2. Do the following:

    • When prompted by the utility interactively, specify the Oracle administrator as the user name.

    • Enter the following command to specify the appropriate Control-M/EM UNIX user account and password using the -U and -P parameters in the command line:

      db_check_space [ -U <userName> [ -P <password> ] ]

db_check_space Utility Parameters

The following table describes the db_check_space utility parameters:

Parameter

Description

-U <userName>

Defines the user name.

If not specified in the command line, you are prompted to provide this information when the utility runs.

The -U must be specified in uppercase.

If you intend to specify the -P parameter when running the utility, you must also specify the -U parameter.

-P <password>

Defines the password.

If not specified in the command line, you are prompted to provide this information when the utility runs.

The -P must be specified in uppercase.

If you intend to specify the -P parameter when running the utility, you must also specify the-U parameter.

This utility is also available from the root menu by selecting the 2 - Troubleshooting Menu option and then the 1 - Database Troubleshooting option.

For more information, see Control-M diagnostics.

This utility is also available from the root menu by selecting the 2 - Troubleshooting Menu option and then the 1 - Database Troubleshooting option. For more information, see Control-M diagnostics.

db_check_space Utility Example

The following is an example of db_check_space utility output:

Oracle Server

Copy
+------------------------------------------+
+ Space Information ( /tmp of the machine) +
+------------------------------------------+
 Total Size:  2048000 KB.  Space Available:  366430 KB  17 % Free
+------------------------------------+
|  ORACLE Size Information:          |
+------------------------------------+
 db total = 276480.0 KB
data used = 25296 KB (9%).\