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

Utilities (Export Import Load db2look etc)

Showing 17

Allow inplace reorgs cleanup overflows on partitioned tables with global indexes

We are seeing more OLTP customers moving from Db2 z/OS who require the ability to cleanup overflows through reorg on their partitioned tables which have been defined with global indexes.
6 months ago in Db2 / Utilities (Export Import Load db2look etc) 0 Future consideration
134 VOTE

export data from tables out of a backup image

Introduce a new parameter to the export utility to be able to export data from a table that is in a backup image.This functionality is especially useful for data extraction without touching/impacting the source system
almost 8 years ago in Db2 / Backup/Restore/ Rollforward/ Recover / Utilities (Export Import Load db2look etc) 2 Future consideration
122 VOTE

Support of RUNSTATS of range-partitioned tables on single partition

RUNSTATS on range-partitioned tables always runs on allpartitions. If all indexes are partitioned, a RUNSTATS of a singlePartition would be helpful.
almost 10 years ago in Db2 / Utilities (Export Import Load db2look etc) 0 Future consideration

Enable classic reorg with "allow write access"

Many customers want to REORG their tables quickly and efficiently. The classic REORG is by far the fastest option but puts the table in read only mode. Inplace reorg allows write access but is much slower and not suitable for tables that have a hi...
almost 8 years ago in Db2 / Utilities (Export Import Load db2look etc) 3 Future consideration

ADMIN_MOVE_TABLES needs to support INDEXES on EXPRESSION

ADMIN_MOVE_TABLE (AMT) procedure fails in SWAP phase, if the table to be moved has an expression based index defined. This issue has been lifted partially, as the RENAME of the table is now supported with INDEX on EXPRESSION (IoE). But in our case...
almost 2 years ago in Db2 / Utilities (Export Import Load db2look etc) 3 Future consideration

Performance enhancement for admintabinfo

For example, the customer wants to get the name list for tables which are in load pending status, he may issue a SQL statement "select tabschema,tabname from sysibmadm.admintabinfo where load_status='PENDING'", the statement will execute for a ver...
almost 9 years ago in Db2 / Utilities (Export Import Load db2look etc) 2 Future consideration

Allow REORG INPLACE and modify REORG RECLAIM EXTENTS on ITC tables

Beginning Db2 v10.5, REORG RECLAIM EXTENTS on ITC tables also implicitly performs sparse extent consolidation before freeing empty extents ( https://www.ibm.com/docs/en/db2/10.5?topic=enhancements-reorganization-make-table-maintenance-easier ). Ho...
about 1 year ago in Db2 / Utilities (Export Import Load db2look etc) 0 Future consideration

Reorg blocking applications when using "allow write access"

While an "allow write acces" online reorg is running lock-wait contention can happen based on the number of rows being updated by an application. The locks for the application can escalate to lock an x lock. If this situation happens, the reorg sh...
over 2 years ago in Db2 / Utilities (Export Import Load db2look etc) 0 Future consideration

externalize generic runstats information for XML columns in SYSCAT.COLUMNS

Currently RUNSTATS does not store generic statistical results for XML columns in SYSCAT.COLUMNS - as it does for other data types -, like numnulls etc.This information in SYSCAT.COLUMNS is used for administrative, automated tasks worldwide, but ca...
almost 2 years ago in Db2 / Utilities (Export Import Load db2look etc) 2 Future consideration

Create a "RUNSTATS Check" report similar to the REORGCHK

Although there is an Automated RUNSTATS, some people prefer to execute RUNSTATS manually. Having some ability to run a report that "Recommends" that a table should have a RUNSTATS performed would assist in making decisions. with thousands of table...
over 1 year ago in Db2 / Utilities (Export Import Load db2look etc) 0 Future 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.