Hi,
Definitely you can do this, using 'db2move' utility!
db2move - Database Movement Tool Command
This tool facilitates the movement of large numbers of tables between DB2 databases located on workstations. The tool queries the system catalog tables for a particular database and compiles a list of all user tables. It then exports these tables in PC/IXF format. The PC/IXF files can be imported or loaded to another local DB2 database on the same system, or can be transferred to another workstation platform and imported or loaded to a DB2 database on that platform.
Sample command could be:
db2move db_name export -sn myschema1
Thanks,
Ajay Jain
-----Original Message-----
From: ajay [mailto:db2udbdba-ezmlmshield-x93810436.[Email address protected]
Sent: Friday, February 25, 2005 12:57 PM
To: LazyDBA Discussion
Subject: Exporting all the tables in a Schema
Hi all,
I am trying to solve a small problem here. I want to export all the tables in a schema to flat files. Is there any way to do it??
Regards,
Ajay Joy
Tata Consultancy Services Limited
Mailto: ajay.[Email address protected]
Website: http://www.tcs.com
Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited.
DB2 & UDB email list listserv db2-l LazyDBA home page