| Author |
Message
|
| petermc |
 Posted: Wed Dec 04, 2002 6:42 am Post subject: Multiple MQ Workflow servers talking to single Runtime Datab |
 |
|
Newbie
Joined: 04 Dec 2002
Posts: 2
Location: Dublin, Ireland
|
Hi
firstly - I'm an Oracle DBA - so forgive me 
we are building multiple MQ WF servers - and each time we build one - we have to create a new database .... 
we are on AIX (5.1) using WF 3.3.2 and using the 'fmczutil' to build the servers
Currently we have 6 servers and 6 databases - one each....not nice.
(each database has a different schema name for the corresponding WF servers)
So I have two questions....
1. - if I migrate the WF schema from one database to another (using DB utilities) how/where do I reconfigure the WF server with the new DB information
2. - when creating a new WF server - how can I specify to use an existsing database - but use a different database schema name....when 'building' the runtime database
Many thanks in advance
P |
|
| Back to top |
|
 |
| Ratan |
| Posted: Wed Dec 04, 2002 8:44 am Post subject: |
|
|
Grand Master
Joined: 18 Jul 2002
Posts: 1245
|
I dont understand you completely, but my 2 cents: If you want all your worflow servers under the same group, you have to use a single runtime database.
-Laze |
|
| Back to top |
|
|
| jet |
| Posted: Wed Dec 04, 2002 12:34 pm Post subject: |
|
|
Apprentice
Joined: 04 Dec 2002
Posts: 49
Location: New York
|
| well. why 6 servers? 2 for development, 2 for testing/staging and 2 for production? |
|
| Back to top |
|
|
| petermc |
| Posted: Thu Dec 05, 2002 12:35 am Post subject: |
|
|
Newbie
Joined: 04 Dec 2002
Posts: 2
Location: Dublin, Ireland
|
Sorry about this - but I have very little understanding of WF....and it is not my call on how it it organised...so here is what I know
we have 1 WF Serever, 6 WF groups and 6 WF runtime databases.....one per WF group I guess....and I want 1 databases for ALL WF groups....
.
.
why all the WF groups....different phases of different projetcs....dev/test etc. Production is else where - but we will hit this same problem when some of these new projects hit production.
Hope this helps clear it up a bit |
|
| Back to top |
|
|
| jmac |
| Posted: Thu Dec 05, 2002 5:54 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
Peter:
The Database is configured at the SystemGroup level. SO, if you want all of your systems to share the same db, you first add the "Primary" system, then configure the other 5 to point to the same SystemGroup and thus RT db.
Note that each system will require its own queue manager.
GOOD LUCK
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| jet |
| Posted: Thu Dec 05, 2002 6:41 am Post subject: |
|
|
Apprentice
Joined: 04 Dec 2002
Posts: 49
Location: New York
|
different projects...hmmm...If their process models are different, u can just use same instance for the runtime DB....but u have to define the process models right....so project A using process model category 1, and cant access category 2 which is for project B...etc...
If u r talking about same process model....but u wanna to different environments such as development and testing...then u better to have different DB intances for each runtime databases...meaning, u need 2 databases......
Hope this help |
|
| Back to top |
|
|
|
|
