Alessandro Oppici
  • Male
  • Alseno
  • Italy
Share on Facebook Share on Facebook Share

Alessandro Oppici's Friends

  • Cindy Russell

Alessandro Oppici's Discussions

DB2 workload manager problem

Hi guys, I would like to use DB2 workload manager feature but I don't understand what is really required to use it.From the documentation I read that one of the following licensed products is…Continue

Started Jan 25, 2014

DB2 time spent metrics

Hi guys,I'm analyzing my database in order to understand where DB2 spends his time at the system level.I have not created other user defined service class so I focused only on SYSDEFAULTUSERCLASS…Continue

Started Jan 24, 2014

Gifts Received


Alessandro Oppici has not received any gifts yet

Give a Gift


Alessandro Oppici's Page

Profile Information

Full Name:
Alessandro Oppici
Job Title:
Platforms of Interest:

Alessandro Oppici's Blog

Service class time component

Posted on April 24, 2016 at 2:58am 0 Comments

Hi everyone,

In order to analize system performance I tried to discover how time is spent within my database system.

According to the documentation, TOTAL_RQST_TIME=TOTAL_WAIT_TIME + TOTAL_*_PROC_TIME.

By querying the service class table function (MON_GET_SERVICE_CLASS) I'm disappointed by the fact that there is a big difference between total_rqst_time and the sum of all other values.

It seems that with "normal" DML statements these two values are quite…


Comment Wall

You need to be a member of ChannelDB2 to add comments!

Join ChannelDB2

  • No comments yet!

Featured Downloads

Try BLU Acceleration on Cloud

© 2020   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service