ctmdbtrans

The ctmdbtrans utility lists the active transactions in the database. A transaction is defined as the unit of work performed by Control‑M in the database. Each transaction is assigned a unique name identifying that specific unit of work.

You may be asked by technical support to run this utility and to provide the output for debugging purposes.

Another way to list active transactions in the database, is to select List Active Transactions from the Troubleshooting menu.

Running the ctmdbtrans Utility

This procedure describes the ctmdbtrans utility, which lists the active transactions in the database.

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 to see which transactions are active in the database:

   ctmdbtrans

Running the ctmdbtrans Utility in Batch Mode

This procedure describes how to run the ctmdbtrans utility in batch mode.

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. Do one of the following:

   • For PostgreSQL, Oracle and MSSQL databases, enter the following command:

     ctmdbtrans

   • (UNIX only) Refresh transactions every given amount of time by specifying the sleep time parameter by entering the following command:

     ctmdbtrans

     ctmdbtrans n (number in seconds)