MSGARCHIVE

This table holds the messages sent as a result of using a transacted send when the corresponding message type has Archive message after sent flag turned on (during message type to transport assignment).

Column Descriptions:

NameTypeDescription
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.
MSGARCHIVE_IDBIGINT NOT NULLArchived message ID identifying a message.
MSGDATECREATED TIMESTAMP The timestamp when the message was created.
MESSAGEINDEXINTEGER NOT NULLIndex number indicating which segment of the stored message this record represents.
MSGDATACREATED TIMESTAMP Time stamp when the message is created.
MSGLASTUPDATE TIMESTAMP Time stamp when the message is last upated.
MESSAGEBLOB (1000000)Represents a segment of the stored message.
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>MSGARCHIVE_ID+MESSAGEINDEX+TRANSPORT_IDPrimary Key
I0000622STOREENT_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1014TRANSPORT_IDTRANSPORTTRANSPORT_IDCascade
F_1015STOREENT_IDSTOREENTSTOREENT_IDCascade