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 |
|
 |
|