Has anyone gotten "db2move" to work against os/390 DB2 v7.1 - including
table space and index creation?

I developed my own process when db2move failed to operate effectively
but I have not tried in a long time so maybe IBM fixed it?

Rick

-----Original Message-----
From: jain
[mailto:db2udbdba-ezmlmshield-x90300787.[Email address protected]
Sent: Friday, February 25, 2005 3:55 AM
To: LazyDBA Discussion
Subject: RE: Exporting all the tables in a Schema

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.


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


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