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 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. |
Index(es):
Index Name | Indexed Column Names | Index Type |
SQL050212031152630 |
ACCLOGMAIN_ID |
Primary Key |
Referenced By:
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_18 |
ACCLOGMAIN_ID |
ACCLOGSUB |
ACCLOGMAIN_ID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.