DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
This topic has been marked "Resolved."
Author Message
cosec



Group memberships:
Premium Members

Joined: 08 May 2007
Posts: 230

Points: 1913

Post Posted: Tue May 30, 2017 8:15 pm Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Server
OS: Unix
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

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42216
Location: Denver, CO
Points: 216757

Post Posted: Wed May 31, 2017 6:31 am Reply with quote    Back to top    

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

Watch out where the huskies go and don't you eat that yellow snow
Rate this response:  
cosec



Group memberships:
Premium Members

Joined: 08 May 2007
Posts: 230

Points: 1913

Post Posted: Thu Jun 01, 2017 2:54 am Reply with quote    Back to top    

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
Rate this response:  
priyadarshikunal



Group memberships:
Premium Members

Joined: 01 Mar 2007
Posts: 1730
Location: Troy, MI
Points: 9288

Post Posted: Fri Jun 02, 2017 1:28 am Reply with quote    Back to top    

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
Rate this response:  
PaulVL



Group memberships:
Premium Members

Joined: 17 Dec 2010
Posts: 1153

Points: 7639

Post Posted: Fri Jun 02, 2017 7:50 am Reply with quote    Back to top    

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.
Rate this response:  
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours