search cancel

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

book

Article ID: 49299

calendar_today

Updated On:

Products

Cleanup Datacom DATACOM - AD CIS COMMON SERVICES FOR Z/OS 90S SERVICES DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS COMMON PRODUCT SERVICES COMPONENT Common Services CA ECOMETER SERVER COMPONENT FOC EASYTRIEVE REPORT GENERATOR FOR COMMON SERVICES INFOCAI MAINTENANCE IPC UNICENTER JCLCHECK COMMON COMPONENT Mainframe VM Product Manager CHORUS SOFTWARE MANAGER CA ON DEMAND PORTAL CA Service Desk Manager - Unified Self Service PAM CLIENT FOR LINUX ON MAINFRAME MAINFRAME CONNECTOR FOR LINUX ON MAINFRAME GRAPHICAL MANAGEMENT INTERFACE WEB ADMINISTRATOR FOR TOP SECRET Xpertware Top Secret Top Secret - LDAP 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