Open topic with navigation

TIBCO iProcess® Engine 11.10.0

# Creating Additional SQL Database Queue Tables

If you decide to add an additional message queue to your system, you need to:

| 1. | manually create the database queue table needed to hold the new message queue.

| 2. | create the new message queue and map the database queue table to it (using the `SWDIR``\bin\swadm` utility).

| 3. | add the message queue to the appropriate Mbox set (using the `SWDIR``\bin\swadm` utility).

Each individual message queue must be held in its own database queue table.

Each database queue table must have the following characteristics:

| • | the same column definitions as a sw_db_bgqueue_n, sw_db_wisqueue_n, or sw_db_predictqueue_n table. (Each of these tables has the same structure.)

| • | no primary key.

| • | a clustered index on the `row_id` column.

| • | the iProcess background user (default `swpro`) must have at least `insert`, `select` and `delete` permissions on the table.

| • | the iProcess foreground user (default `swuser`) must have at least `insert` permissions on the table.

Warning | If a table that does not conform to these requirements is used as a message queue, messages cannot be enqueued to or dequeued from that queue, and the iProcess Engine may not function correctly.

Subtopics

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