Re: CHGQRYA alternatives

[Justin Taylor <jtaylor.0ab@xxxxxxxxx>]

I'll give that a try.

Thanks

date: Wed, 6 Jan 2021 11:33:56 -0600
> from: "Timothy P Clark" <timclark@xxxxxxxxxx>
> subject: Re:  CHGQRYA alternatives
>
> Have you considered the OVERRIDE_QAQQINI function as an alternative?
>
> https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_73/rzajq/rzajqprocoverrideqaqqini.htm
>
> This will allow you to have what is essentially a temporary, job-scoped
> QAQQINI without having to reference a permanent lib/file with QRYOPTLIB.
>
> Thank you,
>
> Tim Clark
> DB2 for IBM i / SQL Optimizer
>
> "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> wrote on 01/06/2021
> 08:11:34 AM:
>
> > From: Justin Taylor <jtaylor.0ab@xxxxxxxxx>
> > To: MIDRANGE-L <midrange-l@xxxxxxxxxxxxxxxxxx>,
> > Date: 01/06/2021 08:11 AM
> > Subject: [EXTERNAL] CHGQRYA alternatives
> > Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxxxxxxxx>
> >
> > I have a batch job that needs to run CHGQRYA.  The user isn't
> authorized,
> > and I can't easily get authorization.  Is there an alternative?
> >
> > The command is:
> > CHGQRYA QRYOPTLIB()
> >
> > The only row in the referenced QAQQINI is:
> > REBUILD_ACCESS_PLAN *DEFAULT
> >
> > TIA