Upgrading to 11.3 from 8.7

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
cosec
Premium Member
Premium Member
Posts: 230
Joined: Tue May 08, 2007 8:10 pm

Upgrading to 11.3 from 8.7

Post by cosec »

Hi,

We are currently planning to upgrade from DataStage v8.7 to v11.3.

I would appreciate your advice on the following:

1. Will ETL jobs in v8.7 with DB2 UDB Load stage, work without changes in v11.3?

2. will the DB2 UDB Load stage be able to connect to external DB2 database v11.1 ? If otherwise any other alternatives ?

Thanks
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

We'll see what kind of answers you get but to me these sound like questions you should asking your sales person.

I'm also curious (based on your forum choice and job type noted) if you are really asking about a Server jobs only environment...
-craig

"You can never have too many knives" -- Logan Nine Fingers
cosec
Premium Member
Premium Member
Posts: 230
Joined: Tue May 08, 2007 8:10 pm

Post by cosec »

We checked with IBM support.

1. The ETL jobs will work ok without any changes in DataStage v11.3

2. DataStage v11.3 supports only up to DB2 database version 10.5
priyadarshikunal
Premium Member
Premium Member
Posts: 1735
Joined: Thu Mar 01, 2007 5:44 am
Location: Troy, MI

Post by priyadarshikunal »

Reg 11.1 support, you can always use v10 client to connect to 11.1 server if you must. Things we have been doing since long.
Priyadarshi Kunal

Genius may have its limitations, but stupidity is not thus handicapped. :wink:
PaulVL
Premium Member
Premium Member
Posts: 1315
Joined: Fri Dec 17, 2010 4:36 pm

Post by PaulVL »

The quality of the metadata in your jobs will determine if you need to fix them after the migration.

Sloppy jobs may have been created and worked in 8.7, but the metadata rules are enhanced in 11.3. Might fail at compile time or at execution time. Or... run just fine.
Post Reply