WebSphere Commerce database table: ACCLOGSUB

This table contains detailed information of the request causing access violation. The entries are linked to the ACCLOGMAIN table.


Column Description(s):
Column NameColumn TypeDescription
ACCLOGSUB_ID BIGINT NOT NULL The primary key.
ACCLOGMAIN_ID BIGINT NOT NULL Foreign key to the ACCLOGMAIN table.
LOGTIME TIMESTAMP The time the access violation occurred.
ACTION VARCHAR(254) A description of what the request tried to do.
RESULT VARCHAR(254) The result of the access control check.
RESOURCES VARCHAR(254) The resources accessed by 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
SQL050212031152760 ACCLOGSUB_ID Primary Key
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_18 ACCLOGMAIN_ID ACCLOGMAIN ACCLOGMAIN_ID Cascade

Feedback