© Copyright, 2002 Howard F.
Arner, Jr. All Rights Reserved. Unauthorized duplication prohibited.
What to look for
•The important thing during validation is to assure that the query is using a good access path
•Look at the throughput of the query and ensure that the Prepare, Execute and Fetch phases are not taking a large period of time
•Look at the access paths considered, CPI432C message, to determine why an access path was selected/rejected
•The following messages bear investigation