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

Utilities (Export Import Load db2look etc)

Showing 141

EXPORT to local (not server) using the ADMIN_CMD

The export calle from admin_cmd can only export to the server. There should be a way to export in the client when called the SP,
over 4 years ago in Db2 / Utilities (Export Import Load db2look etc) 0 Not under consideration

Add the new IF EXIST functionality to db2look

The new syntax IF EXISTS for CREATE and DROP TABLES (see https://ibm-data-and-ai.ideas.aha.io/ideas/DB24LUW-I-259) should also be generated by db2look on demand. This would help and simplify migration scenarios with db2look. This should also be a...
over 4 years ago in Db2 / Utilities (Export Import Load db2look etc) 0 Not under consideration

Export should have nocoldel or coldelx20

Db2 should allow an export without characters for columns not characters, or space as column delimiter. Something like: export to myfile.csv of del modified by nochardel nocoldel select * from mytable There is something to change the col...
over 4 years ago in Db2 / Utilities (Export Import Load db2look etc) 0 Not under consideration

Detect corrupted synopsis tables online

There is a need to report all corrupted synopsis tables online. Currently, db2dart /crs can do it per table and it's done offline.
over 4 years ago in Db2 / BLU Acceleration / Tables/Index (Range MQ MDC etc.) / Utilities (Export Import Load db2look etc) 0 Not under consideration

Multiple index creation in parallel in the AMT

AMT procedure is used for online reorg. At index build phase, parallel multiple index creation is needed for faster completion of job.
over 4 years ago in Db2 / Utilities (Export Import Load db2look etc) 0 Not under consideration

db2expln output with XML format.

The db2expln utility provides a plain text file only. Sometimes, OPTPROFILE can be added to tune some terrible SQL. The OPTPROFILE is XML format, but many users is not used to it. If XML format is supported as an option of db2expln then it would ...
over 4 years ago in Db2 / Utilities (Export Import Load db2look etc) 0 Not under consideration

Make Export add a column header row to output

Export is often used to download data from a Db2 Server to a user's workstation where they then look at it in excel.
almost 5 years ago in Db2 / Utilities (Export Import Load db2look etc) 2 Not under consideration

Allow public alias in export/import command

Db2 11.1 says that Public aliases can be used only in SQL statements and with the LOAD utility. (https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.sql.ref.doc/doc/r0000910.html) Please support export and import utiliti...
almost 5 years ago in Db2 / Utilities (Export Import Load db2look etc) 0 Not under consideration

db2caem should support 'SET CURRENT QUERY OPTIMIZATION = N'

For diagnostic of Db2 performance problems the tool db2caem can be very helpful. Especially if a particular query plan should be compared using different optimization levels. Using db2caem the optimization level must be specified by embedded opti...
almost 5 years ago in Db2 / Utilities (Export Import Load db2look etc) 1 Not under consideration

Provide a documented and supported procedure to generate ddl (db2look as SP - like db2lk_generate_ddl)

db2lk_generate_ddl is a stored procedure that provides functionality to generate DDL via SQL (similar to db2look which is a tool as db2llok cannot be executed througha SQL client tool. This function already exists but is not documented and I am no...
almost 5 years ago in Db2 / Utilities (Export Import Load db2look etc) 2 Not under consideration