Skip to Main Content
IBM Data and AI Ideas Portal for Customers


This portal is to open public enhancement requests against products and services offered by the IBM Data & AI organization. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (https://ideas.ibm.com).


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:


Search existing ideas

Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updates on them if they matter to you. If you can't find what you are looking for,


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


Specific links you will want to bookmark for future use

Welcome to the IBM Ideas Portal (https://www.ibm.com/ideas) - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal (https://ideas.ibm.com) - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM.

ideasibm@us.ibm.com - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.

IBM Employees should enter Ideas at https://ideas.ibm.com


Status Functionality already exists
Workspace Db2
Created by Guest
Created on Nov 22, 2022

Monitor activities by the user

Regarding DMC capabilities, I would like to know if there is a possibility to monitor activities by the user. This is very important for our Db2 environment, whether qualified or unqualified table names are used (in case of unqualified names would these feature be even more important) .

If we have several applications running in the same database, monitoring their activities, e.g. CPU consumption / Response time etc. by the user would be of a great help.


Is it possible to include schema information in the user interface when monitoring individual activities?

Needed By Quarter
  • Admin
    VIJAYA KATIKIREDDY
    Reply
    |
    Jun 1, 2023

    Addiitonal comment from team:

    For the request "Is it possible to include schema information in the user interface when monitoring individual activities?" , individual activities are statements which don't have a schema. If I understand correctly, schema applies to objects like tables. Is this request to get schema for tables referred in each statement? If so, there isn't an out-of-box way to get schema/tables name from statement. We are exploaring a button to enable user to collect schema/tables name for selected statements. It will call explain in the background to get schema/tables name for the statements. Considering explain is expensive and sequential, we may not apply it for all but selected statements by users with a limitation of number.

  • Admin
    VIJAYA KATIKIREDDY
    Reply
    |
    Jun 1, 2023

    Comments from team:


    There are 2 ways to get the statements by a specific auth id in “individual executions” page.

    1. You can add a filter condition by clicking filter icon among the 4 icons at right of the page and then add conditions. You will get statements executed by a specific auth id and you can also export to a csv. Please refer to screenshot like this.



      2. You can click the “Session authorization ID” column then the statements will be sorted by selected column. In this way, you can also get statements sorted by auth id.







  • Guest
    Reply
    |
    Mar 1, 2023

    Is it possible to include schema information in the user interface when monitoring individual activities?