SYMPTOM:
When attempting to execute a report, the execution fails, and the following error message is received:
"SQL Error when executing a report. ]Unknown error: SQLCODE -973". IBM DB2 is used as the warehouse database.
Using the SQL generated for the report via the DB Query Tool using DB2 native ODBC drivers, the syntax of the error appears with the IBM DB2 original syntax:
SQL0973N Not enough storage is available in the "APP_CTL_HEAP" heap to
process the statement. SQLSTATE=57011
CAUSE:
The issue is caused by the database heap size for the warehouse being too low.
ACTION:
This issue can be resolved by increasing the heap size of the warehouse database. The IBM DB2 parameter to be modified is the APP_CTL_HEAP. Contact the database administrator in order to perform this action.
