Ansicht
Dokumentation

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

PERFORM Short Reference   rdisp/max_wprun_time - Maximum work process run time  
This documentation is copyright by IBM.


Message : SQL401D
Temporary distributed result table &1 was created because table &2 was directed.

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 directed to other nodes.
Recovery . . . :
Generally, a table is directed when the join columns do not match the partitioning keys of the distributed table. When a table is directed, the query is processed in multiple steps and processed in parallel. A temporary distributed result file 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 Material Data   BAL Application Log Documentation  
This documentation is copyright by IBM.

Length: 3266 Date: 20240424 Time: 123606     sap01-206 ( 3 ms )