nerdexam
IBM

C2010-530 · Question #40

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…

The correct answer is C. mxe.db.closelongrunconn, mxe.db.longruntimelimit, mxe.db.detectlongrunconninterval. See the full explanation below for the reasoning.

Question

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?

Options

  • Amxe.db.url, mxe.db.user, mxe.db.password
  • Bmxe.mbocount, mxe.db.logSQLTimeLimit, mxe.db.fetchResultLogLimit
  • Cmxe.db.closelongrunconn, mxe.db.longruntimelimit, mxe.db.detectlongrunconninterval
  • Dmxe.db.initialConnections, mxe.db.minFreeConnections, mxe.db.maxFreeConnections

How the community answered

(50 responses)
  • A
    8% (4)
  • B
    4% (2)
  • C
    70% (35)
  • D
    18% (9)

Community Discussion

No community discussion yet for this question.

Full C2010-530 Practice