Running the ctmdbused utility

This procedure describes how to run the ctmdbused utility displays the size (in MB), amount, and percentage of current space usage in the Control‑M/Server database data and log.

To run the utility:

1. Do one of the following:
   • UNIX: Log on to a Control-M/Server account
   • Windows: Open a command prompt window where Control-M/Server is installed.
2. Enter the following command:

   ctmdbused

Use this utility if you need to determine Control-M/Server database sizes frequently.

For the Control-M parameter name, see Parameter name cross references. For more details on running the ctmdbused utility, see ctmbused utility example.

ctmbused utility example

These examples use the ctmdbused utility to display Control-M/Server database data and log size, amount of current usage and percentage of space, using Sybase and MSSQL databases.

Utility input

ctmdbused

Utility output

db total = 45000.0 MB (data= 3000.00 , log= 15000.00)

data used = 4174 MB (13%).

log used = 40.00 MB (0%)

This example uses the ctmdbused utility to display Control-M/Server database data and log size, amount of current usage and percentage of space, using Oracle 11.

Utility input

ctmdbused

Oracle 11 database – utility output

db total = 563200.0 MB

data used = 10048 MB (4%).

This example uses the ctmdbused utility to display Control-M/Server database data, amount of current usage and percentage of space, using a PostgreSQL database.

Utility input

ctmdbused

Utility output

db total = 50404551 MB

data used = 863570 KB (1.71%)