Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 3 Mbox Sets and Message Queues : mbox_set

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.
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.)
BGMBOX1, BGMBOX2
WISMBOX1, WISMBOX2
PREDICTMBOX1, PREDICTMBOX2
Primary Key
The following primary key is defined for this table.
Triggers
The following DELETE CASCADE trigger is defined for this table.
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.

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved