OEA_OH_Idnr |
int |
NUMBER(38,0) |
int |
false |
reference to the object header (OH) |
OEA_EventType |
char (2) |
CHAR (2 CHAR) |
char(2) |
true |
TT time event(timer), TS time event(time of execution) FS/FT filesystem, CN console, FA = filesystem automatic, RN = IA.RULE, ON = IA.COLLECTOR |
OEA_RepeatType |
char (1) |
CHAR (1 CHAR) |
char(1) |
true |
R=repeated, S=single, F=first hit |
OEA_Timeout1 |
varchar (6) |
VARCHAR2 (6 CHAR) |
varchar(6) |
true |
TTHHMM time when the event ends automaticallyt !!!!!!!!!!!!!!!!!! |
OEA_Timeout2 |
int |
NUMBER(38,0) |
int |
true |
duration in seconds when the event ends automaticallyt !!!!!!!!!!!!!!!!!! |
OEA_IntAccount |
varchar (16) |
VARCHAR2 (16 CHAR) |
varchar(16) |
true |
account |
OEA_StartType |
varchar (200) |
VARCHAR2 (200 CHAR) |
varchar(200) |
true |
start type |
OEA_ActAtRun |
smallint |
NUMBER(38,0) |
smallint |
true |
activation at runtime? |
OEA_TExecType |
char (1) |
CHAR (1 CHAR) |
char(1) |
true |
TS: start after a certain time E=execute N=no execute; TT S=start immediately |
OEA_TimePeriod |
char (4) |
CHAR (4 CHAR) |
char(4) |
true |
period in min or HHMM depending on the event type |
OEA_EventSubType |
char (2) |
CHAR (2 CHAR) |
char(2) |
true |
event - subtype e.g.: filesize freespace ....EY,EC,EA event system,-security,-application O4= OS/400 Console O3=OS/390, A1=OPENOUTPUT, A2=CLOSEOUTPUT, A3=ALLOUTPUT, S1=SAP Events |
OEA_HostDst |
varchar (200) |
VARCHAR2 (200 CHAR) |
varchar(200) |
true |
host name |
OEA_LoginDst |
varchar (200) |
VARCHAR2 (200 CHAR) |
varchar(200) |
true |
name of login object |
OEA_Path |
varchar (255) |
VARCHAR2 (255 CHAR) |
varchar(255) |
true |
path to test |
OEA_Operator |
char (1) |
CHAR (1 CHAR) |
char(1) |
true |
G = greater L = less E = equal N = not equal F=greater equal K=less equal |
OEA_Value |
int |
NUMBER(38,0) |
int |
true |
value to compare |
OEA_Unit |
int |
NUMBER(38,0) |
int |
true |
unit of the value: 0=host specific, 1 = byte, 2=KB, 3 = MB, 4=GB, 5 =TB |
OEA_ScriptType |
int |
NUMBER(38,0) |
int |
true |
bit array: process additional script when 1=FALSE 2=TIMEOUT |
OEA_Source |
varchar (32) |
VARCHAR2 (32 CHAR) |
varchar(32) |
true |
WIN_EVENT: source OS/400:msg_typ |
OEA_Category |
int |
NUMBER(38,0) |
int |
true |
WIN_EVENT: category OS/400:severity |
OEA_TimePeriodTZ |
varchar (8) |
VARCHAR2 (8 CHAR) |
varchar(8) |
true |
Timezone for time period when HHMM is used |
OEA_HostAttrType |
varchar (8) |
VARCHAR2 (8 CHAR) |
varchar(8) |
true |
attribute type of the host |
OEA_EventSubType2 |
varchar (2) |
VARCHAR2 (2 CHAR) |
varchar(2) |
true |
Second check type (FC=File changed; FS=File stable) |
OEA_CheckWithin |
int |
NUMBER(38,0) |
int |
true |
Seconds in the past within the Event has to check |
OEA_InclSubDir |
smallint |
NUMBER(38,0) |
smallint |
true |
Check includes sub directores (0=no, 1=yes) |
OEA_ConsiderAll |
smallint |
NUMBER(38,0) |
smallint |
true |
Fileevent: Consider all files (0=no, 1=yes) |
OEA_OP1_Type |
varchar (6) |
VARCHAR2 (6 CHAR) |
varchar(6) |
true |
Type of first query (SQL, VARA, STATIC) |
OEA_OP1_Sql |
varchar(4096) |
CLOB |
varchar(4096) |
true |
SQL Command |
OEA_OP1_Host |
varchar (200) |
VARCHAR2 (200 CHAR) |
varchar(200) |
true |
SQL Hostname |
OEA_OP1_Login |
varchar (200) |
VARCHAR2 (200 CHAR) |
varchar(200) |
true |
Login for SQL Host |
OEA_OP1_Server |
varchar (200) |
VARCHAR2 (200 CHAR) |
varchar(200) |
true |
DB Servername |
OEA_OP1_Db |
varchar (200) |
VARCHAR2 (200 CHAR) |
varchar(200) |
true |
DB Name |
OEA_OP1_File |
varchar (200) |
VARCHAR2 (200 CHAR) |
varchar(200) |
true |
DB Filename (MS-Access) |
OEA_OP1_Vara |
varchar (200) |
VARCHAR2 (200 CHAR) |
varchar(200) |
true |
UC4 variable object name |
OEA_OP1_Keyword |
varchar (200) |
VARCHAR2 (200 CHAR) |
varchar(200) |
true |
Uc4 variable keyword |
OEA_OP1_Static |
varchar (255) |
VARCHAR2 (255 CHAR) |
varchar(255) |
true |
Static value expression |
OEA_OP2_Type |
varchar (6) |
VARCHAR2 (6 CHAR) |
varchar(6) |
true |
Type of second query (SQL, VARA, STATIC) |
OEA_OP2_Sql |
varchar(4096) |
CLOB |
varchar(4096) |
true |
SQL Command |
OEA_OP2_Host |
varchar (200) |
VARCHAR2 (200 CHAR) |
varchar(200) |
true |
SQL Hostname |
OEA_OP2_Login |
varchar (200) |
VARCHAR2 (200 CHAR) |
varchar(200) |
true |
Login for SQL Host |
OEA_OP2_Server |
varchar (200) |
VARCHAR2 (200 CHAR) |
varchar(200) |
true |
DB Servername |
OEA_OP2_Db |
varchar (200) |
VARCHAR2 (200 CHAR) |
varchar(200) |
true |
DB Name |
OEA_OP2_File |
varchar (200) |
VARCHAR2 (200 CHAR) |
varchar(200) |
true |
DB Filename (MS-Access) |
OEA_OP2_Vara |
varchar (200) |
VARCHAR2 (200 CHAR) |
varchar(200) |
true |
UC4 variable object name |
OEA_OP2_Keyword |
varchar (200) |
VARCHAR2 (200 CHAR) |
varchar(200) |
true |
Uc4 variable keyword |
OEA_OP2_Static |
varchar (255) |
VARCHAR2 (255 CHAR) |
varchar(255) |
true |
Static value expression |
OEA_StoreName |
varchar (200) |
VARCHAR2 (200 CHAR) |
varchar(200) |
true |
Identification of STORE object (EVNT.IA.*) |