Native Db2 tools - Amazon Relational Database Service

Native Db2 tools

You can use several native Db2 tools, utilities, and commands to move data 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 RDS for Db2 DB instance.

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 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.