ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum IndexWebSphere Message Broker SupportA single DSN versus multiple DSN's for a single SOR

Post new topicReply to topic
A single DSN versus multiple DSN's for a single SOR View previous topic :: View next topic
Author Message
aspre1b
PostPosted: Wed Jan 31, 2018 1:28 am Post subject: A single DSN versus multiple DSN's for a single SOR Reply with quote

Voyager

Joined: 05 Jul 2007
Posts: 76
Location: Coventry, UK

I'm just looking to get people's view on the use of DSN's for accessing system of records.

Would anyone advocate having different DSN's for a single database schema that is accessed through multiple execution groups. For example each DSN would utilise a separate DB user. The benefit I see is that from a database point of view, there is an audit of which users are accessing the tables, and thus can be traced back to an execution group (and thus a project/channel/application).

It's not a perfect solution, as a DSN set up on a broker instance, is accessible to all execution groups. This would mean it would be down to peer review to make sure the correct DSN is used.

The datasource in question, is the primary system of record, and not a local broker database.

Going a step further, any views on having a different DSN for Create/Update operations, versus Read operations. This has been mooted for message flows that perform payment transactions.

I'd be interested to learn how DSN's have been set up at other companies?

If the datasource in question was owned by the broker (e.g. exception table), then I would expect a single DSN, as it is typically accessed via standard exception handling flow.
Back to top
View user's profile Send private message
abhi_thri
PostPosted: Fri Feb 02, 2018 6:45 am Post subject: Reply with quote

Disciple

Joined: 17 Jul 2017
Posts: 196
Location: UK

I don't think it is good idea to have multiple DSNs just for the sake of it, as you mentioned it would be hard to police as flows across the estate (within the same or diff EGs) will have access to it. Also you need to be wary about the maintenance overhead when no. of EGs increases in future.

Having that said I've seen cases whether a separate DSN was used (a DB polling flow had to meet some specific throughput criteria and the DB admin preferred a new user id to keep track of things).

Also have seen the case of a read only DB user id used to access a reference database owned by a separate app.

So a separate DSN may prove useful in certain scenarios but using a blanket rule of DSN per EG may prove troublesome in the longer run.

PS: If the no. of active DB threads is a concern you should be looking at caching DB entries where possible (eg:- most of the read scenarios involving static data could be cached)
Back to top
View user's profile Send private message
Display posts from previous:
Post new topicReply to topic Page 1 of 1

MQSeries.net Forum IndexWebSphere Message Broker SupportA single DSN versus multiple DSN's for a single SOR
Jump to:



You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Protected by Anti-Spam ACP


Theme by Dustin Baccetti
Powered by phpBB 2001, 2002 phpBB Group

Copyright MQSeries.net. All rights reserved.