oracle_db2 subcommand

db2bridge_client [--db2bridge-server-host] [--db2bridge-server-port] [--db2bridge-server-ssl
<True/False>]
[--db2bridge-server-ssl-certificate <public_certificate_file>] oracle_db2
<subcommand_arguments>
 

--shost

Use this parameter to specify the source Oracle instance.

--sport

Port of the source Oracle connection.

--suser

Username credentials for the source connection. The default name is BLUADMIN.

--spass

Password credentials for the source connection. You can also set it by using the ORACLE_SOURCE_PASSWORD environment variable.

--sdb

Name of the source database that is used. The default value is BLUDB.

--source-db-driver

Absolute path of the Oracle driver file for the source connections. For example, this file path and driver can be /opt/oracle/instantclient_23_9/libsqora.so.23.1.

--source-ssl {True,False}

This parameter is used to set whether the connection to the source database is encrypted with SSL. By default, this parameter is set to False.

--source-certificate

If --source-ssl is set to True, specify the location of the client_wallet folder, which contains all the necessary files, including keys and TLS or SSL certificates required for a secure connection. Update the ownership of this certificate file to the migplat user so that Db2 Bridge can access it. For example,

chown -R migplat:migplat 
path/to/client_wallet_folder

--stenant

This case-sensitive parameter is used to identify the source tenant. The default source tenant is SYSTEM.

--thost

Use this parameter to specify target host IP address.

-tport

Port of the target connection.

--tuser

Username of the target Db2 connection. The default name is BLUADMIN.

--tpass

Password of the target connection. You can also set it by using DB2_TARGET_PASSWORD environment variable.

--tdb

Name of the target database that is used. The default value is BLUDB.

--target-ssl {True,False}

This parameter is used to set whether the connection to the target database is encrypted with SSL. By default, this parameter is set to False.

--target-certificate

If --target-ssl is set to True, then this parameter needs to be provided. Specify a fully qualified certificate name to be used for the SSL connection to the target. For example, this file path and certificate can be /home/user1/trusted_certs/target_host_cert.pem. By default, this certificate is stored in the keystore.

--ttenant

This case-sensitive parameter is used to identify the target tenant. The default target tenant is SYSTEM.

--preserve-tablespaces {TRUE | FALSE}

Default: TRUE

Creates a table on the target within the same table space where table existed in on source. The table spaces must exist on the target. This parameter conflicts with the --tablespace parameter.

Can be used to move table spaces as well.

--tables [ ...], -t [ ...]

This case-sensitive parameter takes all the table names that are moved from the source to the target, assuming the source table and target table have the same names.

Note: Using -t X Y.

--ttablespace <TTABLESPACE>

This case-sensitive parameter is used to specify a target table space name for new target tables.

--whole-schema

This parameter moves all the database objects under the current source schema name.

Attention: This parameter cannot be used in conjunction with other schema level parameters.

--sschema

This case-sensitive parameter is used to identify the source schema. By default, the source schema name is uppercase of --suser.

Note: The target schema name will be same as source schema name.

--views [ ...], -v [ ...]

This case-sensitive parameter takes all the view names that are moved from the source to the target, assuming the source dependencies and target dependencies have the same names.

--whole-db

Move the complete database and its underlying objects under the current database.

Attention: This parameter cannot be used in conjunction with other schema level parameters.

--include-object-dependencies

Automatically detects and moves the specified database object dependencies.

--log-level

Specifies the logging level for the IBM Db2 Bridge command processing.

--max-data-streams

Specifies the maximum number of parallel data streams during the data movement operation. By default, this parameter is set to Number of Source Table Partitions.

--skip-data-migration

Skips data migration for tables and transfers only the DDL. This behavior also applies to all dependent tables.

--workers

Number of parallel workers during the migration.

--count-rows , -r

Displays the number of rows. Use the NO option if you do not want to display the number of rows. Use the TARGET option if you want to display the number of rows in the target. Use the BOTH option if you want to see the number of rows in both the source and the target. By default, this parameter is set to NO.

--verbose

Use this parameter if you want the output to contain every detail.

--help, -h

Use this parameter to show the help message then exit.

--version, --rev

Use this parameter to show the version number of the IBM® Db2® Bridge then exit.