Ansicht
Dokumentation

CPI4345 - Temporary distributed result file &3 built for query. ( OS/400 )

General Data in Customer Master   RFUMSV00 - Advance Return for Tax on Sales/Purchases  
This documentation is copyright by IBM.


Message : CPI4345
Temporary distributed result file &3 built for query.

Message Long Text :

Cause . . . . . : Temporary distributed result file &3 was created to contain the intermediate results of the query for reason code &6. The reason codes and their meanings follow:
1 - Data from member &2 of &7 &8 in library &1 was directed to other nodes.
2 - Data from member &2 of &7 &8 in library &1 was broadcast to all nodes.
3 - Either the query contains grouping fields (GROUP BY) that do not match the partitioning keys of the distributed file or the query contains grouping criteria but no grouping fields were specified or the query contains a subquery.
4 - Query contains join criteria over a distributed file and the query was processed in multiple steps.
A library and member name of *N indicates the data comes from a query temporary distributed file.
File &3 was built on nodes: &9.
It was built using partitioning keys: &10.
A partitioning key of *N indicates no partitioning keys were used when building the temporary distributed result file.
Recovery . . . : If the reason code is:
1 - Generally, a file is directed when the join fields do not match the partitioning keys of the distributed file. When a file 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.
2 - Generally, a file is broadcast when join fields do not match the partitioning keys of either file being joined or the join operator is not an equal operator. When a file is broadcast 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.
3 - Better performance may be achieved if grouping fields are specified that match the partitioning keys.
4 - Because the query is processed in multiple steps, a temporary distributed result file is required to contain the intermediate results for each step. See preceding message CPI4342 to determine which files were joined together.
For more information on processing of distributed files, 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 : QCPFMSG
Library Message File : QSYS2924


General Material Data   PERFORM Short Reference  
This documentation is copyright by IBM.

Length: 3261 Date: 20240426 Time: 220657     sap01-206 ( 3 ms )