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:

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 Time stamp when the message was created.
MESSAGEINDEXINTEGER NOT NULLIndex number indicating which segment of the stored message this record represents.
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.


NameColumn NamesType
I0000622STOREENT_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType