Understanding statistics reported by stored procedures

Many stored procedures report back information on the state of IQ at the time the procedure executes. This means that you get a snapshot view. For example, a report column that lists space in use by a connection shows only the space in use at the instant the procedure executes, not the maximum space used by that connection.

If you want to monitor IQ usage over an extended period, use the IQ monitor, which collects and reports statistics from the time you start the monitor until you stop it, at an interval you specify.