Event 209: waiting for a pipe buffer to read

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.