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 updateson 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,
Post an idea
Upvote ideas that matter most to you
Get feedback from the IBM team to refine your idea
Specific links you will want to bookmark for future use
Add Abbreviation for REFRESH command in Autonomics Concole
Please add "REF" as an abbreviation for the "REFRESH" command in the Autonomics Console within the Db2 Automation Tool, particularly on the HAA$ALR3 panel. This panel is used to display the autonomic actions within a maintenance window. It is very...
add part level to object profile and reorg profile discard screen
We run reorg discard utility monthly with our legacy job. We have large partition by range table spaces that have billions of rows and 100's of parts. Currently with the automation tool I need to edit the object profile for each table space to cha...
One of our customers working with REORG jobs built using Automation tool 4.3 have normally problems of "Sort Capacity exceeded". In order to solve this problem, our customer is using a customized skeleton HAAREORJ with syntaax: //DFSPARM DD * OPTI...
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 profi...
Ability to exclude packages from the rebind utility
Currently, rebind statements are generated based on what objects have been runstats'd -when included with a RUNSTATS utility profile- or everything -when only using the REBIND utility in the profile-. However, this also includes packages that are ...
HAA - when doing a Pending Data Change, such as DSSIZE, reorgs are generated at partition level instead of being escalated up to TS level
Changing the DSSIZE on a PBR. The entire TS must be reorged to apply the pending data change. I have coded the object set to accomplish this. The automation tool should have the intelligence to do this. I need also to do this for a DPSI index, cha...
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 DEFIN...
Add SORTDATA NO, RECLUSTER NO capability to generated reorgs for PDC PBR
PBRs having pending data change can be quite large resulting in a lot of temp storage needed for sorting data. Since the reorg is at TS level, this can be quite large for tables with huge CARDF. The following keywords should be able to be selected...
Detect like-named objects and convert to non-part objects on current SSID
Object Profile contained some like-named objects that were added to the profile when they were Partitioned and now they are no longer Partitioned. This would require us to update the Object Profile for those objects and resubmit the job.
Add Support for BLKSZLIM keyword of TEMPLATE utility
Using the Large Block Interface provided by z/OS, the performance of the Db2 COPY utility can be greatly improved when image copy data sets are created on tape. The Db2 Automation Tool does not currently allow the user to specify the BLKSZLIM keyw...
Do not place IBM confidential, company confidential, or personal information into any field.