IBM Maximo: Monitorar o número de DB Connections
Abaixo tenho configurações
System Properties
mxe.db.closelongrunconn=true mxe.db.longruntimelimit=60 mxe.db.detectlongrunconninterval=30
Logging
Maximo DB Connection watchdog logger (log4j.logger.maximo.dbconnection)=INFO
Define to INFO. Generate this message on logs. BMXAA7084I - The DbConnectionWatchDog class has been trying to close the database connection for:
Importante: É necessário ter GRANT TO SELECT em algumas tabelas de sistema, conforme o banco de dados:
- Oracle : v$session, gv$session ( on RAC )
- Microsoft SQL Server : master.sysprocesses
- Db2 : SYSIBMADM.SNAPAPPL_INFO
Baseado nas Technotes:
How to solve database connection leaks? Maximo and Control Desk Database Connection Leak Resolution