Re: Copy data from DB2 (Linux) to PG - Mailing list pgsql-general

From Ravi Krishna
Subject Re: Copy data from DB2 (Linux) to PG
Date
Msg-id 733706689.555193.1541967418547@mail.yahoo.com
Whole thread Raw
In response to Re: Copy data from DB2 (Linux) to PG  (Florian Bachmann <fbachmann.public@gmail.com>)
List pgsql-general
>Haven't tried it myself, but you may be able to connect the DB2 database
>to your PostgreSQL cluster using this FDW module:
>https://github.com/wolfgangbrandl/db2_fdw
>Looks like db2_fdw is DB2 LUW only though, so you might be out of luck
>if your DB2 is on IBM i (or z ;-)

As the thread indicates, I am using DB2 Linux.
I used Carto one with ODBC and it is just not production ready.  Found two bugs within days of
testing.  I have created bugs in the github.


>Then you could just use INSERT INTO ... SELECT  statements to do the ETL
>process with the necessary type conversions and whatnot.

I am currently using Unix pipes to export data from DB2 and concurrently load it to PG via COPY.
It saves nearly half the time of exporting first to file and then loading it.



pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Move cluster to new host, upgraded version
Next
From: Rich Shepard
Date:
Subject: Re: Move cluster to new host, upgraded version