Ansicht
Dokumentation

SQL4024 - Parallel index preload access method used. ( OS/400 )

ROGBILLS - Synchronize billing plans   Addresses (Business Address Services)  
This documentation is copyright by IBM.


Message : SQL4024
Parallel index preload access method used.

Message Long Text :

Cause . . . . . : The query optimizer chose to use a parallel index preload access method to reduce the processing time required for this query. This means that the indexes used by this query will be loaded into active memory when the query is opened.
Recovery . . . : Parallel index preload can improve the performance of queries. Even though the access plan was created to use parallel preload, the system will actually use parallel preload only if the following are true:
-- The query attribute degree was specified with an option of *IO or *ANY for the application process.
-- There is enough main storage to load all of the index objects used by this query into active memory. Normally, a minimum of 5 megabytes would be a minimum. Increasing the size of the shared pool may improve performance.
For more information on parallel index preload, refer to the DB2 for i - Database Performance and Query Optimization topic collection in the Database category in the IBM i Information Center, http://www.ibm.com/systems/i/infocenter/.

Message File : QSQLMSG
Library Message File : QSYS2924


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

Length: 3230 Date: 20240426 Time: 141705     sap01-206 ( 3 ms )