IBM MQ Series Workflow for Sun Solaris w/ Oracle DB

[ckmcdonough]

The project that I am currently involved in requires changing our workflow database from DB2 to Oracle. The configuration that our team has decided to use is shown below. I included both MQSeries Workflow version 3.3.1 and 3.4 because we have not yet decided which of these we are going to use and also because version 3.4 is so new I don’t imagine that anyone has used it long enough to provide feedback. What I’m looking for
is information such as: success stories, installation tips, hints, warnings and possibly a source to go to if we run into installation problems. The most important information that I’m seeking is whether or not anyone has implemented this set up successfully. Any help that you can provide will be greatly appreciated.

Thank you in Advance,
Christine McDonough

Set up #1
MQSeries Workflow Server:
Hardware
- A Sun workstation with a SPARC processor
architecture as supported by Sun Solaris
- Main Memory : 512 MB (minimum)
- Hard Disk Space: 2 GB
Software
- Sun Solaris, Version 7 or Version 8 (32bit
mode ) Operating System
- MQSeries Server for SunSolaris 5.2
- MQSeries Workflow Server for SunSolaris v3.4
- Oracle Client 9i (v9.0.10.)

MQSeries Workflow Database Server:
Hardware
- A Sun workstation with a SPARC processor
architecture as supported by Sun Solaris
Software
- Sun Solaris, Version 7 or Version 8 ( 32 bit
mode) Operating System
- Oracle 9i (v9.0.10.) Workflow DataBase

MQSeries Workflow Client:
Hardware
- PC with an intel-based processor
- Hard Disk Space: 60 MB
Software
- Windows NT 4.0 Workstation Operating System
- MQseries client for WinNT 5.2 + CSD 5
- MQ Workflow client for WinNT 3.4
- Oracle Client 9i (v9.0.10.)
- VB 6.0 Application using Workflow Active X
API's

Set up #2

MQSeries Workflow Server:
Hardware
- A Sun workstation with a SPARC processor
architecture as supported by Sun Solaris
- Main Memory : 512 MB (minimum)
- Hard Disk Space: 2 GB
Software
- Sun Solaris, Version 7 or Version 8(32 bit
mode) Operating System
- MQSeries Server for SunSolaris 5.2
- MQSeries Workflow Server for SunSolaris
v3.3.1
- Oracle Client v8.1.7

MQSeries Workflow Database Server:
Hardware
- A Sun workstation with a SPARC processor
architecture as supported by Sun Solaris
Software
- Sun Solaris, Version 7 or Version 8
(32 bit mode ) Operating System
- Oracle v8.1.7 Database

MQSeries Workflow Client:
Hardware
- PC with an intel-based processor
- Hard Disk Space: 60 MB
Software
- Windows NT 4.0 Workstation Operating System
- MQ Series for Windows v 5.2 + CSD 5 Client
- MQ Workflow client for WinNT 3.4
- Oracle Client v8.1.7
- VB 6.0 Application using Workflow Active X
API's