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 Not under consideration
Workspace Db2 for z/OS
Created by Guest
Created on Feb 15, 2019

Enable DSM to display the full SQL from monitoring instead of truncated SQL

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.