When trying to do a DB backup (non Pub/Sub) it turned out to be too much trouble since we have the process of recreating the broker down to only a few minutes. Actually it seemed to cause more problems in the event we did have a problem with the server. I think it's best just to take good backups of the CM and MRM so you can always recover no matter what...it only takes a few minutes.
However, for disaster recovery we actually use EMC to take snapshots of all the disks /var/mqm, /var/mqsi and DB2 then bring the disks up on a server in a DR site. This works VERY well, all we have to do is issue the start commands once the disks are mounted. Brian M. McCarty USAA, Senior Systems Programmer 210.913.1678 MQ/WMQI Specialist/Solutions Expert e-business Solution Advisor/Designer/Technologist -----Original Message----- From: Robert Broderick [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 10, 2003 9:29 AM To: [EMAIL PROTECTED] Subject: Re: Any point backing up broker DB? PUB/SUB is right. I thought there was something else. I cannot remember it right now OR I am wrong. Gary W??? You mentioned this to me back a couple of months when we were doing the XA stuff?? Any input?? bobbee >From: Paul Meekin <[EMAIL PROTECTED]> >Reply-To: MQSeries List <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Subject: Any point backing up broker DB? >Date: Tue, 10 Jun 2003 14:08:14 +0100 > >Couldn't find this on a search of the list which surprised me. > >The WMQI 2.1 Admin Guide recommends backing up a specific set of tables in >the >broker database to be used to restore in case of breakage. I understand >that >Publication and subscription data is stored there in this DB but, if I'm >not >using PubSub applications is there any point in doing this? > >In case of DB problems, can I not simply create a new DB, mqsicreatebroker >to >recreate the Broker and then do a full deploy from Control Centre? > >Will I lose anything else in this scenario? I realise that the ConfigMgr >and >MsgRepository DBs need a full backup regardless. > >Cheers, >Paul > > > > >******************************************************************************************************** >This e-mail is from Energis Communications Ltd, 185 Park Street, London, >SE1 9DY, United Kingdom, No: 2630471. > >This e-mail is confidential to the addressee and may be privileged. The >views >expressed are personal and do not necessarily reflect those of Energis. If >you are not the intended recipient please notify the sender immediately by >calling our switchboard on +44 (0) 20 7206 5555 and do not disclose to >another person or use, copy or forward all or any of it in any form. > >******************************************************************************************************** > >Instructions for managing your mailing list subscription are provided in >the Listserv General Users Guide available at http://www.lsoft.com >Archive: http://vm.akh-wien.ac.at/MQSeries.archive _________________________________________________________________ The new MSN 8: smart spam protection and 2 months FREE* http://join.msn.com/?page=features/junkmail Instructions for managing your mailing list subscription are provided in the Listserv General Users Guide available at http://www.lsoft.com Archive: http://vm.akh-wien.ac.at/MQSeries.archive Instructions for managing your mailing list subscription are provided in the Listserv General Users Guide available at http://www.lsoft.com Archive: http://vm.akh-wien.ac.at/MQSeries.archive
