ANR2958E
SQL temporary table storage has been exhausted.

Explanation

The result of an SQL query could not be computed because temporary table storage space was unavailable. By issuing the QUERY DB command and viewing the Maximum Reduction parameter, you can determine the amount of space that is available for temporary table storage space. If the parameter is less than 4, the storage space becomes exhausted and the SQL query can no longer run. Complex SQL queries such as the ORDER BY clause, the GROUP BY clause, and the DISTINCT operator can cause additional temporary table space to be required.

System action

The SQL query is terminated.

User response

If your database is full, increase the size of the database. If your database is fragmented (Where the Available space parameter is greater than 4, but the Maximum Reduction parameter is less than 4), you must either unload and load your database or add avolume.