eBook: Best Practices for DB2 on z/OS Performance

eBook: Best Practices for DB2 on z/OS Performance

Cover

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.

Vendor:
BMC Software, Inc.
Posted:
17 Apr 2009
Published
17 Apr 2009
Format:
PDF
Length:
106 Page(s)
Type:
eBook
Language:
English
Already a Bitpipe member? Login here

Download this eBook!

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy