Skip to Main Content
IBM Data and AI Ideas Portal for Customers
Hide about this portal


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


ADD A NEW IDEA

Search results: Db2 for z/OS

Showing 123 of 1578

support list partitioning - Range-Partitioning allows only to define the upper limit for a partitioned Tablespace.

Full Support for LIST-Partitioning required! With classical Partitioning or UTS Partion-by-Range you can only define the upper limits (key-Ranges) for a partitioned Tablespace. The lower partition-range ist defined by the highest value of the next...
over 12 years ago in Db2 for z/OS 1 Not under consideration

Distributed Thread cancelled due to Idle Thread Timeout or MONITOR IDLE THREADS not writing record to SYS1.LOGREC

We noticed that every DB2 distributed thread that is cancelled because: 1) Idle thread timeout value that is specified by Db2 subsystem parameter IDTHTOIN in macro DSN6FAC is exceeded; or 2) ATTRIBUTE2 value in a row with KEYWORD value MO...
about 4 years ago in Db2 for z/OS 1 Not under consideration
3 MERGED

Set Special Registers with profile tables for local applications

It would be nice to set the current explain mode (special register) with the help of profile tables (dsn_profile_table & dsn_profile_attributes) for local applications. In our case it's CICS. At the moment it's only possible for remote applica...
over 1 year ago in Db2 for z/OS 4

improve documentation about CONDBAT (& MDBAT) and how to watch the limit being approached

The IBM provided documentation for important ZPARM of CONDBAT and MDBAT is a bit vague on exactly what to watch for these important limits. The documentation could be improved. I reviewed the documentation for DISPLAY DDF command https://www.ibm.c...
about 4 years ago in Db2 for z/OS 0 Planned for future release

Improving latch contention in Db2 z/OS

DB2 workloads run at a priority that is related to their origin (may it be batch, IMS, DDF, …) and according to WLM service class definitions. In high system utilization scenarios, or due to workloads running in a WLM service class with a resource...
about 4 years ago in Db2 for z/OS 1 Not under consideration

New Function UNHEX

New Function UNHEX (name subject to change/negotiation) We have a system where all CHAR columns are defined FOR BIT DATA. It seemed genius at the time to save a few bytes of data, not realizing the negative impact in future maintainability and in ...
7 months ago in Db2 for z/OS 3 Not under consideration

Rotate an archive-enabled PBR tablespace without causing a deadlock

When we try to rotate partitions of an archive-enabled PBR tablespace, Db2 requires us to disable archiving before the rotate then re-enable archiving after the rotate. However, when we re-enable archiving we cause a deadlock with CICS and the onl...
almost 3 years ago in Db2 for z/OS 0 Not under consideration

Option to dictate behaviour regarding deadlock victim selected on deadlocks involving DDL ALTERs

In true 24*7 production environments there is an increasing expectation that simple(on the face of it) DDL changes should be able to break-in concurrent with application workload. In the case of high-arrival rate transactions even at the quietest ...
over 4 years ago in Db2 for z/OS 1 Delivered

Meter "dirty" pages written to DB2 table spaces (disk) from CF or local buffer pools

DB2 uses 300 tasks (DB2 writers - it could be more now with later DB2 releases) to write modified (aka, "dirty") pages to the DB2 table spaces (either permanent tables or DB2 work files). From a DB2 perspective this is "efficient" but from a resou...
almost 2 years ago in Db2 for z/OS 4 Not under consideration

Add Bufferpool ID # to SMF 100/2 DNSDQDBP

Hello z/OS DB2, I am processing the SMF 100 subtype 1 and subtype 2 records and match upthe buffer pool data. In the SMF 100/1 DSNDQBST section, the buffer pools are identified by a buffer pool ID number. On the SMF 100/2 records, DNSDQDBP section...
over 6 years ago in Db2 for z/OS 3 Planned for future release