ChannelDB2

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

Gift

Alessandro Oppici has not received any gifts yet

Give a Gift

 

Alessandro Oppici's Page

Latest Activity

Alessandro Oppici's blog post was featured

Service class time component

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 similar but after executing other commands as…See More
May 31, 2016
Alessandro Oppici posted a blog post

Service class time component

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 similar but after executing other commands as…See More
May 31, 2016
Alessandro Oppici posted discussions
Jan 25, 2014

Profile Information

Full Name:
Alessandro Oppici
Job Title:
DBA
Company:
Kedrios
Platforms of Interest:
Linux/UNIX/Windows

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…

Continue

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

© 2018   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service