Ansicht
Dokumentation

CPI434C - The query access plan was not rebuilt. ( OS/400 )

SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up   Addresses (Business Address Services)  
This documentation is copyright by IBM.


Message : CPI434C
The query access plan was not rebuilt.

Message Long Text :

Cause . . . . . : The access plan for this query was not rebuilt. The optimizer determined that this access plan should be rebuilt for reason code &13. However, the query attributes in the QAQQINI file disallowed the optimizer from rebuilding this access plan at this time.
For a full explaination of the reason codes and their meanings, view the second level text of the message CPI4323.
Recovery . . . : Since the query attributes disallowed the query access plan from being rebuilt, the query will continue to be implemented with the existing access plan. This access plan may not contain all of the performance benefits that may have been derived from rebuilding the access plan.
For more information on query attributes refer to the DB2 for i - Database Performance and Query Optimization topic collection in the Database category in the IBM i Information Center or the DB2 for IBM i SQL Reference topic collection in the Database category in the IBM i Information Center information in the iSeries Information Center.
Technical description . . . . . . . . : The optimizer determined that this access plan needed to be rebuilt because of reason code &13. This reason code has a sub-type identifier of &14 that is used for internal system tracking.

Message File : QCPFMSG
Library Message File : QSYS2924


rdisp/max_wprun_time - Maximum work process run time   General Material Data  
This documentation is copyright by IBM.

Length: 3226 Date: 20240419 Time: 110558     sap01-206 ( 2 ms )