Skip to Main Content
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 295 of 5232

SQLCODE -180 (invalid date/time) - add identifier for hostvariable.

When it comes to SQLCODE -180 (invalid value for date/time/timestamp) due to wrong data in an input-hostvarible currently DB2 issues following SQLCODE: SELECT * FROM SYSIBM.SYSTABLES WHERE CREATEDTS = ? Hostvariable holds 'SCHUBIDU' DSNT408I SQLCO...
almost 8 years ago in Db2 for z/OS 0 Not under consideration

LOAD a TABLE with WHEN / DISCARD

When loading a table with WHEN and DISCARD, rows that do not qualify because of the WHEN condition get "discarded" and:- discard file is populated with them- it is impossible to distinguish records discarded because of the WHEN clause and e.g. the...
about 11 years ago in Db2 for z/OS 0 Delivered

Enable to check maximum LATCH retention time in DB2PE reports etc

[Current Product & Version]-Db2 12 for z/OS-IBM Tivoli OMEGAMON XE for DB2Performance Expert on z/OS v5.5-z/OS v2.3-WebSphere Application Server v9 for z/OS [Environment]Data sharing in three-way sysplex environment [Problem]Our customer is us...
about 2 years ago in Db2 for z/OS 2 Delivered

Allow SQL to reference a Temporal table and Transparent archiving table in the same statement

We have adopted widespread use of System Time functionality on our application tables. We have need to use transparent archiving as well, since we have table where data churn is significant and we don't have need to track row changes - just the fi...
over 5 years ago in Db2 for z/OS 0 Not under consideration

Simplify Alter

In Db2 z/OS version 10 Pending Alters/Deferred Alters were introduced. Deferred Alters are not compatible with most Immediate Alters. Deferred Alters need materializing REORG before immediate Alter, or the Immediate Alter has to be run before D...
over 5 years ago in Db2 for z/OS 0 Not under consideration

Add SCOPE(GROUP) to the Start/Stop Profile command

In our shop we have many Db2 data sharing members. If we need to stop and then start our profile tables we need to do so in many places. Adding the SCOPE(GROUP) to the both the start and the stop command would reduce the number of places and comma...
over 3 years ago in Db2 for z/OS 1 Not under consideration

Status change or pending DDL when adding a KEY LABEL to an existing table

When an existing table is altered to add a KEY LABEL to enable encryption on the table, the encryption only takes effect post a Reorg (effectively post a redefinition of the underlying VSAM datasets). So the alter is effectively incomplete until s...
about 1 year ago in Db2 for z/OS 0 Future consideration

SQL Data Insights - Using user-defined RACF group to associate SQL DI users instead of default group SQLDIGRP

During installation of SQL DI it is not possible to change the default group name SQLDIGRP. This group will be used, to associate SQL DI users and manage their access. But to fit in the specific conventions of RACF group names in a company, a diff...
over 1 year ago in Db2 for z/OS 1 Delivered

Allow column masking on system temporal tables

We have a few System Temporal tables that have sensitive data. We need to be able to create column masks on those columns. Currently we get a SQL20474N with Reason Code 17 when we try to run a CREATE MASK on system temporal tables.
almost 5 years ago in Db2 for z/OS 1 Not under consideration

Use CURRENT SCHEMA for EXPLAIN table SCHEMA

Currently the CURRENT SQLID is the only SCHEMA used by EXPLAIN processing. This is a real pain as changing the CURRENT SQLID is an auditable event. The use of SET CURRENT SCHEMA works for *all* other cases - Only EXPLAIN fails here. So the request...
over 6 years ago in Db2 for z/OS 0 Not under consideration