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
midrange.com
