Ansicht
Dokumentation

CPI4322 - Access path built from keyed file &1. ( OS/400 )

CPI1466 during Backup   RFUMSV00 - Advance Return for Tax on Sales/Purchases  
This documentation is copyright by IBM.


Message : CPI4322
Access path built from keyed file &1.

Message Long Text :

Cause . . . . . : A temporary access path was built using the access path from member &3 of keyed file &1 in library &2 to access records from member &6 of file &4 in library &5 for reason code &10. This process took &11 minutes and &12 seconds. The access path built contains &15 entries. The reason codes and their meanings follow:
1 - Perform specified ordering/grouping criteria.
2 - Perform specified join criteria.
3 - Perform specified record selection to minimize I/O wait time.
The access path was built using the following key fields. The key fields and their corresponding sequence (ASCEND or DESCEND) will be shown:
&17.
A key field of *MAP indicates the key field is an expression (derived field).
The temporary access path was built using sequence table &13 in library &14.
A sequence table of *N indicates the access path was built without a sequence table. A sequence table of *I indicates the table was an internally derived table that is not available to the user.
If file &4 in library &5 is a logical file then the temporary access path is built over member &9 of physical file &7 in library &8. Creating an access path from a keyed file generally results in improved performance.
Recovery . . . : If this query is run frequently, you may want to create an access path (index) similar to this definition for performance reasons. Create the access path using sequence table &13 in library &14, unless the sequence table is *N. If an access path is created, it is possible the query optimizer may still choose to create a temporary access path to process the query.
If *MAP is returned for one of the key fields or *I is returned for the sequence table, then a permanent access path cannot be created. A permanent access path cannot be built with these specifications.
A temporary access path can only be created using index only access if all of the fields that were used by this temporary access path are also key fields for the access path from the keyed file.
For more information, refer to the DB2 for i - Database Performance and Query Optimization topic collection in the Database category in the IBM i Information Center.
Technical description . . . . . . . . : Parallelism can only be implemented when the system feature DB2 Symmetric Multiprocessing is installed on the system.

Message File : QCPFMSG
Library Message File : QSYS2924


rdisp/max_wprun_time - Maximum work process run time   TXBHW - Original Tax Base Amount in Local Currency  
This documentation is copyright by IBM.

Length: 3245 Date: 20240419 Time: 225808     sap01-206 ( 3 ms )