WebSphere Commerce database table: ACCLOGMAIN

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

Indexes
Index Name Indexed Column Names Index Type
SQL060903235113530 ACCLOGMAIN_ID Primary Key

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_18 ACCLOGMAIN_ID ACCLOGSUB ACCLOGMAIN_ID Cascade
Related reference

Access logging data model

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