| Author |
Message
|
| wmb_wps_soa |
 Posted: Tue Nov 01, 2011 6:49 am Post subject: Can UUIDASCHAR be unique accross Brokers? |
 |
|
Acolyte
Joined: 19 Feb 2010
Posts: 65
Location: Detroit,Michigan,USA.
|
Hi,
We have two message broker running on two different hosts, one for Real Time flows and other one for Batch flows. Both realtime and Batch flows use some common tables and inserts the UUID's.
Now the problem is, if UUIDASCHAR is not unique across brokers, then our message flows would fail while inserting to the tables as UUID's are key to the tables.
If UUID generation process includes host/ip then UUID must be unique across brokers if they are running on different hosts.
But, can anyone confirm this? I want to make sure that brokers dont generate same UUID's at any time.
Thanks |
|
| Back to top |
|
 |
| fjb_saper |
| Posted: Tue Nov 01, 2011 6:57 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
What part of Universal Unique Identifier did you not understand?
If you need an affirmative statement open a PMR. 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| wmb_wps_soa |
| Posted: Tue Nov 01, 2011 7:00 am Post subject: |
|
|
Acolyte
Joined: 19 Feb 2010
Posts: 65
Location: Detroit,Michigan,USA.
|
| Can the UUID generated from UUIDASCHAR func be unique accross Brokers if brokers are running on different hosts? |
|
| Back to top |
|
|
| mqjeff |
| Posted: Tue Nov 01, 2011 7:12 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| wmb_wps_soa wrote: |
| Can the UUID generated from UUIDASCHAR func be unique accross Brokers if brokers are running on different hosts? |
How many possible values are there for a field of it's size and composition?
What information is used to populate and create it? Under what conditions are those properties going to repeat?
What range of timespan and location and what other criteria enter into your local definition of "unique". |
|
| Back to top |
|
|
| paintpot |
| Posted: Tue Nov 01, 2011 7:26 am Post subject: |
|
|
Centurion
Joined: 19 Sep 2005
Posts: 112
Location: UK
|
a more interesting question might be what algorithms IBM use in their implementation of UUID generation?
e.g. MQ messages (message id) start with the 'AMQ QM name'
Pure random UUIDs are almost never, ever going to clash - so you can rest easy and use them. |
|
| Back to top |
|
|
| Vitor |
| Posted: Tue Nov 01, 2011 7:58 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| wmb_wps_soa wrote: |
| Can the UUID generated from UUIDASCHAR func be unique accross Brokers if brokers are running on different hosts? |
You're really not getting behind this "Universal Unique" concept are you?
Clearly (as my most worthy associate points out) you're going to get a duplicate one day because you've used all the possible permutations. If that day is in your foreseeable future is something only you can calculate.
But (again as has been pointed out) if you want an answer you can use to validate your design you need a PMR and a statement from IBM. You're going to look pretty silly standing in front of whatever design review body you face & saying "this design will never result in duplicate id fields in the database because a bunch of anonomous, unaccoutable strangers on the Internet have assured me this can't happen".
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| wmb_wps_soa |
| Posted: Tue Nov 01, 2011 8:27 am Post subject: |
|
|
Acolyte
Joined: 19 Feb 2010
Posts: 65
Location: Detroit,Michigan,USA.
|
| I got the concept of universally unique identifiers Vitor. Thank you. |
|
| Back to top |
|
|
| paintpot |
| Posted: Tue Nov 01, 2011 8:29 am Post subject: |
|
|
Centurion
Joined: 19 Sep 2005
Posts: 112
Location: UK
|
| Vitor wrote: |
a bunch of anonomous, unaccoutable strangers on the Internet have assured me this can't happen". |
don't worry - trust us  |
|
| Back to top |
|
|
| Vitor |
| Posted: Tue Nov 01, 2011 8:51 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| paintpot wrote: |
| Vitor wrote: |
a bunch of anonomous, unaccoutable strangers on the Internet have assured me this can't happen". |
don't worry - trust us |
Even me? 
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
|
|
