Ansicht
Dokumentation

CPI4328 - Access path of file &3 was used by query. ( OS/400 )

CPI1466 during Backup   rdisp/max_wprun_time - Maximum work process run time  
This documentation is copyright by IBM.


Message : CPI4328
Access path of file &3 was used by query.

Message Long Text :

Cause . . . . . : Access path for member &5 of file &3 in library &4 was used to access records from member &2 of &12 &13 in library &1 for reason code &9. The reason codes and their meanings follow:
1 - Record selection.
2 - Ordering/grouping criteria.
3 - Record selection and ordering/grouping criteria.
If file &13 in library &1 is a logical file then member &8 of physical file &6 in library &7 is the actual file being accessed.
Index only access was used for this query: &11.
A value of *YES for index only access processing indicates that all of the fields used for this query can be found within the access path of file &3. A value of *NO indicates that index only access could not be performed for this access path.
Index only access is generally a performance advantage since all of the data can be extracted from the access path and the data space does not have to be paged into active memory.
Recovery . . . : An access path can only be considered for index only access if all of the fields used within the query for this file are also key fields for that access path.
Refer to the DB2 for i - Database Performance and Query Optimization topic collection in the Database category in the IBM i Information Center for additional tips on index only access.

Message File : QCPFMSG
Library Message File : QSYS2924


Fill RESBD Structure from EBP Component Structure   rdisp/max_wprun_time - Maximum work process run time  
This documentation is copyright by IBM.

Length: 3239 Date: 20240426 Time: 105420     sap01-206 ( 2 ms )