Insert performance in DB2 UDB for z/OS V8  Product documentation

Abstract
Insert performance is, and has been, one of the most critical areas in any database management system. This is especially obvious in a customer benchmark environment where a very high insert rate is often the most challenging requirement. This presentation covers the major factors affecting insert performance along with performance monitoring and tuning tips.


Content
Akira Shibamiya, IBM® Silicon Valley Lab This presentation contains information about the following topics:
1. Index, data, and log I/O's in Insert
2. CPU time in Insert
3. Lock/latch contentions encountered in Insert 4. V8 multi-row Insert performance enhancement 5. Performance monitoring and tuning tips Insert performance in DB2® UDB for z/OS® V8


(C) Copyright IBM Corp. 2005. All Rights Reserved. US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.

All information available on/through this Web site is provided for the convenience of our customers and without warranty of any kind, including any warranty as to the accuracy of the information contained therein. Use of copyrighted materials for other than your own personal use is expressly prohibited without the written notice of the copyright owner.

P.S. Please pass my address to anyone interested in DB2 HOTLINE - thank you.

With kind regards
Michael Dewert, Software Group
DB2 Information Management Software