Can a single DB Connectn be used in multiple parallel jobs?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 9
- Joined: Wed Feb 06, 2008 12:13 am
Can a single DB Connectn be used in multiple parallel jobs?
Hi,
Iam using a a DB2API stage in my job.
I have created a DB Connection for DB2API stage in Parallel job.
Can the same DB Connection be used in multiple parallel jobs?
Thnk U.
When other person logs in through his id and is tring to load the db connection created by me it is not geting loaded !!why?? We even tried attaching the connection to parameter set ...But its still not working n its not even throwing error ...
Iam using a a DB2API stage in my job.
I have created a DB Connection for DB2API stage in Parallel job.
Can the same DB Connection be used in multiple parallel jobs?
Thnk U.
When other person logs in through his id and is tring to load the db connection created by me it is not geting loaded !!why?? We even tried attaching the connection to parameter set ...But its still not working n its not even throwing error ...
Last edited by RekhaMallam1 on Tue Mar 04, 2008 2:20 am, edited 1 time in total.
-
- Premium Member
- Posts: 197
- Joined: Sun Jul 15, 2007 11:45 pm
- Location: Prague
-
- Participant
- Posts: 147
- Joined: Sat Apr 30, 2005 1:23 am
- Location: Bangalore,India
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Yes. The whole point of a Connector is so that you can have a pre-tested, re-usable component.
<amusing anecdote>
When this object was proposed marketing came up with the name "frictionless connector". The adjective was dropped when some people started referring to it as the KY Jelly stage.
</amusing anecdote>
<amusing anecdote>
When this object was proposed marketing came up with the name "frictionless connector". The adjective was dropped when some people started referring to it as the KY Jelly stage.
</amusing anecdote>
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: 9
- Joined: Wed Feb 06, 2008 12:13 am
Re: Can a single DB Connectn be used in multiple parallel jo
can multiple users use same db connection??RekhaMallam1 wrote:Hi,
Iam using a a DB2API stage in my job.
I have created a DB Connection for DB2API stage in Parallel job.
Can the same DB Connection be used in multiple parallel jobs?
Thnk U.
Can i expect the answer with an example....
Re: Can a single DB Connectn be used in multiple parallel jo
Yes.RekhaMallam1 wrote:can multiple users use same db connection??
Expect: Yes, Receive: noRekhaMallam1 wrote:Can i expect the answer with an example....
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There's nothing to exemplify. Can multiple clients use the database? Yes. DataStage job is just another client application, as far as the database is concerned.
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.
If you're using the 8.0 version of Parallel you can setup a Parameter set that each of your jobs can use. That paramater set will contain the same connection information that each job can use. If you're using 7.5.x then you'll want to setup job parameters that use the same connection information (User Id, Password, DSN, etc.) while every job can use this same connection information, you can't setup one connector with that information and use it in another job.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You can indeed. That is what the (new) Connector stage is for.jmarutz wrote: you can't setup one connector with that information and use it in another job.
A Connector can, of course, use parameterized connectivity values.
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.