DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
rumu
Participant



Joined: 06 Jun 2005
Posts: 189

Points: 1542

Post Posted: Mon Jul 09, 2018 7:33 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Netezza connector stage is used to load Facts table into Dimensional layer. We are using a generic job that has one row generator stage connected to a Netezza Connector stage. Facts loading logic is written in SQL scripts and called within the Netezza stage as passing the script name in parameter. This job mostly runs fine but sometimes kept on running for hours without fetching a single records and after few hours it started fetching records.

In director log, it shows "Timed out " while data is being fetched. In an IBM post I found that Netezza opens a pipe to load the data creating an external table and there is a bug on the Netezza side that process hangs, which is not a DataStage issue.

Any suggestions? Can we use ODBC stage in place of Netezza stage?
Though native DB stage is usually better than ODBC I am wondering what could be an optimal solution here.

Thanks for any help.

_________________
Rumu
IT Consultant
ray.wurlod

Premium Poster
Participant

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

Joined: 23 Oct 2002
Posts: 54248
Location: Sydney, Australia
Points: 294235

Post Posted: Mon Jul 09, 2018 5:09 pm Reply with quote    Back to top    

By all means try ODBC. If there's a bug in the Netezza stage, then ODBC will be a valid workaround (that is, it works and the NZ stage doesn't).

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne
Rate this response:  
Not yet rated
rumu
Participant



Joined: 06 Jun 2005
Posts: 189

Points: 1542

Post Posted: Mon Jul 09, 2018 8:47 pm Reply with quote    Back to top    

Thanks Ray..We are also thinking in the same line.

_________________
Rumu
IT Consultant
Rate this response:  
Not yet rated
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