Ansicht
Dokumentation

SQL4034 - Multiple join classes used to process join. ( OS/400 )

rdisp/max_wprun_time - Maximum work process run time   SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up  
This documentation is copyright by IBM.


Message : SQL4034
Multiple join classes used to process join.

Message Long Text :

Cause . . . . . : Multiple join classes are used when join queries are written that have conflicting operations or cannot be implemented as a single query.
Each join class will be optimized and processed as a separate step of the query with the results written out to a temporary table.
Access plan implementation information for each of the join classes is not available because access plans are not saved for the individual join class dials. Debug messages detailing the implementation of each join dial can be found in the joblog if the query is run in debug mode using the STRDBG CL command.
Recovery . . . : 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 join classes.

Message File : QSQLMSG
Library Message File : QSYS2924


Addresses (Business Address Services)   General Data in Customer Master  
This documentation is copyright by IBM.

Length: 3229 Date: 20240424 Time: 180735     sap01-206 ( 3 ms )