© Copyright, 2002 Howard F. Arner, Jr. All Rights Reserved. Unauthorized duplication prohibited.
Slide: 37   4/2/2002
More Bad Messages
•CPI432A Query Optimizer Timed Out
–This is bad, as all access paths were not considered.  The optimizer might have been one path away from query nirvana.
–In this case, is the preferred path is not considered, try naming the DDS logical in the FROM clause of the query.  This causes the AS/400 to consider it first.