Communication between DB2 data partitions

Communication between DB2 data partitions
Understanding table queues

In partitioned database environments, query processing requires data to be
exchanged between database partitions. Table queues(often referred to as
TQs) are the vehicle that the DB2 product uses for passing rows between
partitions. The TQs interact with the underlying communication layer, called
FCM, to transmit the bits and bytes. TQs are a determining factor of query
performance in DPF. This article provides an in-depth look at table queues,
includes tips on how to identify whether a performance problem is due to TQ
behavior, and, more importantly, explains what you can do to resolve such a
problem.