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 67
18 MERGED

EXPLAIN(ONLY) should create no locks

Merged
We did an rebind packages with EXPLAIN(ONLY) with an owner change and got into problems because rebind phase-in was not used. So there were a lot of locks which caused timeouts. The owner change for EXPLAIN(ONLY) is needed for a vendor tool. We th...
over 1 year ago in Db2 for z/OS 1 Delivered

Instrument workfile high-watermarks in ACCTG

This would be useful to all business users that seek to tune their installation for best performance; specifically in the area of MAXTEMPS. Instrument IFCID 0003 and IFCID 0148 counter(s) to show the maximum amount of Workfile used by a thread (4K...
almost 2 years ago in Db2 for z/OS 1 Delivered

Full EXPLAIN support for all types of trigger

With Triggers you cannot use the REBIND option OWNER on a rebind. Why not? Not even for EXPLAIN(ONLY). We must get the ability, like with "normal" packages, to EXPLAIN into another set of EXPLAIN tables. Further, if you are using Advanced Triggers...
over 3 years ago in Db2 for z/OS 7 Delivered

NEW SCALAR function for DB2 SQL – HEX2BIGINT

NEW SCALAR function for DB2 SQL – HEX2BIGINT I would like to see IBM provide a specific function for converting a HEX to BIGINT. I think this would be useful for many/most/all users of Db2! Why? The IBM LOAD utility will report that when input dat...
over 2 years ago in Db2 for z/OS 2 Delivered

Provide a ZPARM to prevent creating new non UTS-tablespaces

I have converted all single table tablespaces to UTS, but some days later new non UTS-tablespaces were created, which I again converted. And again new ones were created, so this process could go for ever.
over 8 years ago in Db2 for z/OS 1 Delivered

UTS PBG, SINGLETON SELECT and Lock Avoidance.

Hello Db2 for Z/OS Development. Apar PM89016 was created several years ago to implement the lock avoidance for singleton SELECTs with ISO(CS) and CD(YES) when R-scan is used, or the index that is chosen has matching predicates on all columns of th...
almost 5 years ago in Db2 for z/OS 2 Delivered

Migration of multi-table tablespaces to UTS PBG

Difficulties to migrate from old tablespace types to UTS.DB2 V10 gives us the opportunity to use the ALTER-syntax to change tablespace type from SIMPLE or SEGMENTED to UTS PBG without (almost) any outage. Unfortunately there is a limitation which ...
over 13 years ago in Db2 for z/OS 0 Delivered

Profile Table Enhancement for local applications

Profile Tables today support only remote connections and no support for local/batch applications. When PT is used to set certain registers, it only works for remote applications and local apps needs to be changed to add certain SET commands.
about 5 years ago in Db2 for z/OS 0 Delivered

DECFLOAT support for COBOL and PLI with DCLGEN

When we run DCLGEN on an object with a DECFLOAT column, we get the following error: DSNE958I DCLGEN DOES NOT SUPPORT THE SQL DATA TYPE DECFLOAT (SQLTYPE 996) FOR THE PLI LANGUAGE DSNE905I EXECUTION COMPLETE, MEMBER ... ADDED The created DECLARE an...
over 3 years ago in Db2 for z/OS 2 Delivered

TRIGGERS referencing system temporal tables

Hello, Since we are in DB2 V10 we use triggers with bi-temporal tables (system temporal + business temporal table) to implement complex relational integrity rules that can not be defined using standard primary/foreign keys. It's related to simple ...
over 7 years ago in Db2 for z/OS 1 Delivered