eBook: Best Practices for DB2 on z/OS Performance

eBook: Best Practices for DB2 on z/OS Performance


With the DB2 optimizer, the optimizer is the component of DB2 that determines the access plan to be used. During the preparation (static bind or dynamic prepare) of an SQL statement, the SQL compiler is called on to generate an access plan. The access plan contains the data access strategy, including index usage, sort methods, locking semantics, and join methods. To predict performance or troubleshoot performance problems, we need to understand what the optimizer is doing in order. Here we'll look at the various access paths and components evaluated by the optimizer when determining the plan for data access.


This book contains general information about improving performance for DB2 on z/OS and specific information about how BMC products help improve performance.

BMC Software, Inc.
17 Apr 2009
17 Apr 2009
106 Page(s)
Already a Bitpipe member? Login here

Download this eBook!

By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.

You also agree that your personal information may be transferred and processed in the United States, and that you have read and agree to the Terms of Use and the Privacy Policy.