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

book

Article ID: 49299

calendar_today

Updated On:

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