Transcription of DB2 for z/OS Distributed Data Facility Questions …
{{id}} {{{paragraph}}}
Example: stock market
DB2 for z/OS Distributed Data Facility Questions …
DB2 for z/OS Distributed data Facility Questions and Answers Michigan DB2 Users Group Robert Catterall, IBM. May 11, 2016. 2016 IBM Corporation Agenda DDF monitoring and tuning DDF application architecture DDF workload management and control DDF and data security 2. DDF monitoring and tuning Q: Why is CPU time so high for the DDF. address space? The question is prompted by information like this, from a DB2. monitor statistics long report (this was for a 2-hour interval): CPU TIMES TCB TIME PREEMPT SRB NONPREEMPT SRB PREEMPT IIP SRB. ----------- -------- ------------- -------------- --------------- SYSTEM SVCS 2 N/A. DB SVCS 5 50 IRLM N/A. DDF 1 3:13 2 2:55 More than 6 hours of DDF CPU time People are used to seeing relatively small CPU times for DB2. address spaces what gives here? Is something wrong? Is DDF a pig?
Q: Why is CPU time so high for the DDF address space? •The question is prompted by information like this, from a DB2 monitor statistics long report (this was for a 2-hour interval): •People are used to seeing relatively small CPU times for DB2 address spaces –what gives here?
Loading..
Tags:
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document: