Configuring database connections

You must set the minimum number of connections for the database user name to the number of concurrent database connections. The following table lists the minimum number of database connections.

To change your database connection information, see Managing security information with mqsusertool command line tool.


Service

Number of connections

TMTM Topic Service

Four (4) connections. If you change the db_connect_pool_size setting in the services.cfg file, then you must add that number to the four connections for the TMTM Topic Service and subtract two from the resulting number because the default setting for db_connect_pool_size is 2.

Example: if db_connect_pool_size is set to 5, use 7 for the number of connections for the TMTM Topic Service.

TMTM Application Service

Nine (9) connections. If you change the db_adapter_pool_size setting in the services.cfg file, then you must add that number to the 9 connections for the TMTM Application and subtract 8 from the resulting number because the default setting for db_adapter_pool_size is 8.

Example: if db_adapter_pool_size is set to 15, use 16 for the number of connections for the TMTM Application Service

TMTM History Service

Four (4) connections.

TMTM Event Service

One (1) connection.

TMTM Client Gateway Service

One (1) connection.

Was this page helpful? Yes No Submitting... Thank you

Comments