Name Type MSSql Type Oracle Type DB2 Nullable Description
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.*)

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_OEA OEA_OH_Idnr true true true false

Foreign Keys:

Name Local References Foreign References
FK_OEA_OH OEA_OH_Idnr OH_Idnr

Return to the Index File