by Phil Trbovic | Apr 6, 2023 | Blog, Db2
We, as DBAs, have all encountered a situation where a bad query just kept running and sucked up the database resources while holding onto logs. It’s always a “simple select” that seems to run over 12 hours. Db2 used to have the governor. This nifty...
by XTIVIA | Jan 9, 2018 | Blog, Db2
Sometimes when you’re looking at Db2 Queries, you may notice question marks in your queries, like this: SELECT partnum, sum(quantity) as QUANTITY FROM orderitems oi INNER JOIN orders o ON oi.orders_id = o.orders_id where o.field3 is null and o.timeplaced is not...
by XTIVIA | Jun 13, 2017 | Blog, MongoDB
Mtools is a third party tool suite that contains very easy to use utilities for troubleshooting or just gathering general knowledge about your MongoDB instance. These tools can be crucial when performance tuning, running a health check or examining log files. You can...
by XTIVIA | Jun 8, 2017 | Blog, MongoDB
There are many reasons why your database queries can start to lag or experience throughput issues. In this article I will do troubleshooting on two common issues with slow queries and a way to fix each one. When doing any performance tuning on a database it’s...