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
We believe that the usage and control of IDAA should be transparent to the DB2 user. Instead of controlling an IDAA via stored procedures with XML input & XML output (which may or may not be considered as cumbersome or hard to interpret), the ...
Status changes for IDAA should be reflected in system log
Status changes for IDAA should be reflected in system log with a message. So we can be alert to take necessary actions. It should not be DSNX881I they need to be unique since detection is critical for this messages.
When a load utility (other than shrlevel change) performed on an accelerated table, an informational message should be generated to SYSLOG so we can automate related actions regarding the IDAA.If incremental update is not turned on for an accelera...
Authorization problems with userid related to CDC-DB2 connection
Currently the replication deamon will go into sleep if one of the passwords for one of the subscriptions is in error. He will get back to work once that has been corrected via configuration console updateCretentials() (as the client already knows ...
IDAA - Enable Replication should allow trusted load
When we enable replication for a table, a new load of the table is forced. The IDAA solution should allow enableing replication based on the already loaded table. To insure integrity, the replication should apply logs based on the actuell data. To...
Replication Tasks (CDC) should be ZIIP offloadable
DB2 Analytics Accelerator for z/OS is a product which off loads workload from z/OS. All Task used for loading data, replicating updates, managing the IDAA box is new workload and should be cost efficient according to Mainframe. This means, that ev...
LOAD RESUME YES LOG NO support while loading to accelerator
We are using DB2 v10,z/OS v1.13,IBM DB2 Analytics Accelerator v4.1 in our environment for both our test and production DW environments. In our DW systems LOAD RESUME YES LOG NO is used for loading some of our tables. In IDAA, in a condition like t...
DSN_PROFILE_TABLE should work corrid/Jobname with IDAA
We like to exclude selectively jobs from runing on the IDAA via DSN_PROFILE_TABLE. Right now you can use AUTHID, PLANNAME, COLLID, PKGNAME, LOCATION but not CORRID (jobname). In our data warehouse application we have many thousend of jobs running ...
Count(*) on a very large table produces different SQLCODE when running on either DB2 or the IDAA : On db2 we get an SQLCODE -802 DSNT408I SQLCODE = -802, ERROR: EXCEPTION ERROR FIXED POINT OVERFLOW HAS OCCURRED DURING COLUMN FUNCTION OPERATION ON ...
table functions to get query-list and table-information
Provide also DB2 zOS table functions which returns the same informations as the stored procedures, at least for sysproc.accel_get_queries & sysproc.accel_get_tables_info At the moment, you can only use stored procedures to get the query-list o...
Do not place IBM confidential, company confidential, or personal information into any field.