Ansicht
Dokumentation

CPI432C - All access paths were considered for file &1. ( OS/400 )

General Data in Customer Master   PERFORM Short Reference  
This documentation is copyright by IBM.


Message : CPI432C
All access paths were considered for file &1.

Message Long Text :

Cause . . . . . : The query optimizer considered all access paths built over member &3 of file &1 in library &2.
The list below shows the access paths considered. 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. For distributed file queries, the access path keys must exactly match the ordering fields if the access path is to be used when ALWCPYDTA(*YES or *NO) is specified.
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. The user requested to minimize delays when reading records from the file.
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 . . . : The user may want to delete any access paths no longer needed.

Message File : QCPFMSG
Library Message File : QSYS2924


ABAP Short Reference   Fill RESBD Structure from EBP Component Structure  
This documentation is copyright by IBM.

Length: 3255 Date: 20240420 Time: 001751     sap01-206 ( 4 ms )