IBM Db2 - The Ultimate Database for Cloud, Analytics & Mobile
Join John Campbell live, this will be an interactive session. John will be live on camera
Session 4: Saving CPU: Using thread reuse and BIND option RELEASE DEALLOCATE
Abstract: Many installations are still missing out on opportunities to trade additional memory usage to reduce CPU resource consumption by designing for efficient thread reuse and combining this with packages bound with RELEASE(DEALLOCATE). This session will: describe what is thread reuse, which application processes to target, how to design for thread reuse, where to see the benefits, how the use of BIND option RELEASE(DEALLOCATE) can help when coupled with thread reuse, how to select which packages, limitations and considerations.