Monitoring

Showing 76

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

about 6 years ago in Db2 / Monitoring 0 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...

almost 10 years ago in Db2 / Monitoring / Security 1 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?

about 5 years ago in Db2 / Monitoring 2 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 5 years ago in Db2 / Monitoring 0 Not under consideration

11 VOTE

Index reorg information in a SNAP* view or a MON_GET* table function

Please make index reorganization progress (not table reorganization) accessible via a MON_GET* table function. Right now, it is only available via db2pd -d dbname -reorg -indexes and that is nearly impossible to parse via script.

over 9 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...

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

4 VOTE

Protect against DOS when user has password expired

Hi team, recently we had open a support case TS004670019 on https://www.ibm.com/mysupport/s/case/5003p00002TrWNRAA3/1222wd-db2-taking-too-long-to-login We had a situation with an automatic process that got it's password expired and begun failing t...

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

3 VOTE

Suitable Replacement for SNAP_GET_APPL_V95

SNAP_GET_APPL_V95 got introduced with Db2 9.5 but is deprecated in actual versions/releases. MON_GET_CONNECTION is declared as the replacement for this ‘old’ procedure, but the scope of the replacement procedure is different! Thus MON_GET_CONNECTI...

almost 3 years ago in Db2 / Monitoring 1 Future consideration

6 VOTE

DSMTOP should use the same color schema as DB2TOP

DSMTOP should use the same color schema as DB2TOP. Currently, DSMTOP uses a grey background which makes viewing of the metrics difficult.

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

4 VOTE

Monitoring table function to display details on the application and its temp space usage

Often times, users would like to get a single view report on the application handles/ids, the corresponding process id and application usage of sys or user temp spaces and db2 does not have one monitoring table function to accomplish this. Users n...

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

Please enter your email address

FILTER BY CATEGORY