C
ChUIMonster
Guest
ProTop has this capability in the commercial version. To do it properly you need to read and parse the .lg file continuously (more or less equivalent to "tail -f"). If you only periodically check the last X lines you will miss messages. ProTop also has *much* better methods of tracking and alerting on excessive bi growth than alerting on message 9240. ProTop will alert you about long transactions, large numbers of active bi clusters and multiple levels of bi usage allowing you to respond long before you get to the 90% -bithold mark. ProTop will even tell you which users are driving the bi growth. For instance, this alert (which you would get as an email or SMS) tells you that about 2.4GB of bi space is being used because usr# 609 has a transaction that is 23 minutes old: biUsed 2432 > 2000 [2019/05/20 01:10:54.443-05:00] [server: erp1.xyzzy.com] [dbname: /db/erp] [cfgname: prod] Usr Name PID Device Flags Duration ===== =============== ======== ================== ===== ============ 609 ScanTmp075 4872 IS_pScan.xyzzy.com R4 * 00:23:31 639 ext-proces 6992 WebIS R4 * 00:00:00 625 batchjobs 84599 pWeb.xyzzy.com ba R4B* 00:00:00 589 webuser 79202 pWeb.xyzzy.com ba RW * 00:00:00
Continue reading...
Continue reading...