user exp / imp in db2

[val02]

hi all

is there any way in which we can export the user (db2admin)objects (tables, procedures, functions etc) to a dump file .dmp or any other file and import the file at some other database in some other user...
oracle has exp and imp command (command line commands) ..


thanks and regards

vallabh

 

[xinu]

Yes, there is.

Here is an example using CLI for exporting data:
db2 export to my_exprt.ixf of ixf select * from owner.table_name

To import the data into a table, use "import":
db2 "import from my_exprt.ixf of ixf insert into other.table_name"

The db2look command is useful for generating ddl.

The above examples are very basic. For more details, please see the DB2 UDB "Command Reference" manual.