|
hello there an as400 cmd call prtsqlinf or dspsqlinf and the parameter is the program name one you print that you will see the "bottle neck " of each program back in 1999 when we migrated to V6.04 from v4.2 i had to go around all the ORD7XX programs to do just that and that improved performance the SQL in some case create a "logical" every time the program runs i have about 20 SQL performance related logical Best Regards Danny Monselise ------------------------------------------------- Agis Group Ltd.
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.