Insufficient SQL storage with A046 A014 message when running CIA CIARPT03 report

Document ID : KB000049299
Last Modified Date : 14/02/2018
Show Technical Document Details

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:

  1. IJ3STGE1 in SAMPJCL library.

  2. CB2ACMDL in SAMPJCL library.

  3. SQLINST4 for all subsystems involved.
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