DSXchange

Hi,

I have created a DB2API connection(Let's call it 'Sample_Db_Connection') and want it to be used by more than one users in
their jobs for re-usability.

User1 logs in first, and loads 'Sample_Db_Connection' in DB2API stage in his Job A.
Then User2 logs in, wants to load 'Sample_Db_Connection' in DB2API stage in another job B, but its not getting loaded.

But when User1 closes his DS Designer session, the User2 is now able to load 'Sample_Db_Connection' in DB2API stage in job B.

Can't the same DB Connection be accessed by more than one user sessions in their jobs simultaneously?

Connectors are like shared containers - locked while open for editing, or even if potentially open for editing (that is, a job that uses them is open for editing).

Even after closing all the jobs which are using that DB connection, the problem persists. Only when the session is closed, the other user is able to load that DB Connection in his job.