Excessive Work Space Warning

An American GiAPA user reported experiencing performance problems from time to time when a job allocated excessive temporary storage – typically caused by SQL code building a huge temporary table in QTEMP.

The data received by GiAPA every 15 seconds for each job includes number of pages allocated and deallocated. It was therefore easy to implement an “Allocation Trap Feature” enabling the system operator to hold or terminate jobs using excessive memory.

If a limit for number of pages allocated by a job is specified in the GiAPA installation parameters, GiAPA will send a warning message to the system operator when a job exceeds this number of pages of work space.

When this option was announced as part of a new GiAPA release, several other installations using GiAPA reported that they also had experienced similar problems caused by lack of additional temporary work space.