Re: Access Plan Not Updated

["Clare Holtham" <Clare.Holtham@xxxxxxxxxxxxxx>]

Cesar,

Look for a data area called SF99501 and dspdtaara. If you have the Database
Group PTF it will exist, and have a date in it. You can check on the IBM
website (PTF cover letters) if this is the latest one.

When you moved to V5R1, did you do the change to QAQQINI recommended by SSA,
and also did you do a STROBJCVN? Some BPCS sites get problems without this.
But if you have been on V5 for a while, what changed before you noticed the
problem?

To check if a lot of dynamic index building is happening, you can usually
see this on WRKACTJOB or WRKSYSACT.

Hope this helps,

Clare

----- Original Message -----
From: "Cesar Iracheta Mata" <iracheta@xxxxxxxxxxx>
To: "'SSA's BPCS ERP System'" <bpcs-l@xxxxxxxxxxxx>
Sent: Tuesday, February 18, 2003 4:56 PM
Subject: RE: Access Plan Not Updated


> Thank you, Clare.
>
> I don't upgraded the OS, I have V5R1.
> Are there any procedure for to check if I have applied all the SQL PTF
> or which SQL PTF's?.
>
> I don't have test data, only production data.
> I don't about the dynamic index creation.
>
> Regards
>
> Cesar
>
> -----Original Message-----
> From: bpcs-l-bounces@xxxxxxxxxxxx [mailto:bpcs-l-bounces@xxxxxxxxxxxx]
> On Behalf Of Clare Holtham
> Sent: Martes, 18 de Febrero de 2003 10:03 a.m.
> To: SSA's BPCS ERP System
> Subject: Re: Access Plan Not Updated
>
>
> Hi Cesar,
>
> Have you just upgraded OS/400 ? Have you applied all the SQL PTFs?
> (Database
> Group)
>
> The 'access plan' is where the SQL optimizer keeps its plan, and it is
> part of the program object. It needs to be updated if the data changes
> more than a certain amount.
>
> Are you accessing test and production data with the same programs? Have
> you got dynamic index creation going on (if you haven't done a database
> tuning exercise)? This could lock the access plan....
>
> Clare
>
> ----- Original Message -----
> From: "Cesar Iracheta Mata" <iracheta@xxxxxxxxxxx>
> To: <bpcs-l@xxxxxxxxxxxx>
> Sent: Tuesday, February 18, 2003 3:48 PM
> Subject: Access Plan Not Updated
>
>
> > Hi all
> >
> > I am having problems in any BPCS programs(Example: Event Processing,
> > ORD570). I have 6.04 MM
> >
> > In a moments, the screen not change, and then checking the joblog for
> > this works(with command wrkactjob), I am view a message that is
> > repeated "Access Plan not Update".
> >
> > Please if any can you help me. If need more information, please
> > advice.
> >
> > Regards
> >
> >
> > Cesar Iracheta Mata
> > Suelas WYNY
> >
> >
> > _______________________________________________
> > This is the SSA's BPCS ERP System (BPCS-L) mailing list
> > To post a message email: BPCS-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
> > or email: BPCS-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives at
> > http://archive.midrange.com/bpcs-l.
> >
> >
>
> _______________________________________________
> This is the SSA's BPCS ERP System (BPCS-L) mailing list
> To post a message email: BPCS-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
> or email: BPCS-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/bpcs-l.
>
> _______________________________________________
> This is the SSA's BPCS ERP System (BPCS-L) mailing list
> To post a message email: BPCS-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
> or email: BPCS-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/bpcs-l.
>
>