Ansicht
Dokumentation

SQL402B - Table &1 used in hash join step &2. ( OS/400 )

Addresses (Business Address Services)   BAL Application Log Documentation  
This documentation is copyright by IBM.


Message : SQL402B
Table &1 used in hash join step &2.

Message Long Text :

Cause . . . . . : This message lists the table number used by the hash join steps. The table number refers to the relative position of this table in the query.
If there are two or more of these messages for the same hash join step, then that step is a nested loop join.
Access plan implementation information for each of the hash join step are not available because access plans are not saved for the individual hash steps. Debug messages detailing the implementation of each hash step 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 hashing

Message File : QSQLMSG
Library Message File : QSYS2924


CPI1466 during Backup   BAL Application Log Documentation  
This documentation is copyright by IBM.

Length: 3221 Date: 20240425 Time: 183327     sap01-206 ( 2 ms )