| Author |
Message
|
| krisrock |
 Posted: Wed Nov 07, 2007 6:34 am Post subject: Oracle for persistance with MQ |
 |
|
Acolyte
Joined: 11 Sep 2007
Posts: 65
|
Can we use Oracle for persistance with MQ?
If we can use, what are the complications and problems.
If we cannot use, what is the reason?
thanks
Rakesh |
|
| Back to top |
|
 |
| George Carey |
| Posted: Wed Nov 07, 2007 7:45 am Post subject: Huh? |
|
|
Knight
Joined: 29 Jan 2007
Posts: 500
Location: DC
|
What exactly do you mean use Oracle for persistence with MQ.
Am using MQ as wider overall infrastruture transport but have some Oracle apps that use Oracle AQ ... and have some ideas in this space but ... don't understand your question? Can you articulate more precisely what it is you are trying/wanting to do..
_________________
"Truth is ... grasping the virtually unconditioned",
Bernard F. Lonergan S.J.
(from book titled "Insight" subtitled "A Study of Human Understanding") |
|
| Back to top |
|
|
| George Carey |
| Posted: Wed Nov 07, 2007 7:47 am Post subject: nevermind |
|
|
Knight
Joined: 29 Jan 2007
Posts: 500
Location: DC
|
dupped this by mistake ...
_________________
"Truth is ... grasping the virtually unconditioned",
Bernard F. Lonergan S.J.
(from book titled "Insight" subtitled "A Study of Human Understanding")
Last edited by George Carey on Wed Nov 07, 2007 8:04 am; edited 2 times in total |
|
| Back to top |
|
|
| ashoon |
| Posted: Wed Nov 07, 2007 7:54 am Post subject: Re: Oracle for persistance with MQ |
|
|
Master
Joined: 26 Oct 2004
Posts: 235
|
MQ uses a filesystem for persistence therefore you can't use an Oracle DB... WAS JMS messaging engine (or SIBus) uses a database for persistence and I believe it can be an Oracle DB.
| krisrock wrote: |
Can we use Oracle for persistance with MQ?
If we can use, what are the complications and problems.
If we cannot use, what is the reason?
thanks
Rakesh |
_________________
IBM Certified - SOA Solution Designer & WebSphere Datapower SOA Appliances |
|
| Back to top |
|
|
| George Carey |
| Posted: Wed Nov 07, 2007 8:10 am Post subject: correct wording?? |
|
|
Knight
Joined: 29 Jan 2007
Posts: 500
Location: DC
|
Wouldn't the question for that be worded:
| Quote: |
| Can I use Oracle for persistence for WAS messaging ? |
Though precise wording is the bane of this industry!
_________________
"Truth is ... grasping the virtually unconditioned",
Bernard F. Lonergan S.J.
(from book titled "Insight" subtitled "A Study of Human Understanding") |
|
| Back to top |
|
|
| krisrock |
| Posted: Wed Nov 07, 2007 8:10 am Post subject: |
|
|
Acolyte
Joined: 11 Sep 2007
Posts: 65
|
| Can this file system be on Oracle DB? |
|
| Back to top |
|
|
| George Carey |
| Posted: Wed Nov 07, 2007 8:13 am Post subject: yeah |
|
|
Knight
Joined: 29 Jan 2007
Posts: 500
Location: DC
|
Ooookk!!! Got to go!
_________________
"Truth is ... grasping the virtually unconditioned",
Bernard F. Lonergan S.J.
(from book titled "Insight" subtitled "A Study of Human Understanding") |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed Nov 07, 2007 8:22 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
| krisrock wrote: |
| Can this file system be on Oracle DB? |
NO.
Guess what, though...
Oracle uses the file system for it's persistence.
So MQ is just the same!
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| krisrock |
| Posted: Wed Nov 07, 2007 8:24 am Post subject: |
|
|
Acolyte
Joined: 11 Sep 2007
Posts: 65
|
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed Nov 07, 2007 8:58 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Oracle stores all Database data in files on the file system on the Oracle server.
MQ stores all Message data in files on the file system on the MQ server.
Oracle uses log files on the file system on the Oracle server to ensure that data is persisted correctly, and not lost when it shouldn't be. As well to manage transactions.
MQ uses log files on the file system on the MQ server to ensure that data is persisted correctly and not lost when it shouldn't be. As well, to manage transactions.
So MQ and Oracle do the same things to solve the same problem. So there's no need to use Oracle for persistence for MQ.
By the way - your question about storing a "file system" on a "database server" shows that you either don't understand databases AND file systems very well... or that you aren't spending the time to think about it much. It's not a question that makes any real sense, honestly.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| bruce2359 |
| Posted: Wed Nov 07, 2007 10:01 am Post subject: |
|
|
Guest
|
I read the original post to mean: Is there an MQ installation option that allows MQ messages to be stored in a DB instead of the default filesystem method.
If that's the question, then no. |
|
| Back to top |
|
|
| JosephGramig |
| Posted: Wed Nov 07, 2007 11:22 am Post subject: |
|
|
Grand Master
Joined: 09 Feb 2006
Posts: 1244
Location: Gold Coast of Florida, USA
|
Not at all. If you are on System Z, then of course you can store all of the messages in a Database instead of directly to a file.
It is called a Queue Sharing Group and it is the highest level of availability you can get. Of course, it only works for DB2 and MQ on z/OS LPARs.
But, in the end the mechanisms to save the data are all the same.
_________________
Joseph
Administrator - IBM WebSphere MQ (WMQ) V6.0, IBM WebSphere Message Broker (WMB) V6.1 & V6.0
Solution Designer - WMQ V6.0
Solution Developer - WMB V6.1 & V6.0, WMQ V5.3 |
|
| Back to top |
|
|
| bruce2359 |
| Posted: Wed Nov 07, 2007 11:34 am Post subject: |
|
|
Guest
|
| Quote: |
| If you are on System Z, then of course you can store all of the messages in a Database instead of directly to a file. |
Messages in a Queue Sharing Group are propagated into coupling facility list structures; they are not stored in a database. Shared object definitions are stored in a DB2 shared database in the CF. |
|
| Back to top |
|
|
| JosephGramig |
| Posted: Wed Nov 07, 2007 12:03 pm Post subject: |
|
|
Grand Master
Joined: 09 Feb 2006
Posts: 1244
Location: Gold Coast of Florida, USA
|
I stand corrected. Not for the last time, I'm sure.
_________________
Joseph
Administrator - IBM WebSphere MQ (WMQ) V6.0, IBM WebSphere Message Broker (WMB) V6.1 & V6.0
Solution Designer - WMQ V6.0
Solution Developer - WMB V6.1 & V6.0, WMQ V5.3 |
|
| Back to top |
|
|
| PeterPotkay |
| Posted: Wed Nov 07, 2007 12:48 pm Post subject: |
|
|
Poobah
Joined: 15 May 2001
Posts: 7722
|
You're both right apparently.
Where are Shared Q messages held?
| Quote: |
Messages that are put onto shared queues are not stored on page sets and do not use buffer pools.
The messages in shared queues have entries on list structures in the zSeries Coupling Facility. Many queue managers in the same sysplex can access those messages.
Shared queue messages of size less than or equal to 63KB are held entirely in the CF list structure defined for that queue.
Shared queue messages of size greater than 63KB have their message data held as one or more binary large objects (BLOBs) in a DB2 table which is shared by a DB2 data sharing group.
|
_________________
Peter Potkay
Keep Calm and MQ On |
|
| Back to top |
|
|
|
|
