Hello,

For exporting a user in DB2 I am using this command :
db2move dbname export -sn username # export
db2move targetdb import # import

Please answer for
1) If I do a user export like above command I can see that lot of files are created.(.ixf,.msg created for each table)
How to export to a flat file like oracle to a particular destination?

2) And how to import it back from one flat file like oracle?

3) How to check the number of usernames/users in DB2?

Please help me I am in big trouble

Regards






DB2 & UDB email list listserv db2-l LazyDBA home page