ACCLOGMAIN

This table contains information about access violation. Entries are created only if a violation has occurred. There will only be one entry per request. Detailed information is stored in the ACCLOGSUB table.

Column Descriptions:

NameTypeDescription
ACCLOGMAIN_IDBIGINT NOT NULLThe primary key.
THREADIDVARCHAR (32)The ID of the thread in which the request was handled.
HOSTNAMEVARCHAR (64)The name of the host where the request originated.
STOREENT_IDINTEGER NOT NULLThe ID of the store as specified in the request.
USERS_IDBIGINT NOT NULLThe ID of the user executing the request.
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>ACCLOGMAIN_IDPrimary Key

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_18ACCLOGMAIN_IDACCLOGSUBACCLOGMAIN_IDCascade