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.
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
See this idea on ideas.ibm.com
Structured Idea Details:
Use a real-life scenario to explain the problem statement/pain points,
IIAS appliance displays alerts in its console via monitoring which is under the covers done by DSM components.
DSM monitoring displaying an alert on a SQL which is truncated to 131 bytes. We found the issue on IIAS(IBM Integrated Analytics System) appliance.
Customer PMR Issue was investigated engaged via IIAS support/DSM support(Case# TS001873538).
On investigation it was referenced via DSM support/development team
Currently, DSM does not have an API to provide full SQL text for DB_NEEDS_ATTENTION alert. Open RFE.
Output is displayed as
dsm_property_IBMOTS_STMT_SHORT: SELECT NAME, IDENTITY, GENERATED, HIDDEN, PARTKEYSEQ FROM SYSIBM.SYSCOLUMNS A, TABLE(SYSPROC.BASE_TABLE(CAST (? AS VARCHAR(10)),...
The above Select statement of 131 bytes is displayed.
State your current workaround(s)
Workaround is by selecting from the system catalog table where the complete SQL is stored in the IBMOTS.SQL_DIM in the column SQL_TEXT
Output is displayed as
dsm_property_IBMOTS_STMT_SHORT: SELECT NAME, IDENTITY, GENERATED, HIDDEN, PARTKEYSEQ FROM SYSIBM.SYSCOLUMNS A, TABLE(SYSPROC.BASE_TABLE(CAST (? AS VARCHAR(10)),...
The above Select statement of 131 bytes is displayed.
db2 describe table IBMOTS.SQL_DIM
Data type Column
Column name schema Data type name Length Scale Nulls
------------------------------- --------- ------------------- ---------- ----- ------
SQL_HASH_ID SYSIBM BIGINT 8 0 No
SQL_TEXT SYSIBM CLOB 2097152 0 Yes
2 record(s) selected.
--
db2 "select SQL_TEXT from IBMOTS.SQL_DIM" displays the SQL but it displays all the SQL statements where user can parse by a string.
State any proposed solution(s):
Since the SQL is stored in a system catalog table IBMOTS.SQL_DIM and in a column type CLOB name SQL_TEXT. DSM to have a an API to run the SQL
to full the complete SQL.
State the benefits/value this idea has
- Ability to display the full SQL gives the user access to full SQL and identify what SQL he needs to look at.
Truncated SQL statement poses a challenge to identify SQL in question.
state # of users impacted and how often are they impacted
- All user using IIAS Appliance and DSM. Any SQL larger than 131 bytes is not trucated.
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.