IBM Data Platform Ideas Portal for Customers


This portal is to open public enhancement requests against products and services offered by the IBM Data Platform 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



ADD A NEW IDEA

Search results: Db2 for z/OS

Showing 129 of 1690

Achieve less than 10 seconds site switch by coordinated interactions between DB2 and QREP

To achieve less than 10 seconds site switch by coordinated interactions between DB2 and QREP Description: Only need to issue one command, then finish all following operations: 1. Turn on SOFTFENCE for entire database (can be at DB Level), protecti...
almost 7 years ago in Db2 for z/OS 0 Not under consideration

DB2 MQ Listener - Reconnect and resume processing after DB2/WLM outage

System: DB2 MQ ListenerActor: Business User needing new feature DB2 MQ Listener is used for integration of consumer/investment banking product offerings, improving customer experience. Description: We encounter service interruptions with the Liste...
over 9 years ago in Db2 for z/OS 1 Delivered

"INDEX ONLY" index scan should be used instead of tablespace scan when it performs better.

We were analyzing the optimization of the following query: SELECT MAX(A.COL1) FROM MY_TABLE A WHERE A.COL2= ? WITH UR ; There is an index that exists for MY_TABLE that has a first column of COL1 and a second column of COL2. DB2 was using a tablesp...
over 9 years ago in Db2 for z/OS 1 Not under consideration

Externalize performance t...

I have a performance trace running requesting IFCIDS 58 (END), 59 (FETCH), 65(OPEN), 66(CLOSE). I run the following Cobol program: ID DIVISION. PROGRAM-ID. C011MAIN. ENVIRONMENT DIVISION. DATA DIVISION. WORKING-STORAGE SECTION. 77 FILLER PIC X(12)...
over 9 years ago in Db2 for z/OS 1 Not under consideration

Concatenation of Timestamps not possible in DB2 for z/OS

This SQL runs in DB2 LUW but not in DB2 z/OS: WITH CTEREVUR AS( SELECT OID, CREATEDBY, CREATEDAT, NAME, VALIDTO, VALIDFROM, UPDATEACTION, REPLACEDAT, TIMESTAMP_FORMAT(VALIDFROM, 'YYYY-MM-DD') || TIMESTAMP_FORMAT(VALIDTO, 'YYYY-MM-DD') AS COMBINE F...
over 10 years ago in Db2 for z/OS 1 Not under consideration

Currently Committed for UPDATE

In DB2 10 for z/OS a new feature allowing currently committed data was deployed, enabling an application reading data to have the option of viewing previously committed work. This allowed for greater application concurrency, comparability with Ora...
over 11 years ago in Db2 for z/OS 0 Not under consideration

SQL Pruning for 0 > 1

The following SQL will not do a GETPAGE on 'table1' because the DB2 Optimizer recognizes that the predicate 'WHERE 0 = 1' has an empty result set: Select * from table1 where 0 = 1 The same is true if a date is used.:Select * from table1 where '201...
over 11 years ago in Db2 for z/OS 1 Not under consideration

Allow Additional Predicate Consideration to a Spatial Search for Enhanced Selectivity and Performance

Add support to the spatial index definition/management logic to allow the definition of the ST_POINT spatial index in conjunction with other columns. This very common compound index approach would enhance performance by cutting down on GETPAGES at...
about 13 years ago in Db2 for z/OS 1 Not under consideration

Monitor the index clean up process without starting a trace.

I would like to be able to monitor the DB2 for z/OS index cleanup process without starting a DB2 trace. Please could you do one or all of the following: 1. Create a DB2 command, -DISPLAY INDEXCLEANUP, to externalize the same information that IF...
over 3 years ago in Db2 for z/OS 0 Not under consideration

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.