DB2 Workfile scan

0 votes

1 answer

150 views

optimization db2 performance db2-zos performance-tuning

                          We just migrate from LUW to zos and we're finding that in z/os the accesspath explains show new node named  WFSCAN (Workfile scan) and this rises when there is a join, group by or any kind of sort.
The question  is, Is any performance issue with WFSCAN. Should I be worry about the size of the pool it uses or any other costs in production environment?
What should I do for better performance of Workfile Scans?
                        

Asked by Hana Bzh (101 rep)

Oct 17, 2018, 09:35 AM
Last activity: Aug 2, 2025, 07:09 AM

DB2 Workfile scan

Related Questions