WORKFILE

Denotes a work file or temporary table that DB2 generates.

DB2 labels a work file node with the word WORKFILE or with specific name. Sort (for JOIN, UNION, DISTINCT, GROUP BY, or ORDER BY operations) is the most common operation for generating work files.