Question: how to copy data from one database to another in db2?
Answer: Use the FM/Db2 Export Utility (3.7) to export the data to a sequential file (preferably) or a VSAM file. In general, the default mapping is sufficient. ...  Use the FM/Db2 Import Utility (3.6) to load the exported data into the target Db2 table.