ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
Inaccurate info on R/SYSWKDB Wfspc DGTT Pref KB, Wfspc Pref KB
Article ID: 103062
Updated On:
Products
Bind Analyzer for DB2 for z/OS
SQL-Ease for DB2 for z/OS
SYSVIEW Performance Management Option for DB2 for z/OS
Plan Analyzer for DB2 for z/OS
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
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
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
Feedback
Yes
No
Powered by
