| Author |
Message
|
| klabran |
 Posted: Fri Aug 13, 2004 6:40 am Post subject: Backup/restore messages in queue |
 |
|
Master
Joined: 19 Feb 2004
Posts: 259
Location: Flagstaff AZ
|
I am using mq 5.3 and mqsi 2.1.
I am wondering if there is a backup/restore process for messages on a queue. Another words, I have db backups occuring for mqsi's db2 database, I have the queue definitions being backed up and I even am backing up the control center user files.
However, if I have messages on a queue and we have a fatal server issue my messages in this setup would be unrecoverable. Is there some kind of backup/restore for queues in mq 5.3, add-on, third-party, etc... to do this or do I just need to create mqsi flows that copy every message coming through my system to a database to ensure no message will ever be lost.
Thanks for your assistance,
Kevin |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Fri Aug 13, 2004 6:55 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Make your messages persistent.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| klabran |
| Posted: Fri Aug 13, 2004 7:11 am Post subject: |
|
|
Master
Joined: 19 Feb 2004
Posts: 259
Location: Flagstaff AZ
|
They are persistent.... I am refering to a situation like losing two drives in a raid 5 configuration. Goodbye server. Hello rebuild. In this situation my messages are unrecoverable unless I have some offsite storage like I do for my db2, control center files, and queue definition files.
Kevin |
|
| Back to top |
|
|
| Lisa |
| Posted: Fri Aug 13, 2004 7:18 am Post subject: Logging |
|
|
Master
Joined: 07 Jun 2002
Posts: 287
Location: NJ
|
Are you trying to log the messages before they arrive on the WMQI queue? We audit/log all of our messages before they hit WMQI. If there
is a problem, we can always go to our log files, retrieve the message(s) and replay them.
Hope this helps,
Lisa |
|
| Back to top |
|
|
| klabran |
| Posted: Fri Aug 13, 2004 7:21 am Post subject: |
|
|
Master
Joined: 19 Feb 2004
Posts: 259
Location: Flagstaff AZ
|
That's sounds close... If we could backup these logs offsite then we could reconstruct no matter what occurs. How do these logs work?
Currently what we do is archive every message to a database in order to ensure we can reconstruct if necessary but obviously this is not the easiest technique for reconstruction. It suites our needs well for audit reporting but I was looking for what others are doing.
Kevin |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Fri Aug 13, 2004 7:23 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
If your messages are persistent, and you are trying to achieve queue manager backup and restore... then follow normal backup and restore procedures for queue managers...
WMQI/WBIMB is really just a WebSphere MQ application. It doesn't really make special use of MQ in ways that normal applications don't (as far as I know... people who've seen or written the source code *might* disagree, but I hope not.)
There is a section in the System Admiinistration guide that talks about backup and recovery of queue managers.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| klabran |
| Posted: Fri Aug 13, 2004 7:31 am Post subject: |
|
|
Master
Joined: 19 Feb 2004
Posts: 259
Location: Flagstaff AZ
|
|
| Back to top |
|
|
| Lisa |
| Posted: Fri Aug 13, 2004 7:45 am Post subject: Logging |
|
|
Master
Joined: 07 Jun 2002
Posts: 287
Location: NJ
|
We have a mainframe application that receives audit/log formatted records. This application then writes each message to a DB2 table.
Please note that this is our in-house solution for our audit department.
Lisa |
|
| Back to top |
|
|
| klabran |
| Posted: Fri Aug 13, 2004 7:53 am Post subject: |
|
|
Master
Joined: 19 Feb 2004
Posts: 259
Location: Flagstaff AZ
|
Lisa,
we are considering something similar.
Kevin |
|
| Back to top |
|
|
|
|
