Ansicht
Dokumentation

CPI4329 - Arrival sequence access was used for &12 &13. ( OS/400 )

Fill RESBD Structure from EBP Component Structure   Addresses (Business Address Services)  
This documentation is copyright by IBM.


Message : CPI4329
Arrival sequence access was used for &12 &13.

Message Long Text :

Cause . . . . . : Arrival sequence access was used to select records from member &2 of file &13 in library &1.
If file &13 in library &1 is a logical file then member &8 of physical file &6 in library &7 is the actual file from which records are being selected.
A file name starting with *N or *QUERY for the file indicates it is a temporary file.
Recovery . . . : The use of an access path may improve the performance of the query if record selection is specified.
If an access path does not exist, you may want to create one whose left-most key fields match fields in the record selection. Matching more key fields in the access path with fields in the record selection will result in improved performance.
Generally, to force the use of an existing access path, specify order by fields that match the left-most key fields of that access path.
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.

Message File : QCPFMSG
Library Message File : QSYS2924


General Material Data   General Material Data  
This documentation is copyright by IBM.

Length: 3237 Date: 20240426 Time: 173005     sap01-206 ( 2 ms )