RE: Access Plan Not Updated

["Cesar Iracheta Mata" <iracheta@xxxxxxxxxxx>]

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.