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 (

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 ( - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal ( - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM. - 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

Status Not under consideration
Workspace Db2
Created by Guest
Created on Feb 21, 2020

db2look with -printdbcfg must support parameters with "automatic" value

To clone a database and all its objects IBM recommend to use the db2look utility. If you use the -printdbcfg to clone the db  configuration too the db2look utility generate the parameter values in the update commands but without the "automatic" value.


If you have the db heap parameter for example set like this


 (DBHEAP)             = AUTOMATIC(3370)


the db2look generates a command like "update db cfg for xxx using dbheap 3370" which leads to


 (DBHEAP)             = 3370


and that is not the same as above !


If you look for the db2look-syntax in the knowledge center you find the remark "For the parameters that support the AUTOMATIC value, you might need to add AUTOMATIC at the end of the generated UPDATE DB CFG command."


That is not practicable. After each clone process you have to manually compare the db cfg and replay the automatic flag.


db2look must clone the automatic flag too !

  • Guest
    Feb 23, 2020

    I use súper compare with the output for get de cfg, and ✌🏼