installed dmc on linux and monitoring db2 luw databases
being on screen : monitor - statement - package cache


------------------------------
Thanks for all answers
Best Regards,
Guy Przytula
------------------------------

#Db2

Hello Guy,

This is Ke from DMC development team. We appreciate your comments to make DMC better. I'm trying to answer your questions one by one.

• Estimated runtime is in the format of hours:minutes:seconds.milliseconds. I'll suggest the design team to add more description for this column.
• Package cache page is originated from table function mon_get_pkg_cache_stmt. It aims to display the executed SQLs on the monitored database. When you move the mouse on each row in the grid,  you will see an icon with three dots appears. It has several actions for this row. You can view more details via view detail button.

• Could you explain more about the commands you need to run manually? Anything else you need to know to analyze if there is a problem? If we know what information you need, we could consider to add more actions to make it more helpful.

Thanks,
Ke



------------------------------
KE CHEN
------------------------------

thanks for the update
but looking at knowledge center of Db2 : you see this element is not in use yet : so why displaying this ?

ESTIMATED_RUNTIME

BIGINT

Reserved for future use.

------------------------------
Thanks for all answers
Best Regards,
Guy Przytula
------------------------------

Original Message:
Sent: Tue March 31, 2020 08:20 AM
From: KE CHEN
Subject: monitor element

Hello Guy,

This is Ke from DMC development team. We appreciate your comments to make DMC better. I'm trying to answer your questions one by one.

• Estimated runtime is in the format of hours:minutes:seconds.milliseconds. I'll suggest the design team to add more description for this column.
• Package cache page is originated from table function mon_get_pkg_cache_stmt. It aims to display the executed SQLs on the monitored database. When you move the mouse on each row in the grid,  you will see an icon with three dots appears. It has several actions for this row. You can view more details via view detail button.

• Could you explain more about the commands you need to run manually? Anything else you need to know to analyze if there is a problem? If we know what information you need, we could consider to add more actions to make it more helpful.

Thanks,
Ke



------------------------------
KE CHEN
------------------------------

Hi Guy,

This column will be hided as default. But as you know, it will be used for Db2 new versions. So we will keep this column.

------------------------------
KE CHEN
------------------------------

Original Message:
Sent: Tue March 31, 2020 08:31 AM
From: Guy Przytula
Subject: monitor element

thanks for the update
but looking at knowledge center of Db2 : you see this element is not in use yet : so why displaying this ?

ESTIMATED_RUNTIME

BIGINT

Reserved for future use.

------------------------------
Thanks for all answers
Best Regards,
Guy Przytula
------------------------------


Original Message:
Sent: Tue March 31, 2020 08:20 AM
From: KE CHEN
Subject: monitor element

Hello Guy,

This is Ke from DMC development team. We appreciate your comments to make DMC better. I'm trying to answer your questions one by one.

• Estimated runtime is in the format of hours:minutes:seconds.milliseconds. I'll suggest the design team to add more description for this column.
• Package cache page is originated from table function mon_get_pkg_cache_stmt. It aims to display the executed SQLs on the monitored database. When you move the mouse on each row in the grid,  you will see an icon with three dots appears. It has several actions for this row. You can view more details via view detail button.

• Could you explain more about the commands you need to run manually? Anything else you need to know to analyze if there is a problem? If we know what information you need, we could consider to add more actions to make it more helpful.

Thanks,
Ke



------------------------------
KE CHEN

to answer part 2 :
when displaying the details : it would be nice to have - to highlight some values/ratios that should get a focus
eg. ratio between rows read/rows returned = high
cpu time - physical read instead of logical read
I know this is maybe an utopia - but that would enhance the product - you immediately know where is a potential bottleneck
maybe for verions 4 ?

------------------------------
Thanks for all answers
Best Regards,
Guy Przytula
------------------------------

Original Message:
Sent: Tue March 31, 2020 08:20 AM
From: KE CHEN
Subject: monitor element

Hello Guy,

This is Ke from DMC development team. We appreciate your comments to make DMC better. I'm trying to answer your questions one by one.

• Estimated runtime is in the format of hours:minutes:seconds.milliseconds. I'll suggest the design team to add more description for this column.
• Package cache page is originated from table function mon_get_pkg_cache_stmt. It aims to display the executed SQLs on the monitored database. When you move the mouse on each row in the grid,  you will see an icon with three dots appears. It has several actions for this row. You can view more details via view detail button.

• Could you explain more about the commands you need to run manually? Anything else you need to know to analyze if there is a problem? If we know what information you need, we could consider to add more actions to make it more helpful.

Thanks,
Ke



------------------------------
KE CHEN
------------------------------

Thank you for your suggestion. We will bring this request to group discussion. I think the hard part is how do we define 'high'.
Please be aware that a new function is added by group decision.  We can not promise the request can be fulfilled and when it can be delivered.

Thanks,
Ke

------------------------------
KE CHEN
------------------------------

Original Message:
Sent: Tue March 31, 2020 08:39 AM
From: Guy Przytula
Subject: monitor element

to answer part 2 :
when displaying the details : it would be nice to have - to highlight some values/ratios that should get a focus
eg. ratio between rows read/rows returned = high
cpu time - physical read instead of logical read
I know this is maybe an utopia - but that would enhance the product - you immediately know where is a potential bottleneck
maybe for verions 4 ?

------------------------------
Thanks for all answers
Best Regards,
Guy Przytula
------------------------------


Original Message:
Sent: Tue March 31, 2020 08:20 AM
From: KE CHEN
Subject: monitor element

Hello Guy,

This is Ke from DMC development team. We appreciate your comments to make DMC better. I'm trying to answer your questions one by one.

• Estimated runtime is in the format of hours:minutes:seconds.milliseconds. I'll suggest the design team to add more description for this column.
• Package cache page is originated from table function mon_get_pkg_cache_stmt. It aims to display the executed SQLs on the monitored database. When you move the mouse on each row in the grid,  you will see an icon with three dots appears. It has several actions for this row. You can view more details via view detail button.

• Could you explain more about the commands you need to run manually? Anything else you need to know to analyze if there is a problem? If we know what information you need, we could consider to add more actions to make it more helpful.

Thanks,
Ke



------------------------------
KE CHEN

when displaying details about statements you could add next to a field something like in visual explain, three dots and when you place your cursor over it you see the details about it

------------------------------
Thanks for all answers
Best Regards,
Guy Przytula
------------------------------

Original Message:
Sent: Tue March 31, 2020 08:20 AM
From: KE CHEN
Subject: monitor element

Hello Guy,

This is Ke from DMC development team. We appreciate your comments to make DMC better. I'm trying to answer your questions one by one.

• Estimated runtime is in the format of hours:minutes:seconds.milliseconds. I'll suggest the design team to add more description for this column.
• Package cache page is originated from table function mon_get_pkg_cache_stmt. It aims to display the executed SQLs on the monitored database. When you move the mouse on each row in the grid,  you will see an icon with three dots appears. It has several actions for this row. You can view more details via view detail button.

• Could you explain more about the commands you need to run manually? Anything else you need to know to analyze if there is a problem? If we know what information you need, we could consider to add more actions to make it more helpful.

Thanks,
Ke



------------------------------
KE CHEN
------------------------------

Guy, do you mean to use a hover window to display the detail information? The problem is that the detail has a lot information to display. In that case, a hover window may be busy.

------------------------------
KE CHEN
------------------------------

Original Message:
Sent: Tue March 31, 2020 08:45 AM
From: Guy Przytula
Subject: monitor element

when displaying details about statements you could add next to a field something like in visual explain, three dots and when you place your cursor over it you see the details about it

------------------------------
Thanks for all answers
Best Regards,
Guy Przytula
------------------------------


Original Message:
Sent: Tue March 31, 2020 08:20 AM
From: KE CHEN
Subject: monitor element

Hello Guy,

This is Ke from DMC development team. We appreciate your comments to make DMC better. I'm trying to answer your questions one by one.

• Estimated runtime is in the format of hours:minutes:seconds.milliseconds. I'll suggest the design team to add more description for this column.
• Package cache page is originated from table function mon_get_pkg_cache_stmt. It aims to display the executed SQLs on the monitored database. When you move the mouse on each row in the grid,  you will see an icon with three dots appears. It has several actions for this row. You can view more details via view detail button.

• Could you explain more about the commands you need to run manually? Anything else you need to know to analyze if there is a problem? If we know what information you need, we could consider to add more actions to make it more helpful.

Thanks,
Ke



------------------------------
KE CHEN