Ansicht
Dokumentation

SQL4025 - Parallel table preload access method used. ( OS/400 )

Fill RESBD Structure from EBP Component Structure   General Data in Customer Master  
This documentation is copyright by IBM.


Message : SQL4025
Parallel table preload access method used.

Message Long Text :

Cause . . . . . : The query optimizer chose to use a parallel table preload access method to reduce the processing time required for this query. This means that the data accessed by this query will be loaded into active memory when the query is opened.
Recovery . . . : Parallel table 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 must have been specified with an option of *IO or *ANY for the application process.
-- There is enough main storage available to load all of the data in the file into active memory. Normally, 5 megabytes would be a minimum. Increasing the size of the shared pool may improve performance.
For more information on parallel table 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


RFUMSV00 - Advance Return for Tax on Sales/Purchases   CL_GUI_FRONTEND_SERVICES - Frontend Services  
This documentation is copyright by IBM.

Length: 3230 Date: 20240425 Time: 085042     sap01-206 ( 3 ms )