Inaccurate info on R/SYSWKDB Wfspc DGTT Pref KB, Wfspc Pref KB
book
Article ID: 103062
calendar_today
Updated On:
Products
CA Bind Analyzer for DB2 for z/OSCA DetectorCA SQL-Ease for DB2 for z/OSCA Sysview Performance Management Option for DB2 for z/OSCA Database Detector for DB2 for z/OSCA Plan Analyzer for DB2 for z/OSCA Subsystem Analyzer for DB2 for z/OS
Issue/Introduction
R/SYSWKDB Workfile DB Utilization Summary Wfspc DGTT Pref KB Question on Wfspc DGTT Pref KB field - Workfile Space Used (KB), By All Agents For DGTT / Config. Sysview shows a value for Wfspc DGTT Pref KB (134218K) significantly larger than Wfspc Pref KB - Workfile Space Used (KB), By All Agents Except For DGTT / Config (56758K)
R/SYSWKDB Workfile DB Utilization Summary Wfspc DGTT Pref KB Question on Wfspc DGTT Pref KB field - Workfile Space Used (KB), By All Agents For DGTT / Config. Sysview shows a value for Wfspc DGTT Pref KB (134218K) significantly larger than Wfspc Pref KB - Workfile Space Used (KB), By All Agents Except For DGTT / Config (56758K), On this subsystem there are only 2 DGTT preferred workfiles with a max capacity of 128gb. Whereas there are 30 non DGTT preferred workfiles, each at about 2gb. So we would expect to see a much smaller value for Wfspc DGTT Pref KB. Menu Print Tools Help CA SYSVIEW for DB2 D2PA PROD 06/15/18 15:33:44 19.0 D2PA DBA04 Menu Print Tools Help CA SYSVIEW for DB2 D2PA PROD 06/15/18 15:33:44 19.0 D2PA DBA04 R/SYSWKDB Workfile DB Utilization Summary - Accum Row 11-24/24 Accum Number of times workfile not created 0 In Use HWM StIn HWM Config Workfile Pct of Config Space Used (%) 0.0 15.5 0.0 Workfile Space Used (KB) 32768 29695K 49152 190976K By 4K Tablespaces 0 4096 By 32K Tablespaces 32768 49152 By All Agents For DGTT 0 2745344 0 134218K <<<<<<<<<< By All Agents Except For DGTT 32768 29695K 49152 56758K >>>>>>>>>> By RID Pool Blocks 0 0 0 In-Mem Sort-Related DM Workfiles 3 168 5 In-Mem Non-Sort DM Workfiles 0 62 2 In-Mem Sort Non-DM Workfiles 0 9 0 In-Mem Workfile Space Used (KB) 96 5376 160 In-Mem Sort Workfile Space (KB) 0 999 0
Environment
z/os db2
Resolution
Q) Apparently WFSPC-DGTT-PREF-KB refers to the total DGTT capacity = 60 2gb files, and WFSPC-PREF-KB refers to the total non-DGTT capacity - 30 2g files. Do you concur? A) Using IBM's description of these fields they describe them as total (KB) configured so i would say that means capacity yes. Q) Re WFSPC-DGTT-USED-KB and WFSPC-USED-KB Correct it is Storage currently used