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
use IDAA Loader to create a backup of a very large un-partitioned AOT, alternately allow AOTs to be partitioned
We have a very large table of data which we would like to take off of DB2. We have created an AOT and loaded it from DB2, but we have not been able to create a backup of the AOT. Without a backup we can not remove the table from DB2. This was repo...
Currently, with IDAA Loader v2.1 it is not possible to LOAD data into target accelerator tables that are referenced via ALIAS names. It would be helpful and a great enhancement, e.g. for migration scenario to future IDAA versions, to reference the...
Enable/Disable replication (InSync) via IDAA HA Loader
If you enable an already loaded table, the following steps are carried out:
○ The data in the accelerator-shadow table is deleted.
○ The accelerator-shadow table is reset to the InitialLoadPending state.
○ Query acceleration is turned off f...
We have an IDAA loader job that disables the table prior to the load to IDAA. Upon successful load of # rows, Loader will end with RC = 0 and enable the table for acceleration again. If the same process is run multiple times and results in "no row...
We're using IDAA loader V 2.1 to run backups for very huge AOTs. When IDAA loader takes a backup from an IDAA AOT it uses SQL multirow fetch to transfer the data from IDAA into a z/OS sequential file. This may work fine for small AOTs. But in our ...
Today, HLOMAINT utility is not designed to find out what utilities are stuck or dead. To clean up those loader utilities, we run a SELECT * against HLOTB.HLOUSTAT table, review each utility, and run the HLOMAINT job to terminate the utilities one ...
Use separate HLQs for read-only and updateable product libraries in TCz
TCz should provide an option to allow a customer to specify different HLQs to separate read-only and updateable libraries during product customization. For security and auditing reasons, this separation is required.
Rollback changes to both accelerators if failure occurs loading multiple accels in one load statement
We have a situation where it is important to keep the data in synch on both accelerators, so we use one statement to load both accelerators. Real case: The data is loaded from OPERLOG logstream to shadow table every 15 minutes on two IDAA accelera...
IDAA LOADER job with RC=8 due to just one IDAA load fail
Some of our daily DB2 load Jobs are "DUAL MODE" (DB2 + 4 IDAAs) but we are having issues due to RC=8 when just one IDAA receives error . When the load is sucessful for DB2 and 3 IDAAs but abend for just one IDAA we want to receive at least RC=4 be...
missing parm for forceFullReload (or detectChanges="PARTITION") in IDAA loader
According to Stored Procedure Guide V7.1.7 :The forceFullReload attribute is deprecated because detectChanges="PARTITION" withoutpartition list has the same effect as forceFullReload="false", and omitting the detectChangesattribute and a partition...
Do not place IBM confidential, company confidential, or personal information into any field.