| Author |
Message
|
| Mark |
 Posted: Thu Sep 19, 2002 6:40 am Post subject: Changing RunTime DB |
 |
|
Acolyte
Joined: 30 Dec 2001
Posts: 55
|
Hi All,
Is there any way to change the RunTime DB in a WorkFlow Configuration automatically in case of RunTime DB Failure.
The requirement is like that.
I have a WorkFlow System in production & if the Runtime DB fails.
If I keep a Backup of Runtime DB , How can I switch FMC Configuration
to use the BackUp DB Automatically/Programmaticaly.
If there is some better way of doing this Kindly suggest ....
Thnx in Advance
Mark |
|
| Back to top |
|
 |
| jmac |
| Posted: Thu Sep 19, 2002 7:15 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
Mark:
There is one thing that could be done, but I don't think this is what you want. You could put in another configuration and point to that backup DB. Also there is a pointer in the RTDB in the profile variables (kept in the Registry on NT). I have never messed with this, and if you did it might not be supported by IBM, but you might consider playing with this also.
Please post your results.
Thanks and GOOD LUCK
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| Ratan |
| Posted: Thu Sep 19, 2002 8:17 am Post subject: |
|
|
Grand Master
Joined: 18 Jul 2002
Posts: 1245
|
| Quote: |
Is there any way to change the RunTime DB in a WorkFlow Configuration automatically in case of RunTime DB Failure.
|
This depends on the Operating system your workflow is running on, to ensure High availability you can use the OS clustering features. In Windows2000/NT you have Windows Cluster Server ( In AIX we use HACMP, I dont know much about it).
You can have two database servers in these cluster and because all the resources ( IP address, Host Name,....) are shared betweent the systems in a cluster, when the primary DB2 server goes down the OS brings up the secondary and you dont have to change anything because IPaddress is the same.
I think the requirement is both the DB2 servers should point to the same SAN drive.
-Laze |
|
| Back to top |
|
|
| jmac |
| Posted: Thu Sep 19, 2002 8:25 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
Laze is definitely right about using HACMP on AIX and there are equivalents on Solaris also. I don't know if there is anything supported on windows for high-availability or not. But this is definitely the proper route to follow.
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| Mark |
| Posted: Tue Sep 24, 2002 2:10 pm Post subject: |
|
|
Acolyte
Joined: 30 Dec 2001
Posts: 55
|
Thnx For Reply.
I would like to tell abt the setup I am having.
It is MQWF 3.3 on AIX .
We have got many DB like WAS , LDAP , MQWF RUNTIME in a single
UDB.Different Application access these DataBases. Out of alll these DB if MQWF RunTime DB fails .In such case is it possible that MQWF Server AUTOMATICALLY points to other MQWF RunTime which is in Other UDB ??
Will HACMP help for this scenerio.
Thnx for Help |
|
| Back to top |
|
|
| kriersd |
| Posted: Tue Oct 08, 2002 6:15 pm Post subject: |
|
|
Master
Joined: 22 Jul 2002
Posts: 209
Location: IA, USA
|
HACMP works great for AIX.
If your running on Win2000 Advanced server  you can take advantage of the advanced clustering by Microsoft, I believe that works also.
HACMP does take a bit of time setting up the configuration, however, it's worth the trouble.
_________________
Dave Krier
IBM WebSphere MQ Workflow V3.4 Solution Designer |
|
| Back to top |
|
|
|
|
