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.

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