Seconded. We regularly achieve throughput of 6 Gb an hour with load by
cursor from an AS/400 to an AIX box, and that includes index builds and
runstats. Pump up the bandwidth and you're laughing.
-----Original Message-----
From: akhileshmittal
[mailto:db2udbdba-ezmlmshield-x74762778.[Email address protected]
Sent: 30 November 2005 07:08
To: LazyDBA Discussion
Subject: Re: Data extraction (Urgent)
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.
***********************************************************************
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
******************************************************
The information in this E-mail and in any attachment is
confidential and is intended solely for the addressee.
Access, copying, disclosure or use of such information
by anyone else is unauthorised. If you are not the
intended recipient please contact [Email address protected]
While reasonable efforts are made to ensure these files are free
of virus infection and offensive materials, if something of this
nature is inadvertently sent to you, please destroy it, accept
our apologies and contact [Email address protected] with
details of the sender. We will ensure that action is taken
immediately to prevent any recurrence. Debenhams accept no
responsibility for any views expressed by the originator of this email.
Debenhams Retail plc (reg. no. 83395) Registered in England and Wales.
Registered office: 1 Welbeck Street, London W1G 0AA.
http://www.debenhams.com
******************************************************
DB2 & UDB email list listserv db2-l LazyDBA home page