Monitoring

Showing 61

Getting the Accessplans at the Routine level for the Database LUW

Db2 performance issues in one of the major area to look for, Whenever there is performance issue in the database, one of the major point we look is for the queries how they are behaving in the database. Db2 LUW provides lot of options to get the a...

about 5 years ago in Db2 / Monitoring 29 Not under consideration

26 VOTE

dmctop for zLinux

We have several Db2 LUW running on zLinux. Because dmctop is not compatible with zLinux, we're still using db2top but would like to explore new functionalities/features offered in dmctop. Just to clarify: Currently, dmctop does not work on zLinux ...

about 2 years ago in Db2 / Monitoring 7 Not under consideration

28 VOTE

Warning error code for Db2 tablespace architecture limit

If Db2 tablespace reaches architecture limit of 90%, then there should be a Warning Message write into db2diag.log, so that before it is reaching 100% of Db2 tablespace architecture limit, this can be fixed. Now we are monitoring through a SQL...

over 5 years ago in Db2 / Monitoring / Tables/Index (Range MQ MDC etc.) 2 Not under consideration

6 VOTE

Logical Files in QPFRDATA should be secured with AUTL QPMCCDATA

Hi, on IBMi Collection services you have several file in QPFRDATA. Mostly all PF are secured with the AUTL QPMCCDATA. There are also some LF like: QAPMJOBL, QAPMSYSL, and QAPMPOOLL which are secured by AUTL: *NONE. Normally we add our user to the ...

over 1 year ago in Db2 / Monitoring 0 Not under consideration

31 VOTE

Add session-level reset for monitoring metrics in the MON_GET* table functions

There is no way to reset the metrics reported in the MON_GET* table functions. Please add functionality for resetting these at the session level, much like "RESET MONITOR" does for snapshot monitoring. Yes, there are a dozen ways to code this your...

over 7 years ago in Db2 / Monitoring 1 Not under consideration

7 VOTE

MON_GET_CONNECTION missing the application idle time

MON_GET_CONNECTION table function is documented to be the replacement of deprecated snapshot function SNAPAPPL, but it misses a key value, which is supplied by the old (deprecated) function. SNAPAPPL delivers the application idle time (APPL_IDLE_T...

almost 2 years ago in Db2 / Monitoring 1 Not under consideration

8 VOTE

An analog of LOG_HADR_WAIT_TIME monitor element is needed at the agent level

Sometimes it's very useful to understand HADR influence on the transaction performance. We do have a couple of related elements - LOG_WRITE_TIME and LOG_HADR_WAIT_TIME at the whole database level, but their values can't help us to understand, if H...

almost 3 years ago in Db2 / Monitoring 1 Not under consideration

14 VOTE

Application status change time is not available in any mon_get_* table functions

In snap admin views, users could see STATUS_CHANGE_TIME column for the application which was helpful in determining when exactly the application changed it status when investigating performance issues. This would help users to estimate or know how...

over 5 years ago in Db2 / Monitoring 1 Not under consideration

15 VOTE

MON_GET_CONNECTION is lacking CODEPAGE of connection

A 3rd party application connects to Db2 and we get SQL0302. The 3rd party vendor figures out, it is a double conversion to UTF-8One of the most valuable debugging informations was the codepage of the connection to the database, which is available ...

over 6 years ago in Db2 / Monitoring 0 Not under consideration

12 VOTE

Provide better hang information

In the case of a hang, we only have the material for root-cause analysis if we were able to collect db2fodc information before the system became fully unusable. A small moving window of such information written out to disk on a regular basis would...

almost 6 years ago in Db2 / Monitoring 0 Not under consideration

Please enter your email address

FILTER BY CATEGORY