Tue, Aug 8, 2023 12:00 PM CDT (7:00 PM Europe/Stockholm) Read More
Tosh Bimbra on LinkedIn: It’s been 35 years since Rochester’s IBMI launched its AS/400 computer. I… View Profile
It’s been 35 years since Rochester’s IBMI launched its AS/400 computer.
I am thrilled to have been with the platform right from the start. Who remembers the… Read More
Christoph Cuscoleca on LinkedIn: #commonaustria #ibmi35 #ibmi #common View Profile
Our 35th year birthday cake from AS/400 to IBM i #commonaustria #ibmi35 #ibmi #common Read More
RPGLE Opcodes & Opcodes Extenders Programmers IO
TechTip: Real-Time Monitoring of Query Resource Consumption with Query Supervisor Sarah Mackenzie
Query Supervisor gives you the ability to not only monitor for expensive and runaway queries, but to take action while the query is running.
By Sarah Mackenzie
Identifying and managing long-running and resource-intensive queries can be challenging. You can try to identify and fix these queries before they are used in your production environment, but this is not always possible. For example, you may have a user perform a long-running ad hoc query that consumes a lot of resources, or you may have a query suddenly take longer to complete than usual. It is important to be able to detect these long-running, resource-intensive queries so that you can achieve improved systems management. Read More