WebSphere Commerce database table: ACCLOGSUB

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 Descriptions
Column Name Column Type Description
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.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235113840 ACCLOGSUB_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_18 ACCLOGMAIN_ID ACCLOGMAIN ACCLOGMAIN_ID Cascade
Related reference

Access logging data model

Column Name	Column Type	Description
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.