[SOLVED] IBIF_max_messages is causing the WebFOCUS job to abend

Focal Point

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/2737075795

January 25, 2011, 11:46 AM

MarciaDrummond

[SOLVED] IBIF_max_messages is causing the WebFOCUS job to abend

I am currently creating a DB2 hold file which is generating thousands of "INSERT INTO" messages which is the reason for the "IBIF_max_messages..." when my procedure runs.

I cannot go the route of modifying this variable in the Admin Console.

I would like to suppress or reduce the occurrence of the "INSERT INTO" messages similar to how the CHECK command is used in a MODIFY request.

This message has been edited. Last edited by: Kerry,

January 25, 2011, 11:50 AM

Francis Mariani

Do you have SQL traces on? This may be the reason for the INSERT INTO messages. If you do, turn them off just before the HOLD file creation.

Francis

Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server

January 25, 2011, 12:04 PM

MarciaDrummond

Thanks, Francis.

I was tracing the SQL and no longer require them. That has resolved it.

Much appreciated.

Marcia