IBM Data and AI Ideas Portal for Customers

Shape the future of IBM!

We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:

Post your ideas

Post ideas and requests to enhance a product or service. Take a look at ideas others have posted and upvote them if they matter to you,

  1. Post an idea

  2. Upvote ideas that matter most to you

  3. Get feedback from the IBM team to refine your idea

Help IBM prioritize your ideas and requests

The IBM team may need your help to refine the ideas so they may ask for more information or feedback. The product management team will then decide if they can begin working on your idea. If they can start during the next development cycle, they will put the idea on the priority list. Each team at IBM works on a different schedule, where some ideas can be implemented right away, others may be placed on a different schedule.

Receive notification on the decision

Some ideas can be implemented at IBM, while others may not fit within the development plans for the product. In either case, the team will let you know as soon as possible. In some cases, we may be able to find alternatives for ideas which cannot be implemented in a reasonable time.

Additional Information

To view our roadmaps:

Reminder: This is not the place to submit defects or support needs, please use normal support channel for these cases

IBM Employees:

The correct URL for entering your ideas is:

Status Future consideration
Workspace Db2
Components Monitoring
Created by Guest
Created on Dec 2, 2021

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_CONNECTION needs to be enhanced to optionally provide the same scope of connection information as SNAP_GET_APPL_V95 does!

SNAP_GET_APPL_V95 provides connection information for the whole instance, when called at any database currently connected by the user within that instance,

while MON_GET_CONNECTION provides that connection information for the currently connected database only.

MON_GET_CONNECTION has to be enhanced with a parameter that allows to specify the scope of output when calling the procedure, that the option to get the connection information for the whole instance is still provided.

Without that option, MON_GET_CONNECTION is NOT a valid replacement of SNAP_GET_APPL_V95, and thus this old procedure should NOT get discontinued before MON_GET_CONNECTION gets this specific enhancement.

We addressed the lack of functionality, and that MON_GET_CONNECTION is NOT the valid replacement for SNAP_GET_APPL_V95, via case already, but this was claimed to be a design issue, although the documentation is NOT correct at that point, claiming MON_GET_CONNECTION to be the replacement of SNAP_GET_APPL_V95!

Business Justification:

Currently SNAP_GET_APPL_V95 is used by our automation software to obtain the connection information for the whole instance AND per database with a single request to one database within that instance, in an environment with several hundred instances and several thousand databases.
We have several application databases per instance and there’s always one systems management database defined, which is used for that data collection purpose.
If this enhancement request is not fulfilled, we would have to rewrite that data collection to connect to every single database within that instance to obtain the same level of information!
Besides the enormous effort for re-programming, this would cause add systems management request to application databases, which are not needed.

As the connection information has to be obtained by MON_GET_CONNECTION from the instance level anyhow and has to be filtered for the currently connected database, so why not providing the whole data on request?

Needed By Not sure -- Just thought it was cool
  • Guest
    Dec 9, 2021

    I think that enhancement is needed exactly when SNAP_GET_APPL_V95 gets discontinued!