If it is not possible to update the access plan for static SQL in a program,
it will be updated the next time the program is executed.
The access path stored within the program object is only stored for static
SQL and is only used if there is no other access plan to be validated, i.e.
when the query is executed by the CQE or it is executed by the SQE and no
access plan is found in the SQE Plan Cache.

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"

-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von Mike Cunningham
Gesendet: Thursday, 26.4 2012 14:47
An: Midrange Systems Technical Discussion
Betreff: RE: SQL7917

Thanks Rob. I did find that but the thread was 18 months old and talks about
away to stop the error but does not explain how to determine what is being
locked and who has the lock. And says going to dynamic will have a negative
impact on performance

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Thursday, April 26, 2012 8:41 AM
To: Midrange Systems Technical Discussion
Subject: Re: SQL7917

http://www.ibm.com/developerworks/forums/thread.jspa?messageID=14494840&tsta
rt=0



Rob Berendt

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].