Datastage Upgrade

Archive of postings to DataStageUsers@Oliver.com. This forum intended only as a reference and cannot be posted to.

Moderators: chulett, rschirm

Locked
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Datastage Upgrade

Post by admin »

I am currently using Datastage v3.5. I want to upgrade to v4.0. Previously I upgraded from v3.5 to v3.6 and had many problems. Eventually I went back to v3.5. I still have the cd for v3.5 and will be getting the cd for v4.0.

I would like to know what is the best method to upgrade to v4.0. Eg. Upgrade from v3.5 to v3.6 and then from 3.6 to 4.0 or should I unstall v3.5 and install v4.0. If I do this will the project that I exported on v3.5 import onto v4.0 without problems.

Seema
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Post by admin »

Not sure about upgrade path.
Currently we are in the process of upgrading from 3.6 to 4.1 Looks like export of whole project on 3.6 and import on 4.1 works fine.

Be aware of a bug in 4.0 related to "long table names"
in ODBC stage. GTAR 29311 (The table name ... was larger than SQL_MAX_TABLE_NAME_LEN from SQLGetInfo (30). ) It is fixed in 4.1

Regards

Vardan

-----Original Message-----
From: Seema Ranchoddas [mailto:seemar@netcare.co.za]
Sent: Monday, December 18, 2000 5:22 AM
To: informix-datastage@oliver.com
Subject: Datastage Upgrade


I am currently using Datastage v3.5. I want to upgrade to v4.0. Previously I upgraded from v3.5 to v3.6 and had many problems. Eventually I went back to v3.5. I still have the cd for v3.5 and will be getting the cd for v4.0.

I would like to know what is the best method to upgrade to v4.0. Eg. Upgrade from v3.5 to v3.6 and then from 3.6 to 4.0 or should I unstall v3.5 and install v4.0. If I do this will the project that I exported on v3.5 import onto v4.0 without problems.

Seema
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Post by admin »

Seema,

If you upgrade, make sure the version is at least v4.01.
I too had problems upgrading from v3.5 to v3.6 AND
v4.0 and had to go back to v3.5. Im currently using v4.01
with no problems though I understand Informix has
a more recent release.

I installed v4.01 on a different NT machine (more power) because I didnt want to touch our stable (v3.5) server due to upgrade attempts that earlier did not work. I exported the whole project then imported it into the v4.01 server with no problems. I just had to make sure the ODBC DSNs matched what I had on the other machine.

Hope this helps.

Mark Detwiler
-----Original Message-----
From: Seema Ranchoddas
To: informix-datastage@oliver.com
Date: Monday, December 18, 2000 11:22 AM
Subject: Datastage Upgrade


I am currently using Datastage v3.5. I want to upgrade to v4.0. Previously I upgraded from v3.5 to v3.6 and had many problems. Eventually I went back to v3.5. I still have the cd for v3.5 and will be getting the cd for v4.0.

I would like to know what is the best method to upgrade to v4.0. Eg. Upgrade from v3.5 to v3.6 and then from 3.6 to 4.0 or should I unstall v3.5 and install v4.0. If I do this will the project that I exported on v3.5 import onto v4.0 without problems.

Seema
Locked