ctmdbused

The ctmdbused utility displays the size (in MB), amount, and percentage of current space usage in the Control‑M/Server database data and log.

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.

Begin

  1. Do one of the following:

    • UNIX: Log in 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.

ctmdbused 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 MSSQL databases.

  • Input: ctmdbused

  • Output:

    Copy 
    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.

  • Input: ctmdbused

  • Oracle 11 database – utility output:

    Copy 
    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.

  • Input: ctmdbused

  • Output:

    Copy 
    db total = 50404551 MB
    data used = 863570 KB (1.71%)