Re: ibm i sql Access plan not updated.sql7917 msg

[Nathan Andelin <nandelin@xxxxxxxxx>]

You can stop SQL7917 from appearing in the Job Log:

http://www.midrangenews.com/view?id=2034

I just thought this was interesting, even though it doesn't help solve your
performance problem.

On Mon, Feb 10, 2020 at 4:13 PM Nathan Andelin <nandelin@xxxxxxxxx> wrote:

> SQL7917 is an information message, not an error. See:
>
> https://www.ibm.com/support/pages/investigating-sql7917-message
>
> In regard to Jobs taking 90 minutes ... that appears to be a different
> issue.
>
>
>
> On Mon, Feb 10, 2020 at 4:03 PM Jerry Draper <midrangel@xxxxxxxxxxxxx>
> wrote:
>
> > We have some jobs that are throwing the SQL7917 error (access plan not
> > updated).
> >
> > Jobs that used to take 5 minutes are taking 90 minutes.
> >
> > Updates that took moments are taking five minutes.
> >
> > Any see this before.  How do we rebuild an access plan?
> >
> > Jerry
> >
> >
> > --
> > Jerry Draper, Trilobyte Software Systems, since 1976
> > IBMi, Network, and Connectivity Specialists, LAN/WAN/VPN
> > Representing WinTronix, Synapse, HiT, and others .....
> > (415) 457-3431 opt-1 . www.trilosoft.com
> >
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> > list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at https://archive.midrange.com/midrange-l.
> >
> > Please contact support@xxxxxxxxxxxx for any subscription related
> > questions.
> >
> > Help support midrange.com by shopping at amazon.com with our affiliate
> > link: https://amazon.midrange.com