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 updateson 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
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
Do not place IBM confidential, company confidential, or personal information into any field.