Ansicht
Dokumentation

CPI4321 - Access path built for &18 &19. ( OS/400 )

BAL_S_LOG - Application Log: Log header data   rdisp/max_wprun_time - Maximum work process run time  
This documentation is copyright by IBM.


Message : CPI4321
Access path built for &18 &19.

Message Long Text :

Cause . . . . . : A temporary access path was built to access records from member &6 of &18 &19 in library &5 for reason code &10. This process took &11 minutes and &12 seconds. The access path built contains &15 entries. The access path was built using &16 parallel tasks. A zero for the number of parallel tasks indicates that parallelism was not used. 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 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 &18 &19 in library &5 is a logical file then the access path is built over member &9 of physical file &7 in library &8.
A file name starting with *QUERY or *N indicates the access path was built over a temporary file.
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.
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 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 . . . . . . . . : 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   PERFORM Short Reference  
This documentation is copyright by IBM.

Length: 3238 Date: 20240419 Time: 054824     sap01-206 ( 2 ms )