June 19, 2018 By jason-mcalpin 3 min read

Announcing Data Virtualization (Federation) for Db2 on Cloud

IBM is happy to announce Db2 Data Virtualization features for Db2 on Cloud. Sometimes called “federation,” this feature lets our customers access data from multiple different databases with a single query. With this latest addition, users will now be able to access data that is located on any of their Db2 or Informix data sources including both cloud and on premises systems. This functionality is supported on all versions of Db2 on Cloud, except for the free Lite plan. However, users can use the Lite plan as a target that you can pull data from.

Use Cases for Db2 on Cloud

Combine On Cloud and On Premise:

A company may have started their operations with an on-premises Db2 server. As cloud technology becomes more widespread and companies start to operate on cloud in a cost-effective fashion, there will be continued Cloud growth. However, the organization’s data on both sources remain as a critical component to their decision-making processes. By way of example, a client operating in retail industry needs to be able to access all data, say customer information, to run further analysis on their customers’ consumption behaviors. They need to be able to identify customers, match their records on cloud with already existing ones from an on-premises database and compose them as if the data is being retrieved from a single source. Federation capability here prevents the burdensome data migration process and allows the user to access the data without moving the data.


Attach Db2 Warehouse:

Db2 family users would now be able to federate data between Db2 on Cloud and Db2 Warehouse on Cloud. By being provided a common interface for accessing the data, a user can now easily add or query data from or to the Warehouse without complex ETL processes or any additional code.


Sharding Data Across Multiple Servers:

At times, users may choose to partition (shard). With federation capabilities, data can be queried with a unified interface and this lets the user better balance the workload, scale specific parts of an app or create microservices that work together.


Increase Capacity Beyond Fixed Limits:

By using federation, users can increase capacity of an on premises database by federating to or from the cloud. This is a great option if your on premises database is running out of storage. Increased capacity will also be useful for new development as our users no longer need to change a database in production. You can also use this feature to federate between two Db2 on Cloud databases to increase the capacity beyond the current limits of the Flex plan.

Ready to get started? It is simple

On the Target Machine

Hostname: target.ibm.com

— Create a Table testdata in schema admin2 and load it with data through the console using user admin2 with password YYYY

From a Client Machine

-- catalog the target machines

db2 catalog tcpip node <node_name> remote <hostname> server 50000

e.g. db2 catalog tcpip node fedS remote source.ibm.com server 50000


— catalog the database on fedS


db2 catalog db bludb as <db_name> at node <node_name>

e.g. db2 catalog db bludb as srcdb at node fedS


-- Connect to the database on fedS


db2 connect to <catalog_db_name> user <admin_user> using ‘<admin_password>’

e.g. db2 connect to srcdb user admin1 using ‘XXXX’



— create a wrapper on fedS


db2 "create wrapper drda"



— create a server to talk to the Target Machine


db2 "create server <server_name> type dashdb version 11 wrapper drda authorization \”<admin_user_on_target>\” password \”<admin_password_on_target>\” options (host ‘<target_hostname>’, port '50000', dbname 'bludb')"

e.g. db2 "create server db2server type dashdb version 11 wrapper drda authorization \”admin2\” password \”YYYY\” options (host ’target.ibm.com’, port '50000', dbname 'bludb')"


— Create the User mapping for admin2


db2 "create user mapping for <admin_user> server db2server options (remote_authid ‘<admin_user_on_target>’, remote_password '<admin_password_on_target>')"

e.g. db2 "create user mapping for admin1 server db2server options (remote_authid 'admin2', remote_password 'YYYY')"


— create a nickname for the database


db2 -v "create nickname <nickname> for <server_name>.<schema_name>.<table_name>”

e.g. db2 -v "create nickname ntest1 for db2server.admin2.testdata"

On the Source Machine

— Test to make sure you can pull data from the Target Server


db2 “select * from <nickname>”

e.g. db2 “select * from ntest1”

Moving forward

With its easily scalable flex plan, free-forever Lite version, high availability and added capabilities of data virtualization, Db2 on Cloud will continue to increase its footprint in RDBMS landscape. We are working rigorously on improving every aspect of Db2 on Cloud and will be sharing other great new features for our customers very soon.


More from Announcements

IBM Hybrid Cloud Mesh and Red Hat Service Interconnect: A new era of app-centric connectivity 

2 min read - To meet customer demands, applications are expected to be performing at their best at all times. Simultaneously, applications need to be flexible and cost effective, and therefore supported by an underlying infrastructure that is equally reliant, performant and secure as the applications themselves.   Easier said than done. According to EMA's 2024 Network Management Megatrends report only 42% of responding IT professionals would rate their network operations as successful.   In this era of hyper-distributed infrastructure where our users, apps, and data…

IBM named a Leader in Gartner Magic Quadrant for SIEM, for the 14th consecutive time

3 min read - Security operations is getting more complex and inefficient with too many tools, too much data and simply too much to do. According to a study done by IBM, SOC team members are only able to handle half of the alerts that they should be reviewing in a typical workday. This potentially leads to missing the important alerts that are critical to an organization's security. Thus, choosing the right SIEM solution can be transformative for security teams, helping them manage alerts…

IBM and MuleSoft expand global relationship to accelerate modernization on IBM Power 

2 min read - As companies undergo digital transformation, they rely on APIs as the backbone for providing new services and customer experiences. While APIs can simplify application development and deliver integrated solutions, IT shops must have a robust solution to effectively manage and govern them to ensure that response times and costs are kept low for all applications. Many customers use Salesforce’s MuleSoft, named a leader by Gartner® in full lifecycle API management for seven consecutive times, to manage and secure APIs across…

IBM Newsletters

Get our newsletters and topic updates that deliver the latest thought leadership and insights on emerging trends.
Subscribe now More newsletters