waiting for a pipe buffer to read
Short Description
When Adaptive Server performs a sort in parallel (for example, create index that specifies a consumers clause), it uses an internal mechanism to send data between the various tasks. Event 209 measures the amount of time the tasks spend waiting for other tasks to add data to a pipe.
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.