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

[Jim Oberholtzer <midrangel@xxxxxxxxxxxxxxxxx>]

To answer the original question, simply delete it.  It will rebuild the next time the SQL runs.  It will take a fraction of time to do it since the optimizer needs to do the full job. 

Jim Oberholtzer
Agile Technology Architects



> On Feb 10, 2020, at 5: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
> -- 
> 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