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 InSync support to LOAD SHRLEVEL NONE LOG YES. Customer changed the load to SHRLEVEL CHANGE LOG YES. It worked, but the Elapsed Time increase 28% and the CPU consumption increase 821%. Is a huge difference.
Compare data between Db2z and IDAA against any differences
Customer would like to compare the data on table level between Db2z and IDAA. Their inspiration is coming from QRep. There is a command called asntdiff and it compares data between source and target. They use regularly for Qrep and looking for sim...
Unable to clear error: IDAA 436: Failed to collect status from resource manager
The error below shows in the ap issues area in IDAA Appliance. We use IAS. Open alerts (issues) and unacknowledged events +------+---------------------+--------------------+-----------------------------------------------------+--------------------...
Externalize IDAA internal configuration / tuning parameters visible by customer
Wells Fargo’s Audit Department requires monitoring of configuration parameters. At least monthly (in Database Operation case its daily), Enterprise Compute Services (ECS) Drift Identification Automation compares deployed configuration data to the ...
If customers need FAILBACK capability back to Db2 in case SQL has an issue in accelerator, they currently use ENABLE WITH FAILBACK option. However, the routing criteria of ENABLE option includes cost factors calculated by optimizer. Customers want...
Improve performance of queries with correlated subqueries in IDAA v7
Queries with correlated sub-queries where index access is involved will generally run faster on Db2z then on IDAA v7. Since IDAA v7 supports correlated subqueries, these queries are generally offloaded to IDAA, although they may run significantly ...
There is Online Schema Change Support for both repliacted and non-replicated Accelerator Shadow Tables but AOTs. If customer would like to change the schema of an AoT, it should be removed/added/loaded again. It causes business outage and a lot of...
Monitor IDAA for z/OS physical filesystem in size in real time
There are different UIs such as Data Studio, DSM and and Admin UI and they provide different metrics for storage usage in IDAA on Z. Such as; - Table size in data studio determined at the table level, - Used Space in data studio which comes from U...
All accelerated tables should have LASTUSED information. The Lastused information enables: 1) Removal of tables not used. 2) Avoid unnessecerary loads of tables 3) Frees up space on Accelerator 4) Reduces accelerator table maintenance 5) Removes o...
Do not place IBM confidential, company confidential, or personal information into any field.