Monitoring

Showing 75

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

1 VOTE

Include Prefetch wait time Metrics in monreport.dbsummary() stored procedure

Prefetch wait time numbers are a bit similar to FCM in the sense that they can be really high even in a normal system. Prefetch wait time doesn’t start until an agent attempts to read a page that has already been queued for prefetch – then the clo...

4 months ago in Db2 / Monitoring 0 Submitted

7 VOTE

As Db2 system / instance administrator, I need to retrieve instance data without connecting to a regular (tenant) database

Several of the in-memory monitoring table functions and views return data which is instance-related. Still, a database connection is needed just for the purpose of having authentication / authorization / connection handle. This requires administra...

over 2 years ago in Db2 / Monitoring 0 Future 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

6 VOTE

As Db2 system / instance administrator, I need to retrieve the list of active databases using SQL

Coming from snapshot monitoring, the goal is to use in-memory monitoring and SQL in the least intrusive way to monitor the health of a Db2 instance and its databases. Right now, this is done by connecting to a non-tenant dummy database and running...

over 2 years ago in Db2 / Monitoring 0 Future 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