For the TQUEUE operator (displayed only for
intra-partition parallelism, inter-partition parallelism, or full
parallelism (intra-partition and inter-partition)), the following input
arguments are shown:
- Merging
- A flag, true or false, indicating if the table queue merges the input
maintaining the sort order. (This item is displayed only for
intra-partition parallelism, inter-partition parallelism, or full parallelism
(intra-partition and inter-partition)).
(This item is available in Full details mode only.)
-
Unique
- A flag, true or false, indicating if the table queue will perform
duplicate elimination. (This item is displayed only for inter-partition
parallelism or full parallelism (intra-partition and inter-partition)).
(This item is available in Full details mode only.)
-
Listener
- A flag, true or false, indicating if the table queue waits for results
from other nodes. (This item is displayed only for inter-partition
parallelism or full parallelism (intra-partition and inter-partition)).
(This item is available in Full details mode only.)
- Table queue type
- A flag, local or non-local, indicating if the table queue supports
multiple local subagents or intra-partition parallelism. (This item is
displayed only for intra-partition parallelism or full parallelism
(intra-partition and inter-partition)).
-
Table queue send type
- The send mechanism the table queue uses (displayed only for
inter-partition parallelism or full parallelism (intra-partition and
inter-partition)):
- Broadcast - Data is sent to all members of the nodegroup
associated with the partitioning map ID (PMID).
- Directed - Data is directed at specific nodes within the
nodegroup.
- Scatter - Data is randomly sent to members within the
nodegroup.
- Subquery stepping - The table queue is associated with a
correlated subquery.
- Table queue read type
- The read mechanism that the table queue uses (displayed only for
intra-partition parallelism, inter-partition parallelism, or full parallelism
(intra-partition and inter-partition)):
- Ahead - Data is read as it is being received.
- Stepping - Data reading is controlled carefully, typically due
to a CURSOR.
- Subquery stepping - The table queue is associated with a
correlated subquery.
- Intra-partition degree of parallelism
- The number of subagents that will be used to write to this table
queue. (This item is displayed only for intra-partition parallelism or
full parallelism (intra-partition and inter-partition)).
-
Partition columns
- The list of columns that the data is partitioned on. An empty list
indicates that the data partitioning is uninteresting or undetermined.
(This item is displayed only for inter-partition parallelism or full
parallelism (intra-partition and inter-partition)).
- Order columns
- The list of columns that the rows passing through this table queue are
ordered on. (This item is displayed only for intra-partition
parallelism, inter-partition parallelism, or full parallelism (intra-partition
and inter-partition)).
[ Top of Page |
Table of Contents |
Glossary |
Index ]
[ DB2 List of Books |
Search the DB2 Books ]