| Author |
Message
|
| bcostacurta |
 Posted: Thu May 20, 2010 8:53 am Post subject: MQSeries internal persistence on Oracle database ? |
 |
|
Acolyte
Joined: 10 Dec 2009
Posts: 71
Location: Luxembourg
|
Dears,
in replacement of the default internal MQSeries filesystem for messages and queues persistence, is it possible to use directly an Oracle database ?
Platform is AIX
Thanks for attention.
Bye,
Bruno |
|
| Back to top |
|
 |
| fatherjack |
| Posted: Thu May 20, 2010 9:07 am Post subject: |
|
|
Knight
Joined: 14 Apr 2010
Posts: 522
Location: Craggy Island
|
Afraid not. Although IBM did talk about maybe using DB2, but that was about 10-12 years ago. Can't remember what happened other than it didn't!
_________________
Never let the facts get in the way of a good theory. |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu May 20, 2010 9:52 am Post subject: Re: MQSeries internal persistence on Oracle database ? |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| bcostacurta wrote: |
| in replacement of the default internal MQSeries filesystem for messages and queues persistence, is it possible to use directly an Oracle database ? |
No. It's the file system or nothing on any platform.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| bruce2359 |
| Posted: Thu May 20, 2010 10:07 am Post subject: |
|
|
Poobah
Joined: 05 Jan 2008
Posts: 9469
Location: US: west coast, almost. Otherwise, enroute.
|
And, for all platforms, messages are stored in a proprietary manner in the filesystem, and not easily readable by any traditional application.
_________________
I like deadlines. I like to wave as they pass by.
ב''ה
Lex Orandi, Lex Credendi, Lex Vivendi. As we Worship, So we Believe, So we Live. |
|
| Back to top |
|
|
| fatherjack |
| Posted: Thu May 20, 2010 10:27 am Post subject: |
|
|
Knight
Joined: 14 Apr 2010
Posts: 522
Location: Craggy Island
|
Any particular reason why you'd want to do it anyway?
_________________
Never let the facts get in the way of a good theory. |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu May 20, 2010 11:01 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| fatherjack wrote: |
| Any particular reason why you'd want to do it anyway? |
Reasons I've heard quoted include:
- Databases are more resiliant than filesystems
- We want to replicate the messages with database replication because <insert excuse>
- Doing a get by msg id will be faster
Clearly I have no insight into the OP's requirement, and I do not support or endorse any of the stupid justifications above.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| bcostacurta |
| Posted: Thu May 20, 2010 11:01 am Post subject: |
|
|
Acolyte
Joined: 10 Dec 2009
Posts: 71
Location: Luxembourg
|
Dears,
many thanks to all for your answers and clarifications.
@ fatherjack : no reason at all to replace MQseries internal filesystem. It was simply an unexpected question from a project client.
Bye,
Bruno |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu May 20, 2010 11:28 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| bcostacurta wrote: |
| It was simply an unexpected question from a project client. |
Same thing happens to me. 
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| exerk |
| Posted: Thu May 20, 2010 11:37 am Post subject: |
|
|
Jedi Council
Joined: 02 Nov 2006
Posts: 6339
|
| Vitor wrote: |
| bcostacurta wrote: |
| It was simply an unexpected question from a project client. |
Same thing happens to me. |
I tend to think of these as expected questions 
_________________
It's puzzling, I don't think I've ever seen anything quite like this before...and it's hard to soar like an eagle when you're surrounded by turkeys. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Thu May 20, 2010 11:41 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| exerk wrote: |
| Vitor wrote: |
| bcostacurta wrote: |
| It was simply an unexpected question from a project client. |
Same thing happens to me. |
I tend to think of these as expected questions |
It's really odd, too, since Vitor's chief weapon is fear. |
|
| Back to top |
|
|
| wschutz |
| Posted: Thu May 20, 2010 11:48 am Post subject: |
|
|
Jedi Knight
Joined: 02 Jun 2005
Posts: 3316
Location: IBM (retired)
|
| mqjeff wrote: |
| exerk wrote: |
| Vitor wrote: |
| bcostacurta wrote: |
| It was simply an unexpected question from a project client. |
Same thing happens to me. |
I tend to think of these as expected questions |
It's really odd, too, since Vitor's chief weapon is fear. |
...and surprise...
_________________
-wayne |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu May 20, 2010 11:53 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
Ok, my 2 principle weapons are fear and surprise. And ruthless efficientcy.
And the Python walks amongst us. 
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| exerk |
| Posted: Thu May 20, 2010 12:17 pm Post subject: |
|
|
Jedi Council
Joined: 02 Nov 2006
Posts: 6339
|
| Vitor wrote: |
Ok, my 2 principle weapons are fear and surprise. And ruthless efficientcy.
And the Python walks amongst us. |
Don't mention the...
...and nobody expects...
_________________
It's puzzling, I don't think I've ever seen anything quite like this before...and it's hard to soar like an eagle when you're surrounded by turkeys. |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu May 20, 2010 1:02 pm Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| exerk wrote: |
| ...and nobody expects... |
They never expect that!
This chair is alarmingly comfy. 
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| gbaddeley |
| Posted: Thu May 20, 2010 3:09 pm Post subject: |
|
|
Jedi Knight
Joined: 25 Mar 2003
Posts: 2538
Location: Melbourne, Australia
|
| Vitor wrote: |
Reasons I've heard quoted include:
- Databases are more resiliant than filesystems
- We want to replicate the messages with database replication because <insert excuse>
- Doing a get by msg id will be faster
|
I can imagine that over many versions of MQ the file structure for storing queued messages and recovery logging has been highly optimised for reliability and performance (including get by msgid). There is no point in allowing MQ to use an external DB, it would slow it down and decrease the reliability, as an extra link would be in the chain.
To be pedantic, DBs use filesystems to store their data too.
_________________
Glenn |
|
| Back to top |
|
|
|
|
