Anyone else with Netezza and DataStage?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 145
- Joined: Fri May 02, 2003 9:59 am
- Location: Seattle, Washington. USA
Anyone else with Netezza and DataStage?
All,
We are running Netezza with DataStage and want to get a better feel for how many other folks are in the same boat. Considering the number of issues we are seeing with the Netezza plug-in I feel like we are the only ones running the plug-in.
We are running Netezza with DataStage and want to get a better feel for how many other folks are in the same boat. Considering the number of issues we are seeing with the Netezza plug-in I feel like we are the only ones running the plug-in.
Shawn Ramsey
"It is a mistake to think you can solve any major problems just with potatoes."
-- Douglas Adams
"It is a mistake to think you can solve any major problems just with potatoes."
-- Douglas Adams
-
- Participant
- Posts: 145
- Joined: Fri May 02, 2003 9:59 am
- Location: Seattle, Washington. USA
Thanks for the advice. I did search and sent a personal message to the only other poster that mentioned Netezza (besides those looking for skills).DSguru2B wrote:Search for the word Netezza. I think there are a couple of posts besides yours out there. You will find a hand full to be in the same boat as you.
Shawn Ramsey
"It is a mistake to think you can solve any major problems just with potatoes."
-- Douglas Adams
"It is a mistake to think you can solve any major problems just with potatoes."
-- Douglas Adams
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
They do data warehouse appliances, so obviously a good match for DataStage. They list Ascential, Informatica and Sunopsis as partners. I think they have had a booth at a couple AscentialWorlds.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
-
- Participant
- Posts: 97
- Joined: Tue Feb 21, 2006 6:45 am
Hi shawn_ramsey,
Regards
Hi we as well are using Netezza with DataStage. We had plug-in problems with Ascential 7.5.1(Server). So far heard that it works with Ascential 7.5.2 (Parallel Extender). Are you facing problems with 7.5.2 or any other version.We are running Netezza with DataStage and want to get a better feel for how many other folks are in the same boat. Considering the number of issues we are seeing with the Netezza plug-in I feel like we are the only ones running the plug-in.
Regards
-
- Participant
- Posts: 145
- Joined: Fri May 02, 2003 9:59 am
- Location: Seattle, Washington. USA
Tostay2003,
Can you send me a private message (or post it if you like) with your contact information? I want to start to build a network of folks using this combination of tools so that we can exchange notes on issues and workarounds.
Is there a server version of the stage? I was told that they just had one for the parallel and since our plan is to only use the parallel I never bothered looking.
In regards to the issues that we have ran into. We have found five significant issues with the plug-in and were beginning to wonder how much testing had gone into it. Since I had originally posted this message IBM has fixed 3 of them and have indicated that we will see the other 2 issues patched next week.
Can you send me a private message (or post it if you like) with your contact information? I want to start to build a network of folks using this combination of tools so that we can exchange notes on issues and workarounds.
Is there a server version of the stage? I was told that they just had one for the parallel and since our plan is to only use the parallel I never bothered looking.
In regards to the issues that we have ran into. We have found five significant issues with the plug-in and were beginning to wonder how much testing had gone into it. Since I had originally posted this message IBM has fixed 3 of them and have indicated that we will see the other 2 issues patched next week.
Shawn Ramsey
"It is a mistake to think you can solve any major problems just with potatoes."
-- Douglas Adams
"It is a mistake to think you can solve any major problems just with potatoes."
-- Douglas Adams
-
- Participant
- Posts: 2
- Joined: Mon Dec 18, 2006 5:32 am
- Location: Bangalore
Re: Anyone else with Netezza and DataStage?
Hi Shawn,
My project is going to implement DataStage with Netezza.
Since you guys have already started with the task, if would be great if you can answer the following queries:-
1. Does DataStage come with an ODBC driver, Native driver or a plug-in for Netezza?
2. Depending on the data load, what would be better a parallel job or a server job for Netezza?
We would be using DataStage Enterprise Edition 7.5.
Thanks,
Sachin
My project is going to implement DataStage with Netezza.
Since you guys have already started with the task, if would be great if you can answer the following queries:-
1. Does DataStage come with an ODBC driver, Native driver or a plug-in for Netezza?
2. Depending on the data load, what would be better a parallel job or a server job for Netezza?
We would be using DataStage Enterprise Edition 7.5.
Thanks,
Sachin
shawn_ramsey wrote:All,
We are running Netezza with DataStage and want to get a better feel for how many other folks are in the same boat. Considering the number of issues we are seeing with the Netezza plug-in I feel like we are the only ones running the plug-in.
Thanks,
Sachin Bansal
Sachin Bansal
Hi Shawn,shawn_ramsey wrote:Tostay2003,
Can you send me a private message (or post it if you like) with your contact information? I want to start to build a network of folks using this combination of tools so that we can exchange notes on issues and workarounds.
Is there a server version of the stage? I was told that they just had one for the parallel and since our plan is to only use the parallel I never bothered looking.
In regards to the issues that we have ran into. We have found five significant issues with the plug-in and were beginning to wonder how much testing had gone into it. Since I had originally posted this message IBM has fixed 3 of them and have indicated that we will see the other 2 issues patched next week.
what were the issues you guys found using plug in stage?
are you guys using 7.5.2 or 7.5.3?
-
- Participant
- Posts: 145
- Joined: Fri May 02, 2003 9:59 am
- Location: Seattle, Washington. USA
We have ran into several challenges with the Netezza Stage which mostly revolve around how differently Netezza works. IBM has done quite a bit of work on the stage based on our feedback and now that others are using the combination of these tools. The new release has added the ability to bulk unload and bulk update within the stage. There are still a few quirks that they are working on but these new features seem to be pretty stable.attu wrote: Hi Shawn,
what were the issues you guys found using plug in stage?
are you guys using 7.5.2 or 7.5.3?
Unfortunately the latest version of the stage is built for DataStage 8 and you would have to request them to back port to 7.5.2.
Shawn Ramsey
"It is a mistake to think you can solve any major problems just with potatoes."
-- Douglas Adams
"It is a mistake to think you can solve any major problems just with potatoes."
-- Douglas Adams
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 145
- Joined: Fri May 02, 2003 9:59 am
- Location: Seattle, Washington. USA
At this point we have it fail and look at the logs manually. Ray's suggestion is an option but the logs only exist on the DataStage server if you use the nzload option, the External Table option drops the logs to the Netezza host node which is going to be more of a challenge to get at.ray.wurlod wrote:Have DataStage check the Netezza load log, for example in an after-job subroutine or in a job sequence downstream of the Job activity. ...
This is still an issue with us and we have put a request for better feedback in the DataStage logs. It does help if more than one company requests enhancement, so please get a case logged for enhancements.
Shawn Ramsey
"It is a mistake to think you can solve any major problems just with potatoes."
-- Douglas Adams
"It is a mistake to think you can solve any major problems just with potatoes."
-- Douglas Adams