Using IBM i? Need to create Excel, CSV, HTML, JSON, PDF, SPOOL reports? Learn more about the fastest and least expensive tool for the job: SQL iQuery.
Removing SQL7917 from joblog
Because message SQL7917 maybe filling up joblogs, a data area can be created to stop message SQL7917 from being written to the joblog. A DBMON trace will still show the SQL7917 detail; however, with the data area in place, the joblog will not receive the message.
To prevent SQL7917 from appearing in the joblog create the following data area in a library in the job's library list:
CRTDTAARA DTAARA(QSQNO7917) TYPE(*CHAR) LEN(1)
Note: The jobs need to be restarted to pick up the change after the data area is created. The data area is detected during the first SQL statement issued for a job.