Ansicht
Dokumentation

CPI432F - Access path suggestion for file &1. ( OS/400 )

PERFORM Short Reference   BAL Application Log Documentation  
This documentation is copyright by IBM.


Message : CPI432F
Access path suggestion for file &1.

Message Long Text :

Cause . . . . . : To improve performance the query optimizer is suggesting a permanent access path be built with the key fields it is recommending. The access path will access records from member &3 of file &1 in library &2.
In the list of key fields that follow, the query optimizer is recommending the first &10 key fields as primary key fields. The remaining key fields are considered secondary key fields and are listed in order of expected selectivity based on this query. Primary key fields are fields that significantly reduce the number of keys selected based on the corresponding selection predicate. Secondary key fields are fields that may or may not significantly reduce the number of keys selected. It is up to the user to determine the true selectivity of secondary key fields and to determine whether those key fields should be used when creating the access path.
The query optimizer is able to perform key positioning over any combination of the primary key fields, plus one additional secondary key field. Therefore it is important that the first secondary key field be the most selective secondary key field. The query optimizer will use key selection with any remaining secondary key fields. While key selection is not as fast as key positioning it can still reduce the number of keys selected. Hence, secondary key fields that are fairly selective should be included. When building the access path all primary key fields should be specified first followed by the secondary key fields which are prioritized by selectivity. The following list contains the suggested primary and secondary key fields:
&11.
If file &1 in library &2 is a logical file then the access path should be built over member &9 of physical file &7 in library &8.
The sort sequence table is used in &4 and lib &5.
Recovery . . . : If this query is run frequently, you may want to create the suggested access path for performance reasons. It is possible that the query optimizer will choose not to use the access path just created.
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.

Message File : QCPFMSG
Library Message File : QSYS2924


TXBHW - Original Tax Base Amount in Local Currency   BAL_S_LOG - Application Log: Log header data  
This documentation is copyright by IBM.

Length: 3229 Date: 20240424 Time: 185504     sap01-206 ( 3 ms )