NOTIFY

Reserved for IBM internal use.

Column Descriptions:

NameTypeDescription
NOTIFY_IDBIGINT NOT NULLReserved for IBM internal use.
NOTIFICATIONIDBIGINTReserved for IBM internal use.
TRANSPORTATTNAMEVARCHAR (254)Reserved for IBM internal use.
TRANSPORTATTVALUEVARCHAR (254)Reserved for IBM internal use.
TRANSPORT_IDINTEGERReserved for IBM internal use.
MSGTYPE_IDINTEGERReserved for IBM internal use.
OPTCOUNTERSMALLINTThe 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>NOTIFY_IDPrimary Key
I0000307NOTIFICATIONIDNon-Unique Index
I0000625MSGTYPE_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1022MSGTYPE_IDMSGTYPESMSGTYPE_IDCascade
F_1023TRANSPORT_IDTRANSPORTTRANSPORT_IDCascade