On our database we have a sort of latency issues with db2. These latencies reach a totally random.
A single query will go through such (at its first use) in 1sec then if I redo the test after 10 min (so that it is the access map in the SQE plan cache) it will take 7sec and something like that.
I could make DBMON to see that it was the FETCH stage that was problematic. OK, but I do not know what to do with this, or explain why we have such behavior.
Is there a tool that will see at once if the fetch we have a lock for example that we blocked? Do you have any other line of research to which I can turn my attention to understand why we have such cases?
Bookmarks