| Author |
Message
|
| amkush |
 Posted: Fri Mar 11, 2005 1:57 am Post subject: WMQI Broker DB... (Licencing) |
 |
|
Newbie
Joined: 09 Dec 2004
Posts: 5
|
Hi All,
A query, which is a bit non technical. We have a requirement for generating unique numbers. So we thought of using a sequence on the brokers DB. Its not the ideal thing to do, but, any idea if there is any licencing concern with this in relation to creating an application object in the brokers DB? Also, if there is any other workaround?
Thanks,
Amit |
|
| Back to top |
|
 |
| JT |
| Posted: Fri Mar 11, 2005 6:42 am Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
I didn't think you could, but you may want to review the DB2 license agreement to be sure.
An alternative for generating a unique identifier is the UUIDASBLOB or UUIDASCHAR functions. I believe it was available in v2.1.
| Quote: |
UUIDASBLOB or UUIDASBLOB(source_character_uuid)
The first form of the UUIDASBLOB function creates a new universally unique identifier (UUID) and returns it as a BLOB. The second form converts an existing character UUID in the dddddddd_dddd_dddd_dddd_dddddddddddd to the BLOB form. An exception is thrown if the parameter is not of the expected form.
|
|
|
| Back to top |
|
|
| shrek |
| Posted: Sun Mar 13, 2005 11:10 am Post subject: |
|
|
Acolyte
Joined: 19 Feb 2005
Posts: 61
Location: Gudivada,India
|
I am not sure why you want to use the Broker DB for your application. We had similar requirement and we are generating the unique number in an application database.
I believe its not advisable to use the Broker DB for such puposes.
Thanks |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Sun Mar 13, 2005 12:22 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
I think amkush doesn't want to use the Broker DB, just the broker DB2, to host an application database.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| amkush |
| Posted: Mon Mar 14, 2005 3:53 am Post subject: |
|
|
Newbie
Joined: 09 Dec 2004
Posts: 5
|
Yes, Jeff, you are right. Can you create a separate logical schema on the broker database?
The requirement has forced us to use a sequence on the DB2 database. And we used the one available which was the broker one (unfortunately?). The requirement has to do with generating unique 15 digits numbers. We tried doing some math using the CURRENT_TIMESTAMP function. But later ran into some problems with it ( remains the same value once you enter the node ). Any other suggestions for generating unique numbers? Much appreciated.
Thanks,
Amit |
|
| Back to top |
|
|
| vmcgloin |
| Posted: Mon Mar 14, 2005 4:36 am Post subject: |
|
|
Knight
Joined: 04 Apr 2002
Posts: 560
Location: Scotland
|
As the first reply said, review the license agreement. Check the license folder under the WMQI install. In particular:
| Quote: |
| You are authorized to use DB2 only for the storage and management of data generated by the Program, and not for other data management purposes, specifically excluding use for application data. To use DB2 for other purposes, you must acquire a separate nonrestricted Proof of Entitlement for a DB2 Universal Database software product which authorizes such use. |
|
|
| Back to top |
|
|
| JT |
| Posted: Mon Mar 14, 2005 6:12 am Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
| Quote: |
| Any other suggestions for generating unique numbers? Much appreciated |
| Quote: |
An alternative for generating a unique identifier is the UUIDASBLOB or UUIDASCHAR functions. I believe it was available in v2.1.
| Quote: |
]b]UUIDASBLOB][/b] or UUIDASBLOB(source_character_uuid)
The first form of the UUIDASBLOB function creates a new universally unique identifier (UUID) and returns it as a BLOB. The second form converts an existing character UUID in the dddddddd_dddd_dddd_dddd_dddddddddddd to the BLOB form. An exception is thrown if the parameter is not of the expected form. |
|
|
|
| Back to top |
|
|
|
|
