| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| DB2 backup for MQSI |
« View previous topic :: View next topic » |
| Author |
Message
|
| WBI_user |
 Posted: Mon Dec 17, 2001 10:53 am Post subject: |
 |
|
Partisan
Joined: 07 Aug 2001
Posts: 386
|
Can some one share their experience on how you backup DB2 database for their MQSI environment ?
What we are doing in our WIN/NT development environment now is stop the broker and the configuration manager services. Use the DB2 control center to take the backup of the MR,CM and BK database. Then restart the services.
This is quite manual. We are looking for an automated way to do it at a regular interval (such as once a day in the evening).
We can always use a schedular to schedule the task to stop MQSI and start the backup job and then restart MQSI after the backup job is complete. This is just like automating keystrokes to enter comands.
Is there a better way to do this ?
Any suggestion ?
|
|
| Back to top |
|
 |
| artist |
| Posted: Tue Dec 18, 2001 4:22 am Post subject: |
|
|
Newbie
Joined: 06 Aug 2001
Posts: 5
|
Using UDB DB2, we take online backups so there is no need to take the service offline. If you do this, you must also make sure that logs are also kept.
|
|
| Back to top |
|
|
| WBI_user |
| Posted: Tue Dec 18, 2001 7:58 am Post subject: |
|
|
Partisan
Joined: 07 Aug 2001
Posts: 386
|
| Thanks, I am not a DB2 person. The DB2 setup for MQSI use is taking all defaults as suggested in the installation manual. I think that is the setup for minimal administration. Can you let me know if I have to make any change in the setup in order to take online backup and if those changes can be made without affecting the current MQSI databases? (i.e. Do we having to drop and recreate ?) |
|
| Back to top |
|
|
| camenzind |
| Posted: Wed Jan 09, 2002 1:03 am Post subject: |
|
|
Novice
Joined: 13 Sep 2001
Posts: 10
|
| In the DB2 control center you can define jobs, which take backups automatically based on your needs, e.g. daily. If you don't have an infrastructure specifically for backups this is an easy way to issue DB backups on a regular basis. Within control center go to tools and than to journal. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
