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 (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 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 (https://www.ibm.com/ideas) - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal (https://ideas.ibm.com) - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM.

ideasibm@us.ibm.com - 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 https://ideas.ibm.com


ADD A NEW IDEA

Db2 Analytics Accelerator Loader for z/OS

Showing 24 of 14384

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...
about 1 year ago in Db2 Analytics Accelerator Loader for z/OS 0 Future consideration

add message at EOJ with jobs/load stats

Currently in loader job output the stats of the job /table / load times are displayed. I would like for them to be in a message that we can use to automate stats on loads. example: “HLxxxxI Job J9I75275 Full table, number of rows: 610254877, amoun...
about 1 year ago in Db2 Analytics Accelerator Loader for z/OS 0 Future consideration

Use of IDAA Loader with REORG Utility w/ Purge LOG(NO)

Currently after a Db2 table REORG/Purge job that is using LOG(NO) I have to have a secondary jobstep to then reload the accelerator shadow table(s). What I'm thinking is that if the IDAA Loader can load the accelerator shadow table(s) in parallel ...
6 months ago in Db2 Analytics Accelerator Loader for z/OS 1 Not under consideration

Issue different return code when no rows loaded

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...
over 2 years ago in Db2 Analytics Accelerator Loader for z/OS 0 Future consideration

Improve AOT backup performance

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 ...
about 4 years ago in Db2 Analytics Accelerator Loader for z/OS 1 Not under consideration

LOAD into accelerator table via ALIAS name

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...
about 1 year ago in Db2 Analytics Accelerator Loader for z/OS 0 Future consideration

HLOMAINT utility enhancement request

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 ...
over 4 years ago in Db2 Analytics Accelerator Loader for z/OS 2 Not under consideration

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...
about 5 years ago in Db2 Analytics Accelerator Loader for z/OS 0 Planned for future release

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...
almost 4 years ago in Db2 Analytics Accelerator Loader for z/OS 1 Planned for future release

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...
over 4 years ago in Db2 Analytics Accelerator Loader for z/OS 1 Functionality already exists