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 UtilityLink copied to clipboard

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 ExampleLink copied to clipboard

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:

    CopyCopied to clipboard 
    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:

    CopyCopied to clipboard 
    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.