Native Db2 tools - Amazon Relational Database Service

Native Db2 tools

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 Migration by loading data from Amazon S3.

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.