Transcription of DB2 for z/OS Distributed Data Facility Questions …
{{id}} {{{paragraph}}}
Example: quiz answers
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? 3. DDF CPU time it's an SQL thing Typically, the vast majority of DDF's CPU time simply reflects the cost of executing SQL statements that come through DDF.
Agenda •DDF monitoring and tuning •DDF application architecture •DDF workload management and control •DDF and data security 2
Loading..
Tags:
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document: