Open topic with navigation

TIBCO iProcess® Engine 11.10.0

# mbox_set

The `mbox_set` table defines the list of Mbox sets that are available on this iProcess Engine node.

## Structure

The `mbox_set` table has the following structure:

    TABLE mbox_set (
    	mbox_set_id	 INTEGER		NOT NULL,
    	mbox_set_name	 VARCHAR(32)		NOT NULL,
    	mbox_set_msgtype SMALLINT		NOT NULL)

Each row provides the following information about a Mbox set.

Column | Description
`mbox_set_id` | Unique identifier for this Mbox set.
`mbox_set_name` | Name of this Mbox set.
`mbox_set_msgtype` | Message type used by this Mbox set. This value is always `1`, for local messages.

## Default Mbox Sets and Message Queues

When the iProcess Engine is installed, the `init2Ksql.sql` script creates the following default Mbox sets that are required by the system. (The mbox_set_group table defines which message queues are stored in which Mbox set.)

Mbox Set | Contains these message queues
`BGMBSET` | `BGMBOX1`, `BGMBOX2`
`WMDMBSET` | `WISMBOX1`, `WISMBOX2`
`PREDICTMBSET` | `PREDICTMBOX1`, `PREDICTMBOX2`

## Primary Key

The following primary key is defined for this table.

Key Name | Column(s)
`pk_mbox_set` | `mbox_set_id`

## Triggers

The following `DELETE CASCADE` trigger is defined for this table.

Trigger Name | Triggered by | Affects Table(s)
`tr_mbox_set` | `DELETE` | `mbox_set_group`

## Indexes

None.

## Table Activity

The `mbox_set` table contains one row for each Mbox set that is available on this iProcess Engine node.

Rows are added, updated and deleted in the following situations.

A row is... | When...
added | a new Mbox set is added to the node, either at installation or by using the `SWDIR``\util\swadm` utility.
updated | an Mbox set’s details are updated, using the `SWDIR``\util\swadm` utility.
deleted | an Mbox set is deleted from the node, using the `SWDIR``\util\swadm` utility.

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