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 Functionality already exists
Created by Guest
Created on Apr 4, 2023

Enable rebind of packages after a reorg in Automation Tool

I want to use Automation Tool to reorganise a tablespace to materialise a change to a UTS.

I will issue the ALTER TABLESPACE MAXPARTITIONS nnn statement during the working day, which will put the tablespace into the AREOR state.

I have a job profile in Automation Tool containing an exception profile using 'STATUS_AREOR' in 'Db2 Display Status Exception conditions'.

I want this job profile to run overnight during a quiet period. The job will run the reorg and the tablespace will be converted to a UTS.

The table in this tablespace has packages dependent on it. The packages will be invalidated when the alter is materialised.

I want to be able to follow up the reorg in Automation Tool with a rebind of the invalidated packages on that table.

Automation Tool doesn't currently allow packages to go through a rebind after a reorg in autonomics mode, even though it allows you to run a reorg that will invalidate packages.

Automation Tool should be enhanced to allow a user to run a reorg of a tablespace, followed by a rebind of dependent packages in the same job profile. This will save the user having to set up and schedule a separate rebind job. With a separate rebind job, it would be difficult to know when the reorg has finished, to then run the rebind job immediately afterwards.

This enhancement will benefit any users wanting to run a reorg in Automation Tool that invalidates packages. With the recommendation to move forward to UTS tablespaces, this enhancement will benefit that process by adding some automation to it.

Needed By Quarter
  • Admin
    Chris Pomasl
    Apr 26, 2023

    Development reports that this can already be done.

    In a single utility profile, the user can select both REORG TS and REBIND to be included in the same job.

    This will eliminate the contention issue

  • Guest
    Apr 6, 2023

    There can be a problem with this if multi reorg jobs are running and possibility invalidating the same package due to changing TS attributes. A rebind can be done in one job while another job is invalidating the package causing contention.