Hello,

does anyone experimented already the lock problem while updating the acces plan
(SQL Package)?
We are AS/400 6.0.04 MM, and we want to split the object libraries for each
production enviroment (8 in Europe).
This was an SSA recommendation, but after some tests we've seen that the access
plan can not be always updated because the optimizer needs an exclusive acces to
the object to rewrite the access plan.

Any skill on that apreciated.
Thanks,

Francisco

+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---


This thread ...


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 here. If you have questions about this, please contact [javascript protected email address].