As you can see, you can use many different techniques to get the optimal performance out of your stored procedures. Information was grouped by platform, because performance tuning is very platform-specific. Both monitoring and basic tuning were covered.

To ensure top-notch performance, have a properly configured environment, proper indexes, and current statistics available.

    DB2 SQL PL. Deployment and Advanced Configuration Essential Guide for DB2 UDB on Linux., UNIX, Windows, i5. OS, z. OS
    Intelligent Enterprises of the 21st Century
    ISBN: N/A
    EAN: 2147483647
    Year: 2003
    Pages: 205 © 2008-2017.
    If you may any questions please contact us: