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

Article Id: 49299
Status: Published
Updated On: 21-03-2018 07:17
Legacy Id: TEC580645
Products:
CA Cleanup , CA Datacom , CA CIS , CA Common Services for z/OS , CA 90s Services , CA Database Management Solutions for DB2 for z/OS , CA Common Product Services Component , CA Common Services , CA Datacom/AD , CA ecoMeter Server Component FOC , CA Easytrieve Report Generator for Common Services , CA Infocai Maintenance , CA IPC , Unicenter CA-JCLCheck Common Component , CA Mainframe VM Product Manager , CA Chorus Software Manager , CA On Demand Portal , CA Service Desk Manager - Unified Self Service , CA PAM Client for Linux for zSeries , CA Mainframe Connector for Linux on System z , CA Graphical Management Interface , CA Web Administrator for Top Secret , CA CA- Xpertware , CA Top Secret , CA Top Secret - LDAP , CA Top Secret - VSE
Issue/Introduction:

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

Environment:

Release:
Component: AWAGNT