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

Products

• CA Cleanup
• CA Datacom
• CA DATACOM - AD
• 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