Ansicht
Dokumentation

SQL401E - Temporary distributed result table &1 was created because table &2 was broadcast. ( OS/400 )

SQL401E - Temporary distributed result table &1 was created because table &2 was broadcast. ( OS/400 )

RFUMSV00 - Advance Return for Tax on Sales/Purchases   BAL_S_LOG - Application Log: Log header data  
This documentation is copyright by IBM.
SAP E-Book


Message : SQL401E
Temporary distributed result table &1 was created because table &2 was broadcast.

Message Long Text :

Cause . . . . . : Temporary distributed result table was created to contain the intermediate results of the query. Data from a distributed table in the query was broadcast to all nodes.
Recovery . . . :
Generally, a table is broadcast when join columns do not match the partitioning keys of either table being joined or the join operator is not an equal operator. When a table is broadcast the query is processed in multiple steps and processed in parallel. A temporary distributed result table is required to contain the intermediate results for each step.
For more information on processing of distributed tables, refer to the DB2 Multisystem topic collection in the Database category in the IBM i Information Center book, http://www.ibm.com/systems/i/infocenter/.

Message File : QSQLMSG
Library Message File : QSYS2924


General Data in Customer Master   General Data in Customer Master  
This documentation is copyright by IBM.

Length: 3267 Date: 20240328 Time: 095406     sap01-206 ( 3 ms )