Description:
When running CIARPT03 Compliance Information Analysis report receiving error:
A046 SQL - INSUFFICIENT STORAGE A014 PREMATURE TERMINATION DUE TO PREVIOUS ERROR(S)
Solution:
N eed to increase MAXCUR parameter.
Edit CAIMAC member OMSMCMD2 to increase the MAXCUR parameter and THEN run the following jobs:
OMSMCMD2 **************************** Top of Data ******************************* DQSMCMD MAXSTMT=10, MAXCUR=10, VWOWNR=PANSQL24, PLAN=DQPS024Z DB2REL=081, MAXGRP=10, HLDCUR=6 END MAXCUR 1 - 99 SPECIFIES THE MAXIMUM NUMBER OF UNIQUE CURSORS THAT AN APPLICATION WILL USE. TOO SMALL OF A SPECIFICATION WILL CAUSE THE HOST APPLICATION TO ABORT (SINCE CURSORS CAN NOT BE REUSED). TOO HIGH OF A SPECIFICATION WILL USE MORE