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