Search Postgresql Archives

Re: Migrating data from DB2 zOS to PostgreSQL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





On Tue, 6 Dec 2016, 9:27 p.m. Swapnil Vaze, <swapvaze28@xxxxxxxxx> wrote:

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)
                );

I will strongly recommend removing the quotes around table name and column names. Else you may have challenges porting application to PG. As PG by default refers to object names in small case unless you out quotes around them.

So after migration a statement like 

Select * from DLR_FAM_MRKTSHR_FY_END; 

would fail.

Also about the error, see what is before this create table statement. Make sure there is a semi colon to terminate the statement before the CREATE table.

How are you running it? psql?


Thanks,
Swapnil


On Tue, Dec 6, 2016 at 12:23 PM, Julien Rouhaud <julien.rouhaud@xxxxxxxxxx> 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
--

-- 

Best Regards,

Sameer Kumar | DB Solution Architect

ASHNIK PTE. LTD.

101 Cecil Street, #11-11 Tong Eng Building, Singapore 069533

T: +65 6438 3504 | www.ashnik.com

Skype: sameer.ashnik |   T: +65 8110 0350


www.ashnik.com


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux