MSGSTORE

This table holds the messages stored as a result of using a transacted send. Temporary storage space only.

Column Descriptions:

Name	Type	Description
MSGID	BIGINT NOT NULL	ID number uniquely identifying the message.
MESSAGEINDEX	INTEGER NOT NULL	Index number indicating which segment of the stored message this record represents.
MESSAGE	BLOB (1000000)	Represents a segment of the stored message.
MSGDATECREATED	TIMESTAMP	The timestamp when the message was created.
RETRIES	INTEGER	Number of retries remaining for this message before send is abandoned.
EXPIRY	TIMESTAMP	Expiry timestamp for stopping retrying to send the message (applicable to e-mail retry only).
TRANSPORT_ID	INTEGER NOT NULL	Transport ID for the transport from which this message is being sent.
STOREENT_ID	INTEGER NOT NULL	Store ID for the store from which this message originated.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	MSGID+MESSAGEINDEX+TRANSPORT_ID	Primary Key
I0000624	STOREENT_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_1024	TRANSPORT_ID	TRANSPORT	TRANSPORT_ID	Cascade
F_1025	STOREENT_ID	STOREENT	STOREENT_ID	Cascade

Related reference
Messaging data model