Hi all,
I noticed that each OCI target stage uses one DB connection. So when I need to load into 5 tables, DataStage actually gets 5 DB connections. This results in not enough connections esp when I am sharing the DB with some application developers.
Any way to use one connection for multiple stages/tables? Or rather anyway to use one OCI stage for multiple tables? Currently I use one stage for one table.
Thanks for any help rendered! [:)]
OCI stage DB connections
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Exactly... unless you've got a buggy older version of the OCI8 plugin, simply drag multiple links to the same OCI stage. They will all share the same logon / connection. The only thing different to recognize is you'll need to setup all five by selecting their link name one-by-one from the appropriate pulldown.
The added benefit is they will all share the same unit of work (transaction) and so will be aware of what the others are doing. This helps with doing parent/child RI stuff. You also get a new option in the stage for Transaction Grouping which you may find helpful, check out the online help on that.
-craig
The added benefit is they will all share the same unit of work (transaction) and so will be aware of what the others are doing. This helps with doing parent/child RI stuff. You also get a new option in the stage for Transaction Grouping which you may find helpful, check out the online help on that.
-craig
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
It can be hard to see however when you drag two links into the same OCI stage you will have a two in one stage. When you open up the stage you will see that the input link name is in a combo box and you can choose from any of the links coming into the stage and set table and column settings for that link.
You can do this with most stages including reference and input stages. Usually it is done to prevent the job from becoming too cluttered, however in this case it has the added bonus of sharing a connection.
Vincent McBurney
Data Integration Services
www.intramatix.com
You can do this with most stages including reference and input stages. Usually it is done to prevent the job from becoming too cluttered, however in this case it has the added bonus of sharing a connection.
Vincent McBurney
Data Integration Services
www.intramatix.com