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 Amazon 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. |
|
IMPORT command | Migrating small tables and tables with large objects (LOBs) from a client machine to the RDS for Db2 DB instance. |
|
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. |
|
INSERT command | Copying data in small tables from a self-managed Db2 database to an RDS for Db2 database. |
|
LOAD command | Migrating small tables without large objects (LOBs) from a client machine to the RDS for Db2 DB instance. |
|