Re: Migrating data from DB2 zOS to PostgreSQL - Mailing list pgsql-general

Hello Julien,

We created DDLs from DB2 zOS system and tried to run script in below format:

 ./db2topg.pl -f sql1.txt -o testdir

It throws below error:

I don't understand <CREATE TABLE "A90DVDT"."DLR_FAM_MRKTSHR_FY_END"

> at ./db2topg.pl line 880, <IN> line 24.

For testing we used file with below content:

cat sql1.txt

-- This CLP file was created using DB2LOOK Version "10.5"

-- Timestamp: Tue Dec  6 04:14:28 CST 2016

-- Database Name: DB239

-- Database Manager Version: DB2 Version 11.1.0

-- Database Codepage: 1208

------------------------------------------------

-- DDL Statements for Table "A90DVDT"."DLR_FAM_MRKTSHR_FY_END"

------------------------------------------------

CREATE TABLE "A90DVDT"."DLR_FAM_MRKTSHR_FY_END"

                (

                 "DEALER_ID"  CHAR(6)  NOT NULL ,

                 "MKTSHR_MONTH"  DATE NOT NULL ,

                 "L12_DP_DLR_IN_AOR"  DECIMAL(15,6) ,

                 "L12_DP_DLR_OUT_AOR"  DECIMAL(15,6) ,

                 "L12_DP_DLR_SHARE"  DECIMAL(8,5) ,

                 "L12_SA_DLR_SHARE"  DECIMAL(8,5) ,

                 "L12_CA_DLR_SHARE"  DECIMAL(8,5) ,

                 "L12_U90_DLR_IN_AOR"  DECIMAL(15,6) ,

                 "L12_U90_DLR_OUT_AOR"  DECIMAL(15,6) ,

                 "L12_U90_DLR_SHARE"  DECIMAL(8,5)

                );

Thanks,

Swapnil

On Tue, Dec 6, 2016 at 12:23 PM, Julien Rouhaud <julien.rouhaud@dalibo.com> wrote:

On Tue, Dec 06, 2016 at 11:06:12AM +0530, Swapnil Vaze wrote:
> Hello,
>

Hello

> We need some help on how we can migrate data from DB2 zOS database to
> postgres database.
>
> Are there any utilities present? Any thoughts how we should approach?

You can use this utility: https://github.com/dalibo/db2topg

The README should provide all needed informations.

--
Julien Rouhaud
http://dalibo.com - http://dalibo.org

--

Thanks & Regards,

Swapnil Vaze