IBM Data and AI Ideas Portal for Customers

Hide about this portal

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,

Post an idea
Upvote ideas that matter most to you
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.

I BM 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

3 VOTE

Status Not under consideration

Workspace Informix

Components Informix Server

Created by Guest

Created on Jun 2, 2023

SQL Trace filtering

See this idea on ideas.ibm.com

SQLTrace enable the DBA to get the query plan of all the queries executed by a user (when mode=user) or by all users (when mode=global). Given that nowadays web applications and/or APIs use connection pooling, they submit a large number of queries in a short time. Most of these queries return immediately, however the one slow query is hidden amongst them. I had cases whereby 15k queries were executed in approximately 35 seconds. This makes identification of problematic queries (which is the main scope of SQLTRACE) cumbersome to use.

This RFE is about enhancing SQL Trace to make it more lightweight by tracing only queries whose running exceeds a pre-define parameter of SQLTRACE, for example mintime. This parameter defaults to 0, to keeping the existing behaviour consistent.

The side effects of this enhancement:

1. Improve resource usage as:

a) it will not generate the query plan, and insert the information of the query in the SQLTRACE buffer for all queries, just the once that match the criteria

b) reduce the bandwidth and housekeeping of the SQLTRACE buffer

2. The SQLTRACE buffer will contain of interest of the DBA, and reduce the chance of being overwritten by lots irrelevant queries

Needed By

Month

Post comment

By clicking the "Post Comment" or "Submit Idea" button, you are agreeing to the IBM Ideas Portal Terms of Use.
Do not place IBM confidential, company confidential, or personal information into any field.