IBM Db2 Bridge Simplifies Mission-Critical Data Integration

IBM Db2 Bridge: A single data movement solution for all of your vital tasks.

A single data movement solution for all of your vital tasks. IBM Db2 Bridge will be your dependable companion along your journey, whether you are updating your data infrastructure, moving database workloads, combining systems, or creating entirely new cloud-native apps.

What is IBM Db2 Bridge?

The features, capabilities, and resources that businesses require when developing a strong data movement strategy are frequently absent from data movement platforms. On the other hand, IBM Db2 Bridge allows both present and potential clients to:

• Transfer data and schema objects to IBM Db2;
• Swiftly create a development and testing environment; and
• Use IBM Optim High Performance Unload for Db2 to speed up migrations and reduce downtime.

Important characteristics of IBM Db2 Bridge 1.1:

• Analyzes dependencies to maintain data integrity: The user can choose a subset of objects or the complete database from a source system.
• Independent of the operating system: It links to source and target systems directly by using ODBC connection, which is unaffected by operating system variations such endianness.
• Multiple Db2 releases are supported: Db2 11.5 or later target systems and Db2 10.5 or later source systems are supported by IBM Db2 Bridge.
• Supports installations based on Db2: Numerous transactional and analytical workloads and deployment options, both on-premises and in the cloud, are supported by IBM Db2 Bridge. Note: Only source systems are supported for IBM Integrated Analytics System (IIAS).
• Interfaces: Simple tasks like establishing the source and target, choosing which items from the source system to migrate, initiating the migration job, and presenting the results are all made simple for the user by an intuitive user interface. More settings are available through a robust command-line interface.
• High performance unload is supported: Through this, clients that are eligible for Optim High Performance Unload for Db2 can activate it.

Regardless of whether you are transferring massive workloads from a single, massive 1000 Terabyte database or from 1000 databases of different sizes, you need a solution that can do the task quickly and accurately without sacrificing data integrity. The right tool for the purpose is IBM Db2 Bridge.

The IBM Db2 Bridge

One tool for transferring data across Db2 databases is IBM Db2 Bridge. Once set up, you may use a command-line client or the browser to start data migration. Multiple transfer scenarios are supported by IBM Db2 Bridge.

• Version 10.1 and above of Db2 are compatible with IBM Db2 Bridge. This contains the source database’s level.
• The target database level has to be Db2 version 11.5.5 or higher.
• Db2 version 10.1 and later allow users to transfer data using Transport Layer Security (TLS) connections.

Data transport scenarios that were supported

There are several ways to transfer your Db2 deployment using Db2 Bridge:

• Db2 to Db2
• Db2 to Db2 on cloud platforms
• Db2 file to Db2
• Db2 to Db2 file
• Clone Db2 database using db2clone.

Operating systems that are supported

Systems running Red Hat Enterprise Linux (RHEL) 8 on the x86_64 and powerpc64le platforms may now use IBM Db2 Bridge.

• Prerequisites and limitations
  • Make sure your system satisfies the necessary requirements before installing IBM Db2 Bridge. You should be aware of some use limits as well.
• Setting up
  • Red Hat Enterprise Linux (RHEL) 8 users can purchase IBM Db2 Bridge as an RPM package from Passport Advantage Online. Along with downloading and installing IBM Db2 Bridge, you also need to make sure that IBM Global Security Kit GSKit is installed and that your system is setup for secure TLS connection.
• Configuration
  • You may now install the IBM Db2 Bridge RPM package on your Red Hat Enterprise Linux (RHEL) 8 system and begin configuring the service.
• Getting the Db2 Bridge license activated
  • A 30-day trial license is included by default with IBM Db2 Bridge. To continue using the product after the trial time has finished, you must apply an activation key.
• Restart
  • You must restart the program after configuring IBM Db2 Bridge. It can be restarted either the command line interface (CLI) or the Bridge user interface (UI).
• Removal
  • You have the option of deleting IBM Db2 Bridge entirely from your computer or uninstalling it.
• Making use
  • The IBM Db2 Bridge can be launched via a website or a command-line client.

Using IBM Db2 Bridge

It can be launched via a website or a command-line client.

Prior to starting

You must first launch the IBM Db2 Bridge Server before submitting a data movement job request via the IBM Db2 Bridge Client in order to use IBM Db2 Bridge. It is advised to use the systemcl command to run the IBM Db2 Bridge Server.

Alternatively, the IBM Db2 Bridge website may be accessed via https://:14080 after installation, provided that the default port number settings were utilized. where the hostname or IP address of a computer running IBM Db2 Bridge is represented by the .

Methodology

From the command line, execute a data movement job.
Use the db2bridge_client script to execute a data movement task, then supply the source and target environments along with the data movement scenario.

db2bridge_client <db2bridge_server_details> <subcommand_scenario> <subcommand_parameters>

Examples

Example 1:

Moving two tables, TABLE1 and TABLE2, from one Db2 database to another Db2 database is an example.

DB2BRIDGE_CLIENT DB2_DB2 --THOSTS 10.0.0.1 --TUSER ADMIN2 --TPASS PASSWORD2 --TDB TDATABASE --SHOST 10.0.0.2 --SUSER ADMIN1 --SPASS PASSWORD1 --SDB SDATABASE --TABLES TABLE1 TABLE2

Example 2: Transferring two tables, TABLE1 and TABLE2, across two Db2 databases. TABLE1A and TABLE2A are the new names for the tables:

DB2BRIDGE_CLIENT DB2_DB2 --THOSTS 10.0.0.1 --TUSER ADMIN2 --TPASS PASSWORD2 --TDB TDATABASE --SHOST 10.0.0.2 --SUSER ADMIN1 --SPASS PASSWORD1 --SDB SDATABASE --MV TABLE1 TABLE1A --MV TABLE2 TABLE2A

Example 3: Transferring a whole schema. The following command may be used to accomplish this scenario:

db2bridge_client db2_db2 --shosts 10.0.0.1 --suser ADMIN1 --spass PASSWORD1 --sschema SOURCE_SCHEMA --sdb SDATABASE --thosts 10.0.0.2 --tuser ADMIN2 --tpass PASSWORD2 --tdb TDATABASE --whole-schema

Example 4: Cloud-based Db2 migration. The database and schema may be moved to a cloud offering—in this example, Db2 on Cloud—by using the following command.

db2bridge_client db2_db2cloud --shosts 10.0.0.1 --sport 50000 --suser ADMIN1 --spass PASSWORD1 --thost db2oncloud.ibm.com --tport 12345 --tuser ADMIN2 --tpass PASSWORD2 --sdb SDATABASE --sschema SSCHEMA --whole-schema --tschema TSCHEMA --binary

Example 5: Switching between different cloud offerings. The following command may be used to accomplish this scenario:

db2bridge_client db2_db2 --shost DB2ONCLOUD1.IBM.COM --sschema SSCHEMA --suser ADMIN1 --spass PASSWORD1 --sdb SDATABASE --sport 50001  --thost DB2ONCLOUD2.IBM.COM --tschema TSCHEMA --tuser ADMIN2  --tpass PASSWORD2 --tdb TDATABASE --tport 50001 --target-ssl True --source-ssl True

Example 6: Transferring a whole database:

db2bridge_client db2_db2 --shosts 10.0.0.1 --suser ADMIN1 --spass PASSWORD1 --sschema SOURCE_SCHEMA --sdb SDATABASE --thosts 10.0.0.2 --tuser ADMIN2 --tpass PASSWORD2 --tdb TDATABASE --whole-db

Example 7: Using the text files to obtain the parameters for moving:

db2bridge_client db2_db2 @<filename> [@<filename>...] 

Other scenarios can also make advantage of this functionality.

Note: When obtaining arguments from multiple files, the arguments from each of these files are concatenated.