Ansicht
Dokumentation
SQL402A - Hashing algorithm used to process join. ( OS/400 )
ROGBILLS - Synchronize billing plans General Material DataThis documentation is copyright by IBM.
Message : SQL402A
Hashing algorithm used to process join.
Message Long Text :
Cause . . . . . : The hash join algorithm is typically used for longer running join queries. The original query will be subdivided into hash join steps.
Each hash join step will be optimized and processed separately. Access plan implementation information for each of the hash join steps is not available because access plans are not saved for the individual hash join dials. Debug messages detailing the implementation of each hash dial can be found in the joblog if the query is run in debug mode using the STRDBG CL command.
Recovery . . . : The hash join method is usually a good implementation choice, however, if you want to disallow the use of this method specify ALWCPYDTA(*YES).
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 hashing algorithm for join processing.
Message File : QSQLMSG
Library Message File : QSYS2924
SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up rdisp/max_wprun_time - Maximum work process run time
This documentation is copyright by IBM.
Length: 3225 Date: 20240417 Time: 204229 sap01-206 ( 3 ms )