MSGSTORE

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

Column Descriptions:

NameTypeDescription
MSGIDBIGINT NOT NULLID number uniquely identifying the message.
MESSAGEINDEXINTEGER NOT NULLIndex number indicating which segment of the stored message this record represents.
MESSAGEBLOB (1000000)Represents a segment of the stored message.
MSGDATECREATED TIMESTAMP Customizable.
RETRIESINTEGERNumber of retries remaining for this message before send is abandoned.
EXPIRYTIMESTAMPExpiry timestamp for stopping retrying to send the message (applicable to e-mail retry only).
TRANSPORT_IDINTEGER NOT NULLTransport ID for the transport from which this message is being sent.
STOREENT_IDINTEGER NOT NULLStore ID for the store from which this message originated.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>MSGID+MESSAGEINDEX+TRANSPORT_IDPrimary Key
I0000624STOREENT_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1024TRANSPORT_IDTRANSPORTTRANSPORT_IDCascade
F_1025STOREENT_IDSTOREENTSTOREENT_IDCascade