IBM Tivoli Storage Manager V7.1 Implementation — Question 7

A Maximo database administrator has reported too many database connections being idle and eventually causing the database to run out of connection resources. The administrator wants to detect and release stale database connections.
Which set of properties must be configured?

Answer options

• A. mxe.db.url, mxe.db.user, mxe.db.password
• B. mxe.mbocount, mxe.db.logSQLTimeLimit, mxe.db.fetchResultLogLimit
• C. mxe.db.closelongrunconn, mxe.db.longruntimelimit, mxe.db.detectlongrunconninterval
• D. mxe.db.initialConnections, mxe.db.minFreeConnections, mxe.db.maxFreeConnections

Correct answer: C

Explanation

The correct answer is C because configuring these properties allows the Maximo system to close long-running connections, set a time limit for them, and define the interval for detecting such connections. The other options do not address the issue of managing stale connections: A deals with basic connection credentials, B relates to logging performance, and D focuses on initial and free connection management without addressing stale connections.