CQM1213W SPACE IS FULL AND NO MORE EXTENTS CAN BE OBTAINED FOR SPACE – space

Explanation

A Query Monitor Integrated Storage Manager operation has failed because no more extents can be obtained for the space named in the message. This message and messages CQM1203I and CQM1204I provide details that can be used by IBM® Technical Support to diagnose the situation.

User response

This may be a temporary situation due to the level of Db2 activity currently being monitored by Query Monitor. If message CQM1202I is issued later to indicate that the Storage Constraint has ended, then processing resumes normally. If this situation rarely occurs, it may not be a problem. If this situation frequently occurs, it may be possible to prevent it by adjusting the amount of data collected by Query Monitor within an interval. This could be accomplished by reducing the number of OPTKEYs that are specified for the workload, reducing the length of the INTERVAL, or increasing the amount of memory available to Query Monitor (MAXIMUM_ALLOCATIONS and SMEM_SIZE).

If you need assistance with tuning these parameters, provide the text of this message and messages CQM1203I and CQM1204I to IBM Technical Support.