Hi All,
We are using Datastage 9.1 parallel jobs. Database is Oracle 12C. When we try to read and write the recods by using odbc connector stage , we could see the performance of the job is very less.
Kindly through me some inputs by increasing the performane or re-design the job as well.
odbc connector stage performance issue on Oracle 12 C
Moderators: chulett, rschirm, roy
-
satheesh_color
- Participant
- Posts: 182
- Joined: Thu Jun 16, 2005 2:05 am
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
ODBC is necessarily slower than native connectivity, not least because of the extra layer of software (the ODBC driver) that has to be involved.
Try using a native Oracle stage; for preference the Oracle Connector stage.
Try using a native Oracle stage; for preference the Oracle Connector stage.
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.
Re: odbc connector stage performance issue on Oracle 12 C
Compared to what?satheesh_color wrote:we could see the performance of the job is very less
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers