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
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...
Allow DBM CFG FEDERATED YES ONLINE configurable Db2 federation is activated by: UPDATE DATABASE MANAGER CONFIGURATION USING FEDERATED YES To use federation it is necessary to stop/start database manager. Please make it possible to activate federat...
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, ...
Db2 Federation offers different types of wrappers to transfer data from a source database to a target database. For the federation from Db2 LUW to Oracle we tried the JDBC, NET8 and ODBC wrapper, but all wrappers process the rows one by one. To ge...
Basically, federation is a client application of the data source, so what the database expose to client is seeable for federation. As for the hidden column, it's designed not visible to client, the hidden column is not able to be fetched from the ...
We have been able to successfully implement federation from Db2 on Linux (v11.5.7) to Aurora PostgreSQL v13.4 using the ODBC wrapper. However, when attempting to implement a similar federation from Db2 on Windows to Aurora PostgreSQL v13.4/v14.3 u...
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.
Do not place IBM confidential, company confidential, or personal information into any field.