I will comment two scenarios :
1. for bulk data movement try to use LOAD DATA ... Utility, "cross loader", using in front of Utility an SQL statement like
EXEC SQL DECLARE CURSOR cursor_name ... ENDEXEC
LOAD DATA INCURSOR cursor_name
it will use IBM DB2 Connect DRDA connectivity. IBM Lab told us that it will perform brilliant.
2. for data/row changes, you may use IBM DB2 Data Propagator ( between Host - z/OS , DB2/400 - and DB2/AIX you need
IBM DB2 Connect for DRDA connectivity ). You need "data capture component" in the DB2 Server - source data-, and
"data apply component" in the DB2 requester - target data -.
I hope this info helps you ...
Inigo
-----Mensaje original-----
De: Sandeep Shah [mailto:db2udbdba-ezmlmshield-x23079627.[Email address protected]
Enviado el: miércoles, 30 de noviembre de 2005 6:20
Para: LazyDBA Discussion
Asunto: Data extraction (Urgent)
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
DISCLAIMER:
La información contenida en este mensaje puede ser de uso interno o confidencial. Si al revisarla usted entiende que no es el destinatario, no puede copiar o distribuir el mensaje a nadie, debe destruirlo y notificar tal hecho al emisor. Las opiniones o cualquier otra información contenida, no relacionada con el negocio del Grupo Caja Madrid no debe considerarse como emitida ni aprobada por el mismo.
This information is intended to be confidential and for the exclusive use of the individual or entity named above only . If you are not the intended recipient, be aware that retention, dissemination, distribution or copying of this message is strictly prohibited. If you received it by mistake, please notify the sender immediately and return it to the address above. The opinions and views expressed and any other information contained in this message which are not directly related to the businesses of Caja Madrid Group are not to be considered as disclosed, shared nor approved by it.
DB2 & UDB email list listserv db2-l LazyDBA home page