SQLRPGLE in Debug and Query Optimization joblog messages -- RPG400-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

The last conversation I found on Query Optimizer messages being written to
the joblog was from 2013.
I thought I would post this to see if there is any newer information.
Issue:
When running a SQLRPGLE program in Debug, Query Optimizer messages are
written to the joblog and
depending on job setup, can produce 100s of spooled files.
This continued to happen even though QAQQINI - MESSAGES_DEBUG option was
set to *DEFAULT
and a second test changing the option to *NO.

Steps to Change QAQQINI - MESSAGES_DEBUG to *NO:
CRTDUPOBJ OBJ(QAQQINI) FROMLIB(QUSRSYS) OBJTYPE(*FILE) TOLIB(QTEMP)
DATA(*YES)
UPDATE QTEMP/QAQQINI SET QQVAL='*NO'
WHERE QQPARM='MESSAGES_DEBUG'
CHGQRYA QRYOPTLIB(QTEMP)
1) After changing the QAQQINI - MESSAGES_DEBUG to *NO, why are SQL Query
Optimizer messages still being written to the joblog?
2) Other than changing the QAQQINI value or changing the job logging
parameters, is there any other way to suppress the Query
Optimizer messages during Debug?

Thx

Debra Fitzgerald
The H.T. Hackney Co.
Sr Programmer/Analyst
865-546-1291

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.