How do I copy data from one Db2® table to another on a different (connectable) Db2® system?

Scenario: I have data in a Db2® table and want to copy it to another Db2® table. The source and target Db2® tables are on different Db2® systems. It is possible to connect to the target Db2® system from the source Db2® system by specifying a location value.

Consider using the FM/Db2 Copy Utility (3.3), instead of the FM/Db2 Export Utility and the FM/Db2 Import Utility. See How do I copy data from one Db2 table to another on the same Db2 system?. If a large number of rows are to be transferred, some caution needs to be exercised due to network considerations.

Related tasks

Copying data from one Db2 object to another
Column mapping rules

Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.