IBM Support

SE67209 - OSP-DB-OTHER-MSGSQL0904 A MSGSQL0904 MAY OCCUR WHEN A SQL PACKAGE REACHES MAXIMUM SIZEMAR

 APAR (Authorized Program Analysis Report)

Abstract

OSP-DB-OTHER-MSGSQL0904 A MSGSQL0904 MAY OCCUR WHEN A SQL
PACKAGE REACHES MAXIMUM SIZEMAR

Error Description

A msgSQL0904 Type 7 with a reason code of 163 may occur if a    
SQL Package reaches the maximum size                            

Problem Summary

****************************************************************
* PROBLEM: (SE67209) Licensed Program = 5770SS1 for i 7.2      *
*           Usability of a Product's MAJOR Function            *
****************************************************************
* USERS AFFECTED: All IBM i operating system users.            *
****************************************************************
* RECOMMENDATION: Apply PTF SI64737 for i 7.2.                 *
****************************************************************
A msgSQL0904 Type 7 with a reason code of 163 may occur in a    
QZDASOINIT Job if a SQL Package reaches the maximum size.      

Problem Conclusion

Code was added to prepare the statements into the job's space  
when the SQL Package is full.                                  

Temporary Fix

                       *********                                
                       * HIPER *                                
                       *********                                

Comments

Circumvention


PTFs Available

R720 SI64737 PTF Cover Letter   7290

Affected Modules

         
         

Affected Publications

Summary Information

Status............................................ CLOSED PER
HIPER........................................... Yes
Component.................................. 5770SS100
Failing Module.......................... RCHMGR
Reported Release................... R720
Duplicate Of..............................




System i Support

IBM disclaims all warranties, whether express or implied, including, but not limited to, the implied warranties of merchantability and fitness for a particular purpose. By furnishing this document, IBM grants no licenses to any related patents or copyrights. Copyright © 1996,1997,1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013, 2014, 2015, 2016, 2017 IBM Corporation. Any trademarks and product or brand names referenced in this document are the property of their respective owners. Consult the Terms of use link for trademark information

Document information

More support for: i family

Software version: V7R2M0, V7R3M0

Operating system(s): OS/400

Reference #: SE67209

Modified date: 27 October 2017