Open topic with navigation

TIBCO iProcess® Engine 11.10.0

# Example

Suppose that the volume of messages handled by your system has increased significantly, and the default message queues can no longer cope. To deal with the additional load you have decided that you need to add a new `BGMBOX3` message queue to the `BGMBSET` Mboxset. This queue requires a new SQL database queue table `sw_db_bgqueue_3`. You store your database queue tables in the default iProcess database.

To do this:

| 1. | Connect to the SQL Server that holds the iProcess database.

| 2. | Create a new table in the iProcess database called `sw_db_bgqueue_3`.

For example:

go

    create table swpro.sw_db_bgqueue_3
    (
    rowid				NUMERIC(15)			identity(1,1),
    last_failed			NUMERIC(10)			NULL,
    failure_count			INTEGER				NOT NULL,
    last_failed			NUMERIC(10)			NULL,
    failure_count			INTEGER				NOT NULL,
    msg_id				uniqueidentifier		NOT NULL,
    msg_hdr				VARCHAR(512)			NULL,
    msg_data			VARCHAR(1024)			NOT NULL
    );

go

grant references, select, insert, delete, update on

swpro.sw_db_bgqueue_3 to swpro,swuser

go

create clustered index idx_sw_db_bgqueue_3 on swpro.sw_db_bgqueue_3 (rowid);

| 3. | Use the `SWDIR``\util\swadm` utility to add a new message queue called `BGMBOX3`, which uses the `sw_db_bgqueue_3` queue table.

    cd SWDIR\util
    swadm ADD_QUEUE BGMBOX3 Local 0003:swpro.sw_db_bgqueue_3

| 4. | Add the `BGMBOX3` queue to the `BGMBSET` Mbox set.

    swadm ADD_QUEUE_TO_MBOXSET 1 8

`1` is the number of the `BGMBSET` Mboxset (from the `swadm` `SHOW_MBOXSETS` command), and `8` is the number of the message queue (from the `swadm` `SHOW_QUEUES` command).

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO iProcess® Engine