Question: how to copy data from one table to another table in different database 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.