2200584 - SQL0904 "Resource limit exceeded"

SQL0904 happens during daily operations, and can be any transactions with access to certain table.
You will have short dumps, and SM21 errors.

ST22: 
Category                  Resource Shortage
Runtime Errors         DBIF_REPO_SQL_ERROR
OR
Runtime Errors         DBIF_RSQL_SQL_ERROR

SM21: Database error -904 at FET access to table MARA

DEV_w* trace:
***LOG BY4=> sql error -904   performing FET on table MARA   [dbrepolo     302]
***LOG BY0=> Resource limit exceeded. MSGID= Job=039535/PRDADM/WP66 [dbrepolo     302]

Job log:

System object REPOLOAD  REPO0002 partially damaged. Internal dump ID
  00000000. Error class 2, device number X'0052'.
Failure for device or member MCH0007 file REPOLOAD in library R3PRDDATA.
Resource limit exceeded.

AS/400, OS400, DB4

"Resource limit exceeded" with "reason code 7" "return code 13" "ERROR => SQL error -904 with reason code 13" , KBA , BC-DB-DB4 , DB2 for AS/400 , Problem