Ansicht
Dokumentation

CPI432A - Query optimizer timed out for file &1. ( OS/400 )

CPI432A - Query optimizer timed out for file &1. ( OS/400 )

ROGBILLS - Synchronize billing plans   BAL_S_LOG - Application Log: Log header data  
This documentation is copyright by IBM.
SAP E-Book


Message : CPI432A
Query optimizer timed out for file &1.

Message Long Text :

Cause . . . . . : The query optimizer timed out before it could consider all access paths built over member &3 of file &1 in library &2.
The list below shows the access paths considered before the optimizer timed out. If file &1 in library &2 is a logical file then the access paths specified are actually built over member &9 of physical file &7 in library &8. Following each access path name in the list is a reason code which explains how the optimizer considered the access path.
&11.
The reason codes and their meanings follow:
0 - The access path was used to implement the query.
1 - Access path was not in a valid state. The system invalidated the access path.
2 - Access path was not in a valid state. The user requested that the access path be rebuilt.
3 - Access path is a temporary access path (resides in library QTEMP) and was not specified as the file to be queried.
4 - The cost to use this access path, as determined by the optimizer, was higher than the cost associated with the chosen access method.
5 - The keys of the access path did not match the fields specified for the ordering/grouping criteria.
6 - The keys of the access path did not match the fields specified for the join criteria.
7 - Use of this access path would not minimize delays when reading records from the file as the user requested.
8 - The access path cannot be used for a secondary file of the join query because it contains static select/omit selection criteria. The join-type of the query does not allow the use of select/omit access paths for secondary files.
9 - File &1 contains record ID selection. The join-type of the query forces a temporary access path to be built to process the record ID selection.
10 and greater - View the second level message text of the next message issued (CPI432D) for an explanation of these reason codes.
Recovery . . . : To ensure an access path is considered for optimization specify that access path to be the queried file. The optimizer will first consider the access path of the file specified on the query. SQL-created indexes cannot be queried but can be deleted and recreated to increase the chance they will be considered during query optimization.
The user may want to delete any access paths no longer needed.

Message File : QCPFMSG
Library Message File : QSYS2924


Addresses (Business Address Services)   General Material Data  
This documentation is copyright by IBM.

Length: 3250 Date: 20240329 Time: 033115     sap01-206 ( 3 ms )