WebSphere Commerce database table: 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 Description(s):
Column NameColumn TypeDescription
ACCLOGMAIN_ID BIGINT NOT NULL The primary key.
THREADID VARCHAR(32) The ID of the thread in which the request was handled.
HOSTNAME VARCHAR(64) The name of the host where the request originated.
STOREENT_ID INTEGER NOT NULL The ID of the store as specified in the request.
USERS_ID BIGINT NOT NULL The ID of the user executing the request.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031152630 ACCLOGMAIN_ID Primary Key

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_18 ACCLOGMAIN_ID ACCLOGSUB ACCLOGMAIN_ID Cascade

Feedback