Ansicht
Dokumentation

SQL4033 - &1 tasks specified for parallel bitmap create using &2. ( OS/400 )

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


Message : SQL4033
&1 tasks specified for parallel bitmap create using &2.

Message Long Text :

Cause . . . . . : The query optimizer has calculated the optimal number of tasks to use to create the bitmap based on the query attribute degree.
Recovery . . . : Using parallel index scan to create the bitmap can improve the performance of queries. Even though the access plan was created to use the specified number of tasks, the system may alter that number based on the availability of the pool in which this job is running or the allocation of the file's data across the disk units.
Refer to the DB2 for i - Database Performance and Query Optimization topic collection in the Database category in the IBM i Information Center for more information on parallel scan.
Technical description . . . . . . . . : Parallel scan can only be implemented when the system feature DB2 Symmetric Multiprocessing is installed on the system.

Message File : QSQLMSG
Library Message File : QSYS2924


ROGBILLS - Synchronize billing plans   SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up  
This documentation is copyright by IBM.

Length: 3241 Date: 20240426 Time: 033430     sap01-206 ( 3 ms )