DSXchange

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 ...

I think so . just define it as an env variable in the administrator once and use it where ever you want. thats how we do it in TD, i think we can do the same in DB2

I believe we can use it.

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>

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 multiple users use same db connection??
Can i expect the answer with an example....

RekhaMallam1 wrote:can multiple users use same db connection??

Yes.

RekhaMallam1 wrote:Can i expect the answer with an example....

Expect: Yes, Receive: no

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.

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.

jmarutz wrote: you can't setup one connector with that information and use it in another job.

You can indeed. That is what the (new) Connector stage is for.
A Connector can, of course, use parameterized connectivity values.