Transcription of DB2 for z/OS Distributed Data Facility Questions …
{{id}} {{{paragraph}}}
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.
Explaining less-than-expected DRDA zIIP offload (1) •Check stored procedure CPU time (two fields, labeled “C” and “D” on the report snippet on the preceding slide) If C is much larger than D (and here, D is zero), that indicates
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
{{id}} {{{paragraph}}}
Understanding Universal Data Access, OLE, Database Connectivity Toolset User Manual, Database Connectivity Toolset User Manual Database Connectivity Toolset User Manual, Data Encryption, MIGRATING TO ORACLE DATABASE, Oracle, Oracle SQL, AWS Database Migration Service - Step-by, AWS Database Migration Service Step-by