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


ADD A NEW IDEA

Search results: Db2 Utilities Suite for z/OS

Showing 20 of 1578

Ability to externalize Statistics to RTS after Runstats

In seldom cases (~1%) Online Reorgs abend because the TOTALROWS column in the SYSTABLESPACESTATS are wrong. Then we do Runstats and update the RTS. The question is, why the number of rows is not externalized after doing a RUNSTATS. The value after...
about 4 years ago in Db2 Utilities Suite for z/OS 2 Future consideration

Improving CHECK utility performance: elapsed time and CPU

On our site, we have a PBG tablespace that, after loading, has the last partition in CHECK PENDING, the other partitions in RW. The IBM CHECK utility has taken a long time to complete the verification. We tried using the SCOPE PENDING parameter, b...
almost 2 years ago in Db2 Utilities Suite for z/OS 1 Future consideration

Add "EXCEPTION" parameter to CHECK INDEX to discontinue processing after N disrepancies

Sometimes when you run CHECK INDEX you encounter a huge number of discrepancies so much so that the utility keeps running and running and producing an excessive amount of output -messages regarding the details of the discrepancies. In some cases y...
about 2 years ago in Db2 Utilities Suite for z/OS 0 Future consideration

Allow LISTDEF to be used by REPAIR where appropriate at partition level that includes a range (1:50)

Allow LISTDEF with REPAIR, such as turning off AREO* (NOAREORPENDSTAR) at partition level. This would include a from partlevel to to partlevel. This would reduce the number of REPAIRs that need to be generated.
over 3 years ago in Db2 Utilities Suite for z/OS 1 Not under consideration

Modify the message when Load utility encounter table not found.

Sometimes we unload many tables from source DB2 to another one. If some tables do not exist in the target DB2, the load utility will fail with RC=8. this error message is mixed with ordinary information and ends with "I" in a big jobout file. For ...
almost 4 years ago in Db2 Utilities Suite for z/OS 0 Future consideration

LOAD DATE_P expects Julian date to be 5-byte DDDYY external format; Allow for packed data input (3-byte) with the P3 designation

No description provided
almost 6 years ago in Db2 Utilities Suite for z/OS 1 Delivered

Reorg Index functionality should allow parallel partition processing of a multi-part selection as per Reorg Tablespace.

It is best practice to minimise the exposure of mission critical application workload to the impact of reorg drain activity. It is best practice to minimise the cpu, i/o and elapse time of database maintenance activity which is often restricted to...
about 2 years ago in Db2 Utilities Suite for z/OS 1 Not under consideration

Enhance CHECK DATA utility: 1) to avoid SCANTAB and SORT when “SINGLE PARTITION IS SPECIFIED”; 2) to add PART range and parallelism option.

Currently Db2 does not provide either a parallelism option or PART range option for running CHECK DATA utility. Instead, as of Db2 V12, only ‘PART integer’ option is provided that repeating TABLESPACE database-name.table-space-name PART integer st...
over 2 years ago in Db2 Utilities Suite for z/OS 0 Future consideration

Check Index and Rebuild Index Combined in one Process

If a corrupt index is suspected then usual process is to 1. Run a Check Index 2. If an error is reported Run a Rebuild Index to fix the error. However part of the processing done by the Check Index could be utilized by the Rebuild Index. The Check...
almost 3 years ago in Db2 Utilities Suite for z/OS 0 Not under consideration

IBM Unload doesn't support parameter AT LOCAL for UTC Timestamp columns

In a SELECT statement the parameter AT LOCAL is supported, for example: SELECTDCOLLID ,-- =' ' --CHAR(18)DNAME ,-- =' ' --CHAR(8)TIMESTMP ,-- =' '--TIMESTMPKOMMENTAR -- =' '--CHAR(50)FROM DB2YD0XD.YD01TQR0WHERE TIMESTMP AT LOCAL < '2019-09-26-0...
over 5 years ago in Db2 Utilities Suite for z/OS 0 Not under consideration