For DB2 for DB2® for Linux, UNIX, and Windows databases,
you can copy data from one table to another. The tables can be in
the same database or different databases.
Data migration overview
Migrating data can be useful when you normalize tables
and must move data from one table to another or when you want to copy
data between environments. For example, you might want the data in
the test environment to closely resemble the data in the production
environment.