ODBC vs DB2 Connector Stage
Moderators: chulett, rschirm, roy
ODBC vs DB2 Connector Stage
Has anyone seen more reliablity with the ODBC connector stage compared to the DB2 connector stage? I'm new to parallel and I like the performance of the DB2 connector especially settign it to insert new update existing. However, I been hit or miss with the stage as there were times I'd change just the array size and the job wold fail. Then I'd change it back and then I'd get what didn't appear to even be a db2 error but something with DataStage. I'd delete the stage and re-add it an it would work fine.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There are very many "funny" things with the DB2 Connector. We experience erratic behaviour connecting to DB2 on a mainframe. But the DB2 Connector is very new - presumably IBM will iron out some of the faults we (the users) have reported. After all, DB2's fairly important to them!
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
The ODBC connector is the oldest of all the connectors so presumably it is the safest. You would expect IBM to get the DB2 connector right given their access to the DB2 development team! There are a couple fix pack releases and an 8.1.2 release of the foundation tools that might help.
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