Midrange News for the IBM i Community


Posted by: Bob Cozzi
Rogue Programmer
Cozzi Productions, Inc.
Chicagoland
Preventing SQL7917 Access plan not updated
has no ratings.
Published: 27 Mar 2013
Revised: 07 Apr 2013 - 4009 days ago
Last viewed on: 29 Mar 2024 (7546 views) 

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 Published by: Bob Cozzi on 27 Mar 2013 view comments(1)

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.

Return to midrangenews.com home page.
Sort Ascend | Descend

COMMENTS

(Sign in to Post a Comment)
Posted by: bobcozzi
Site Admin ****
Chicagoland
Comment on: Preventing SQL7917 Access plan not updated
Posted: 10 years 11 months 22 days 21 hours 45 minutes ago
Edited: Sun, 07 Apr, 2013 at 12:46:32 (4009 days ago)

 

 

Looks like they now have a fix!

link to IBM Fix page