Monitoring

Showing 52

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 S...

almost 4 years ago in Db2 / Monitoring / Tables/Index (Range MQ MDC etc.) 2 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...

over 1 year ago in Db2 / Monitoring 1 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...

almost 6 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...

almost 4 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 4 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...

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

8 VOTE

db2pd -dump enhancement

Hello, Sometimes there is hung situation when we run db2pd -dump . Is that possible to enhance the db2pd -dump to throw the error messages instead of causing Db2 hung situation?

over 3 years ago in Db2 / Monitoring 2 Not under consideration

18 VOTE

implicit GRANT EXECUTE to SYSMON authority for all monitor routines(RIMS)

Customer has to grant the EXECUTE privilege on the monitoring functions to a user who already has the SYSMON authority. They would expect that a user of the SYSMON_GROUP holds this privilege implicitly. This looks like a restriction to the monitor...

about 8 years ago in Db2 / Monitoring / Security 1 Not under consideration

7 VOTE

STATUS_CHANGE_TIME Colum doesnt exist in in mon_get views

We are currently working to migrate all our SNAP views to MON_GET views/Functions as SNAP views caused a response spike in our PROD environment recently.We are using STATUS_CHANGE_TIME columns of sysibmadm.applications to check lock waits on the d...

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

7 VOTE

DBA needs control over Jobs from Automatic Maintenance

This is the follow-up to the other RFE we submitted last year #108059. We are currently in the process of upgrading our databases to V11.1. As part of our pre-check process we have contacted SAP to understand the problem described in RFE#108059 is...

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

Please enter your email address

FILTER BY CATEGORY