Ansicht
Dokumentation

CPI4334 - Query implemented as reusable ODP. ( OS/400 )

BAL_S_LOG - Application Log: Log header data   General Material Data  
This documentation is copyright by IBM.


Message : CPI4334
Query implemented as reusable ODP.

Message Long Text :

Cause . . . . . : The query optimizer built the access plan for this query such that a reusable open data path (ODP) will be created. This plan will allow the query to be run repeatedly for this job without having to rebuild the ODP each time. This normally improves performance because the ODP is created only once for the job.
Recovery . . . : Generally, reusable ODPs perform better than non-reusable ODPs. More information about ODPs can be found in 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


BAL Application Log Documentation   SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up  
This documentation is copyright by IBM.

Length: 3216 Date: 20240420 Time: 054822     sap01-206 ( 2 ms )