What are the best options to Copy data from one database to a different database with

[okonita]

Hi all,
I have a need to copy data from one database/schema to a different database schema. Yes, I can use export/import but that is not "elegant". Yes, I can try a redirected Restore from Backup but this method has the irritating requirement of pause, set tablespaces and continue, again much manual intervention.
What I am most interested in is this: The two databases are in the same instance/server. I want to be able to copy directly from database table to database table. For example, copy SCHEMA.TABLE1 to SCHEMAB.TABLE1. What are the options I can employ to do this outside of export and redirected restore?
Does anyone have a easy to clone script to do this? I certainly will appreciate any help or pointers that I can get.

Thanks

[kumarmdb2]

Hi all,
I have a need to copy data from one database/schema to a different database schema. Yes, I can use export/import but that is not "elegant". Yes, I can try a redirected Restore from Backup but this method has the irritating requirement of pause, set tablespaces and continue, again much manual intervention.
What I am most interested in is this: The two databases are in the same instance/server. I want to be able to copy directly from database table to database table. For example, copy SCHEMA.TABLE1 to SCHEMAB.TABLE1. What are the options I can employ to do this outside of export and redirected restore?
Does anyone have a easy to clone script to do this? I certainly will appreciate any help or pointers that I can get.

Thanks

You can look at db2move utility

If only 1 or 2 table at a time you can in control center in wondows (Not sure about other platforms) you can also right click the table you want to copy and specify the new destination which can be on another database/server

Regards,

Kumar