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.

Vendor:: BMC Software, Inc.
Posted:: Feb 8, 2021
Published:: Apr 17, 2009
Format:: PDF
Type:: eBook

Already a Bitpipe member? Log in here

Download this eBook!

Corporate Email Address:
You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

Please provide a Corporate Email Address.

This email address is already registered. Please log in.
First Name:
You forgot to provide your first name.
Last Name:
You forgot to provide your last name.
Company Name:
You forgot to provide a company name.
Job Title:
You forgot to provide a job title.
Seniority:
You forgot to select your seniority.
Job Function:
You forgot to select your job function.
# of employees:
You did not select the number of employees at your company.
Industry:
You did not select which industry you are in.
Sub-Industry:
You did not select which industry you are in.
Address 1:
You did not provide a full local address.
Address 2:
City/Town:
You did not provide a full local address.
Country:
You did not select the country you are from.
State/Province:

You did not provide a full local address.
Zip/Postal Code:
You did not provide a full local address.
Phone:
You forgot to provide a phone number.

This phone number format is not recognized. Please check the country and number.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.