|
Ladies and Gentlemen--We have an application that does most of its work with SQL against i5/iSeries/AS400/S38 databases.
We have had some issues, and the recommendation is to run a weekly database maintenance consisting of "rebuilding indexes" and running RUNSTATS against the database. The goal is to make things easier for the Optimizer.
We ran the vendor's Database Revitalizer, and it said that index rebuilds aren't needed on this machine; it did show RUNSTATS statements (but I'm not convinced they actually did anything).
Everything I'm aware of, and the literature I've been able to dig up, indicates that rebuilding indexes is not required on the i5/etc. machines because the indexes are -always- kept up to date (unless you specify maint(*dly) or something).
And I have found some not-quite-definitive statements that indicate that RUNSTATS doesn't work (and isn't required) on the i5/etc. I entered STRSQL, and RUNSTATS is an unknown keyword. I don't know if QSHELL has a RUNSTATS hidden away somewhere.
First, comments are welcome; second, I'm looking for links to IBM or other documents that definitely say "RUNSTATS isn't needed," and neither are routine index rebuilds.
Thanks for your assistance. --Paul E Musselman PaulMmn@xxxxxxxxxxxxxxxxxxxx
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 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].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
