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
Officially support and optimize performance from Federation (Db2 Linux/Unix/Windows) server to Apache Cassandra databases. We need to support as many data sources as possible as the move towards non-homogeneous data ingestion continues.
We use a replication solution which utilizes DB2 LUW Federation as a link between DB2 z/OS (source database) and Postgres (target database). So the picture is as follows: SQL Replication 11.4 -Db2 z/OS 12 on mainframe, -Db2 LUW Federation 11.5.8, ...
Enhance Db2 Federation to support LOBs as remote procedure parameters
Currently LOBs are not supported as an input/output parameters for a remote stored procedure in Oracle via federation. This creates a limitation of 32k (VARCHAR2) at the moment. It would be useful to pass larger strings or XML and be able to map t...
Enhance Db2 Federation to support pushdown of CSE to Oracle
There is a need to support the pushdown of CSEs (Common Subquery Expressions) as part of the federation to Oracle databases. This limitation has existed for quite a while and there has been an ongoing request for this functionality for years.
Add support in Db2 Federation for join and aggregation pushdown for MongoDB
Currently, the driver for use with MongoDB does not support the $lookup operator which would allow for the pushdown of the joining of two or more collections to the source DB. Adding support would allow for joining collections at the source and re...
Add support for a CLOB data type for MongoDB federation
Currently a long string or text field greater than 32k is truncated when fetching from MongoDB. This limits the data that can be retrieved and processed via Federation from MongoDB and other NoSQL data sources.
The next major release of Oracle (23c) is due out this year (2023) and customers will start to migrate their federated source databases to the new release. We need to ensure that we certify compatibility as soon as possible to keep up with the tec...
Change stored procedure SYSPROC.NNSTAT to use method 2 for ODBC based nicknames
The SYSPROC.NNSTAT stored procedure uses method 1 for automatic, asynchronous statistics collection for ODBC based nicknames.This results in lack of statistics being collected, leading the optimizer to derive at inefficient access plans.
Federation to support Spark in Databricks platform
Our enterprise data lake has Spark in Databricks and have many projects/ applications waiting to access these datasets from datalake for their use cases, using Federation server Nicknames. We did a quick test in our lab for which we were able to c...
Do not place IBM confidential, company confidential, or personal information into any field.