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 Data & AI Roadmaps ( - Use this site to view roadmaps for Data & AI products.

IBM Employees should enter Ideas at

Status Functionality already exists
Created by Guest
Created on Mar 28, 2022

Flexibility of Using LISTDEF Options

Db2 Automation Tool allow users to generate utility control statements using LISTDEFS.

There are many options that can be used with LISTDEF utility however Db2 Automation Tool does not provide this flexibility.

For instance we need to use DEFINED ALL statement to include undefined objects in MODIFY STAT utility to cleanup the old entires.

The current Db2 Automation Tool configuration allows only generate default LISTDEF control statements in which DEFINED parameter is set to YES.

This configuration cause old stats for DEFINED NO objects to accumulate.

Please consider enchanching the LISTDEF options in Db2 Automation Tool and provide flexibility of using different options of the LISTDEF utility.

Needed By Yesterday (Let's go already!)
  • Guest
    Jun 28, 2022

    Thank you for submitting this enhancement request.

    LISTDEF DEFINED ALL is available via UI80739.

    Automation Tool supports LISTDEF Include, Exclude, Clone, RI, All (Auxiliary spaces), History, and Archive keywords via the object profile.

    Selecting the Exclude option in the object profile will prevent the object from being generated in the JCL vs actually displaying the EXCLUDE keyword.

    COPY Yes/No is available via Exception processing.

    LISTDEF options not currently supported via panel options in HAA:

    Basic and Extended.

    This can be done via advanced SQL in the object profile:

    To query objects with basic RBA values:


    To query objects with extended RBA values:

    Enter the same query as above for basic but change the TTYPE to = ‘E’ for extended.

    Please let us know if these options do not satisfy your request, or if we need to enhance our user guide and help text and we will revisit. You can also reach out to our support team if you need any assistance in setting up a customized job profile.