View connection pooling statistics

In the Administration Console, you can view server pooling statistics about users connected to Dimensions CM.

About server pooling

Dimensions CM server pooling enables multiple Dimensions CM application servers to be started before clients connect to a Dimensions CM server. It improves connection time for clients, as the application servers are already initialized and connected to the Dimensions CM database.

Server pooling is automatically started upon Dimensions CM startup. For details on how to manually start server pooling and reconfigure its parameters, see Administration.

In the Administration Console, you can view which users are connected to the Dimensions CM server and what resources they are using. You can use this information to monitor the server pool and make adjustments in the configuration file, listener.dat. For example, you may want to change the minimum and maximum parameters to control the number of server processes in the pool.

Note: To view server pooling statistics, you can also use the getpoolstats command. For details, see Administration.

If you are not using the default TCP port of 671 for the Dimensions CM Listener Service, you must specify the appropriate port number.

Back to top

View pooling statistics

In the Connection Pooling Statistics section of the Administration Console, review information about the current sessions in use with the Dimensions CM server.

To view pooling statistics:

  1. In the Administration Console, go to Database Management > Connection pooling statistics.

  2. In the Connection Pooling Statistics window, view General Information:

    Field Description
    Number of sessions Total number of login sessions (active plus inactive). Inactive sessions entries are colored blue; active sessions are colored black.

    Number of active sessions

    The number of login sessions that are presently active (colored black).
    Number of server processes The number of server processes that have been started and are currently in use by a session.

  3. In the Detailed Information section, view the details of each session:

    Field Description
    User ID The user ID of the user who opened the session.
    Client Node The machine from which the user logged in. For the web client or Administration Console, this is the machine that is running the Tomcat application server.
    DB Name The base database name for the login session.
    DB Connection The database connection for the login session.
    Application Name The client program accessed by the user. For example, PCCLIENT represents the desktop client.
    Time Connected (in sec) The amount of time the user has been logged in using this session.
    Time Allocated (in sec) The total amount of time a server process has been allocated to this session.
    Session ID The unique ID for the session.
    Process ID

    The unique process ID of the server process allocated to this session.

    A value of 0 means that no server process is allocated and the session is idle.

  4. To update the displayed data, click the Refresh button. By default, pooling statistics automatically refreshes every five minutes.

Back to top

See also: