Please carry out the following instructions for the IBM MQ
Workflow database (The Event Queue Database):
- In the Database Name text
box, enter the MQ Workflow database name (or the database URL).
- If you are using Oracle database
server, then type the following for the Monitor database URL:
jdbc:oracle:thin:@<Oracle_Server_Name>:<Oracle_Server_Port_Number>:FMCDB
Where <Oracle_Server_Name> is the name or the IP address of
the Oracle Database Server machine, and <Oracle_Server_Port_Number> is
the Oracle Server Port Number (the default port is 1521).
- In the
User Name and
Password text boxes,
enter the user name and password of the MQSeries Workflow database
administrator.
- In the
Schema text box, enter
the MQSeries database schema (The default value is FMC).
- In Oracle Database, the Event
Queue Database schema must be the same as the Database Administrator's User
Name.
- In the MQ Workflow Connector
Queue section type the TableSpaces names for each of the following groups:
Tables, Indexes, and Large Objects (LOBs). You
can specify a different TableSpace name for each of these three fields.
Alternatively, you can specify the same TableSpace for more than one field,
and in this case these groups of tables and/or indexes will use the same
TableSpace for storing the data physically on the hard drive.
If you leave a blank field with no TableSpace name specified, then the
default TableSpace will be used for the corresponding group of tables or
indexes.
The specified TableSpace should have been previously created in the Database
server. Otherwise, the deployment will not be performed properly and you
will not be able to create the database tables.
Click Next to continue.