Using native Db2 tools to migrate data from Db2 to Amazon RDS for Db2 - Amazon Relational Database Service

Using native Db2 tools to migrate data from Db2 to Amazon RDS for Db2

You can use several native Db2 tools, utilities, and commands to move data directly from a Db2 database to an Amazon RDS for Db2 database. To use these native Db2 tools, you must be able to connect your client machine to an RDS for Db2 DB instance. For more information, see Connecting a client machine to an Amazon RDS for Db2 DB instance.

Note

Another way to move your data is to first save it to an Amazon S3 bucket, and then use the LOAD command to transfer that data into a table in your RDS for Db2 database. This method provides the best performance when migrating a large amount of data because of good network connectivity between RDS for Db2 and S3. For more information, see Migrating Db2 data through Amazon S3 to Amazon RDS for Db2.

Tool name Use case Limitations

db2look

Copying metadata from a self-managed Db2 database to an RDS for Db2 database.

  • You must modify the syntax for creating buffer pools, creating tablespaces, and creating roles to match the syntax used by the RDS for Db2 stored procedures.

IMPORT command

Migrating small tables and tables with large objects (LOBs) from a client machine to the RDS for Db2 DB instance.

  • Slower than the LOAD utility due to INSERT and DELETE logging operations.

  • Poor performance with limited network bandwidth.

INGEST utility

Continually streaming data from files and pipes without large objects (LOBs) on the client machine to the RDS for Db2 DB instance. Supports INSERT and MERGE operations.

  • Can't stream data files that contain LOBs. Use the IMPORT command instead.

  • Connectivity required between self-managed Db2 database and RDS for Db2 database.

INSERT command

Copying data in small tables from a self-managed Db2 database to an RDS for Db2 database.

  • Connectivity required between self-managed Db2 database and RDS for Db2 database.

  • Poor performance with limited network bandwidth.

LOAD CLIENT command

Migrating small tables without large objects (LOBs) from a client machine to the RDS for Db2 DB instance.

  • Can't migrate data files that contain LOBs. Use the IMPORT command instead.

  • Poor performance with limited network bandwidth.