Instead of import try to load thats fast and efficient.





"Sandeep Shah " <db2udbdba-ezmlmshield-x23079627.[Email address protected]
11/30/2005 10:49 AM
Mail Size: 4526

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
Data extraction (Urgent)
Our Ref

Your Ref







Hi all,

I am looking to extract data from Z/OS DB2 database and AS/400 DB2
database into DB2 UDB V8.2 on AIX.

Some of the solutions I have is:
1. Use DB2 Connect, export into a file and then import it.
2. Use BMC unload utility, FTP to aix box and load.
3. Connect Datastage via DB2 Connect to the host databases.
4. A solution made using DB2 Data Propagator. (dont know too much about
it, need help)

The issue with solution no. 1 is that it is not efficient with large
amount of data.
Please help me out in figuring a right solution alongwith the advantages
and disadvantages of each of them.

Thanks in advance.

Regards,
San.

________________________________________________________________________
IMPORTANT NOTICE : The information in this email is confidential and may
also be privileged. If you are not the intended recipient, any use or
dissemination of the information and any disclosure or copying of this
email is unauthorised and strictly prohibited. If you have received this
email in error, please promptly inform us by reply email or telephone. You
should also delete this email and destroy any hard copies produced.


---------------------------------------------------------------------
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 originated from the Internet. Its originator may or may
not be who they claim to be and the information contained in the
message and any attachments may or may not be accurate.
******************************************************************





-----------------------------------------
***********************************************************************
This e-mail is confidential. It may also be legally privileged.
If you are not the addressee you may not copy, forward, disclose
or use any part of it. If you have received this message in error,
please delete it and all copies from your system and notify the
sender immediately by return e-mail.

Internet communications cannot be guaranteed to be timely,
secure, error or virus-free. The sender does not accept liability
for any errors or omissions.
***********************************************************************

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