IQ became unresponsive when using cognos reporting tool.
IQ became unresponsive due to cognos connection.
We can see many cognos client connections which are holding the cursor.
It may be caused by the queryReuse functionality in Cognos.
When this Cognos setting is enabled, it uses the IQ internal cursors and does not release them.
This results in IQ has no more cursors available and IQ got unresponsive.
Here are possible solutions for both sides (IQ and Cognos).
: Increase the options below and switch.
: Cognos doesn’t keep the connection open and holds the IQ cursors after having finished with queries.
1) queryReuse = 0 or disable