Suppress SQL warnings from SPUFI, DSNTEP2, DSNTEP4, and DSNTIAUL
Paul_McWilliams 110000JT36 Visits (4784)
In Db2 11 and Db2 12, APAR PI79053 introduced a new QUIET option for the TOLWARN parameter for the DSNTIAUL program. APAR PH00572 will soon introduce the same change for several similar applications, including SPUFI and the DSTN
Before the introduction of this capability, some queries when processed with TOLWARN(YES) can cause the programs to print SQL warning messages after every FETCH. With multi-row fetch, millions of messages like the following examples can be issued and fill up the SYSPRINT file.
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
The new QUIET option provides relief for users of these applications who complain about the 'noise' caused by such messages with TOLWARN(YES).