Automatic Diagnostics Repository Schema

ADR_CONTROL

Name                          Type            NULL?
----------------------------- --------------- -----------
ADRID                         number
SHORTP_POLICY                 number
LONGP_POLICY                  number
LAST_MOD_TIME                 timestamp
LAST_AUTOPRG_TIME             timestamp
LAST_MANUPRG_TIME             timestamp
ADRDIR_VERSION                number
ADRSCHM_VERSION               number
ADRSCHMV_SUMMARY              number
ADRALERT_VERSION              number
CREATE_TIME                   timestamp

ADR_INVALIDATION

Name                          Type            NULL?
----------------------------- --------------- -----------
COMPID                        number
VALID                         number

AMS_XACTION

Name                          Type            NULL?
----------------------------- --------------- -----------
FLAGS                         number

DDE_USER_ACTION_DEF

Name                          Type            NULL?
----------------------------- --------------- -----------
ACTION_NAME                   text(31)
COMPONENT_NAME                text(31)
DRIVER                        text(31)
COMMAND                       text(129)
DESCRIPTION                   text(129)
DETAILED_DESCRIPTION          text(513)
ACTION_TYPE                   number
RESULT_TYPE                   number
NUM_PARAMETERS                number

DDE_USER_ACTION_PARAMETER_DEF

Name                          Type            NULL?
----------------------------- --------------- -----------
ACTION_NAME                   text(31)
PARAMETER_NAME                text(31)
POSITION                      number
DESCRIPTION                   text(129)
DEFAULT                       text(256)
FLAGS                         number

DDE_USER_ACTION_PARAMETER

Name                          Type            NULL?
----------------------------- --------------- -----------
INCIDENT_ID                   number
ACTION_NAME                   text(31)
PARAMETER_NAME                text(31)
INVOCATION_ID                 number
POSITION                      number
PARAMETER_VALUE               text(256)

DDE_USER_ACTION

Name                          Type            NULL?
----------------------------- --------------- -----------
INCIDENT_ID                   number
ACTION_NAME                   text(31)
INVOCATION_ID                 number
STATUS                        number
ACTION_SOURCE                 number
INVOCATION_TIME               timestamp
FINISH_TIME                   timestamp

DDE_USER_INCIDENT_ACTION_MAP

Name                          Type            NULL?
----------------------------- --------------- -----------
TYPE_NAME                     text(31)
ACTION_NAME                   text(31)

DDE_USER_INCIDENT_TYPE

Name                          Type            NULL?
----------------------------- --------------- -----------
TYPE_NAME                     text(31)
DESCRIPTION                   text(129)

EM_DIAG_JOB

Name                          Type            NULL?
----------------------------- --------------- -----------
JOB_SEQ                       number
JOB_ID                        text(80)
EXECUTION_ID                  text(70)
JOB_NAME                      text(70)
JOB_DESCRIPTION               text(256)
COMMAND_LINE                  text(256)
USER_NAME                     text(40)
STATUS                        number
OUTPUT                        text(1024)

EM_TARGET_INFO

Name                          Type            NULL?
----------------------------- --------------- -----------
TARGETINFO_ID                 number
COMPOSITE_TARGET_NAME         text(256)
COMPOSITE_TARGET_TYPE         text(70)
COMPOSITE_TARGET_GUID         text(70)
MEMBER_TARGET_NAME            text(256)
MEMBER_TARGET_TYPE            text(70)
MEMBER_TARGET_GUID            text(70)
MEMBER_TARGET_EMD_URL         text(1024)

EM_USER_ACTIVITY

Name                          Type            NULL?
----------------------------- --------------- -----------
ACTIVITY_ID                   number
ACTIVITY_TYPE                 number
PARENT_TYPE                   number
PARENT_ID                     number
DETAIL                        text(200)
USER_NAME                     text(40)
JOB_ID                        text(80)
TIME_ENTERED                  timestamp

HM_FDG_SET

Name                          Type            NULL?
----------------------------- --------------- -----------
FDG_SET_ID                    number
FDG_ID                        number
FLAGS                         number
CREATE_TIME                   timestamp

HM_FINDING

Name                          Type            NULL?
----------------------------- --------------- -----------
FDG_ID                        number
RUN_ID                        number
PFDG_ID                       number
NAME                          text(31)
NAME_ID                       number
CLSNAME                       text(31)
CLSNAME_ID                    number
CREATE_TIME                   timestamp
MODIFIED_TIME                 timestamp
TYPE                          number
STATUS                        number
PRIORITY                      number
FLAGS                         number
CHILD_COUNT                   number
MSG_GRPID                     number
NUM_MSG                       number
DAMAGE_MSGGRP_ID              number
NUM_DAMAGE_MSG                number
HASH_CODE                     number
VERSION                       number
CLOSE_REASON                  number
INSTANCE_NUMBER               number
SPARE_UB8                     number

HM_INFO

Name                          Type            NULL?
----------------------------- --------------- -----------
INFO_ID                       number
NAME                          text(31)
VALUE                         text(512)
TYPE                          number
FLAGS                         number

HM_MESSAGE

Name                          Type            NULL?
----------------------------- --------------- -----------
OBJID                         number
MSGID                         number
SEQNO                         number
FLAGS                         number
MSGNO                         number
ARG1                          text(512)
ARG2                          text(512)
ARG3                          text(512)
ARG4                          text(512)
ARG5                          text(512)

HM_RECOMMENDATION

Name                          Type            NULL?
----------------------------- --------------- -----------
RECOMMENDATION_ID             number
FDG_ID                        number
RUN_ID                        number
NAME                          text(31)
NAME_ID                       number
TYPE                          number
FLAGS                         number
RANK                          number
CREATE_TIME                   timestamp
END_TIME                      timestamp
STATUS                        number
EST_REPAIR_TIME               number
ACT_REPAIR_TIME               number
DATA_LOSS_TIME                number
MSG_GRPID                     number
NUM_MSG                       number
REPAIR_SCRIPT                 bfile

HM_RUN

Name                          Type            NULL?
----------------------------- --------------- -----------
RUN_ID                        number
RUN_NAME                      text(31)
CHECK_NAME                    text(31)
NAME_ID                       number
MODE                          number
START_TIME                    timestamp
RESUME_TIME                   timestamp
END_TIME                      timestamp
MODIFIED_TIME                 timestamp
TIMEOUT                       number
FLAGS                         number
STATUS                        number
SRC_INCIDENT_ID               number
NUM_INCIDENTS                 number
ERR_NUMBER                    number
REPORT_FILE                   bfile

INC_METER_CONFIG

Name                          Type            NULL?
----------------------------- --------------- -----------
CFG_ID                        number
TRANSIENT_INCIDENT_LIFE_TIME  number
FLAGS                         number
CRITICAL_FACTOR               number
WARNING_FACTOR                number
WEIGHT_FACTOR                 number
MODIFICATION_TIME             timestamp
PRODUCT_STARTUP_TIME          timestamp

INC_METER_IMPT_DEF

Name                          Type            NULL?
----------------------------- --------------- -----------
IMPACT_ID                     number
IMPACT_NAME                   text(128)
IMPACT_SCOPE                  number
IMPACT_SEVERITY               number
IMPACT_DESC                   text(512)
IMPACT_FLAGS                  number

INC_METER_INFO

Name                          Type            NULL?
----------------------------- --------------- -----------
INCIDENT_ID                   number
FLAGS                         number
CREATE_TIME                   timestamp
IMPACT1                       number
IMPACT2                       number
IMPACT3                       number
IMPACT4                       number
PROBLEM_ID                    number
SEVERITY                      number

INC_METER_PK_IMPTS

Name                          Type            NULL?
----------------------------- --------------- -----------
PROBLEM_KEY                   text(550)
IMPACT1                       number
IMPACT2                       number
IMPACT3                       number
IMPACT4                       number
FLAGS                         number

INC_METER_SUMMARY

Name                          Type            NULL?
----------------------------- --------------- -----------
SUMMARY_ID                    number
SEVERITY_INDEX                number
CRITICAL_INCIDENTS            number
WARNING_INCIDENTS             number
NUM_INCIDENTS_LASTHOUR        number
FLAGS                         number
CREATE_TIME                   timestamp
OLDEST_TRANSIENT_INC_CTIME    timestamp
OLDEST_PERSISTENT_INC_CTIME   timestamp
LATEST_INC_CTIME              timestamp

INCCKEY

Name                          Type            NULL?
----------------------------- --------------- -----------
INCIDENT_ID                   number
FLAGS                         number
KEY_NAME                      text(64)
KEY_VALUE                     text(526)

INCIDENT_FILE

Name                          Type            NULL?
----------------------------- --------------- -----------
INCIDENT_ID                   number
OWNER_ID                      number
BFILE                         bfile
FLAGS                         number

INCIDENT

Name                          Type            NULL?
----------------------------- --------------- -----------
INCIDENT_ID                   number
PROBLEM_ID                    number
CREATE_TIME                   timestamp
CLOSE_TIME                    timestamp
STATUS                        number
FLAGS                         number
FLOOD_CONTROLLED              number
ERROR_FACILITY                text(10)
ERROR_NUMBER                  number
ERROR_ARG1                    text(64)
ERROR_ARG2                    text(64)
ERROR_ARG3                    text(64)
ERROR_ARG4                    text(64)
ERROR_ARG5                    text(64)
ERROR_ARG6                    text(64)
ERROR_ARG7                    text(64)
ERROR_ARG8                    text(64)
SIGNALLING_COMPONENT          text(64)
SIGNALLING_SUBCOMPONENT       text(64)
SUSPECT_COMPONENT             text(64)
SUSPECT_SUBCOMPONENT          text(64)
ECID                          text(64)
IMPACT                        number
ERROR_ARG9                    text(64)
ERROR_ARG10                   text(64)
ERROR_ARG11                   text(64)
ERROR_ARG12                   text(64)

IPS_CONFIGURATION

Name                          Type            NULL?
----------------------------- --------------- -----------
PARAMETER_ID                  number
UNIT                          number
VALUE                         number
DEFAULT_VALUE                 number
NAME                          text(32)
DESCRIPTION                   text(201)
MINIMUM                       number
MAXIMUM                       number
FLAGS                         number

IPS_FILE_COPY_LOG

Name                          Type            NULL?
----------------------------- --------------- -----------
FILE_ID                       number
OPERATION                     number
OPERATION_TIME                timestamp
EXTERNAL_FILE                 text(1025)
PACKAGE_ID                    number
INCIDENT_ID                   number

IPS_FILE_METADATA

Name                          Type            NULL?
----------------------------- --------------- -----------
FILE_ID                       number
BFILE                         bfile
SOURCE                        number
FLAGS                         number
INCIDENT_ID                   number

IPS_PACKAGE_FILE

Name                          Type            NULL?
----------------------------- --------------- -----------
PACKAGE_ID                    number
FILE_ID                       number
LAST_SEQUENCE                 number
EXCLUDE                       number

IPS_PACKAGE_HISTORY

Name                          Type            NULL?
----------------------------- --------------- -----------
PACKAGE_ID                    number
SEQUENCE                      number
MODE                          number
STATUS                        number
ARCHIVE_TIME                  timestamp
UPLOAD_TIME                   timestamp
PHYSICAL_FILE                 text(1025)
BASE_SEQUENCE                 number
FLAGS                         number

IPS_PACKAGE_INCIDENT

Name                          Type            NULL?
----------------------------- --------------- -----------
PACKAGE_ID                    number
PROBLEM_ID                    number
INCIDENT_ID                   number
TYPE                          number
EXCLUDE                       number

IPS_PACKAGE_UNPACK_HISTORY

Name                          Type            NULL?
----------------------------- --------------- -----------
PACKAGE_ID                    number
SEQUENCE                      number
MODE                          number
ARCHIVE_TIME                  timestamp
FORCE                         number
FLAGS                         number

IPS_PACKAGE

Name                          Type            NULL?
----------------------------- --------------- -----------
PACKAGE_ID                    number
FLAGS                         number
STATUS                        number
CREATION_TIME                 timestamp
LAST_SEQUENCE                 number
LAST_COMPLETE_SEQUENCE        number
PROBLEM_ID                    number
NAME                          text(101)
DESCRIPTION                   text(301)
CORRELATION_LEVEL             number
DRIVING_INCIDENT              number
BEGIN_TIME                    timestamp
END_TIME                      timestamp
UPDATE_TIME                   timestamp
LAST_BASE_SEQUENCE            number

IPS_REMOTE_PACKAGE

Name                          Type            NULL?
----------------------------- --------------- -----------
PACKAGE_ID                    number
CORRELATED_ID                 number
REMOTE_HOME                   text(444)
REMOTE_TARGET                 text(71)
TARGET_TYPE                   text(71)

PICKLEERR

Name                          Type            NULL?
----------------------------- --------------- -----------
FILE_NAME                     bfile
ERROR_CREATION                timestamp
SECTION                       text(64)
ELEMENT                       text(64)
DESCRIPTION                   text(64)
ARG1                          number
ARG2                          number

PROBLEM

Name                          Type            NULL?
----------------------------- --------------- -----------
PROBLEM_ID                    number
PROBLEM_KEY                   text(550)
FIRST_INCIDENT                number
FIRSTINC_TIME                 timestamp
LAST_INCIDENT                 number
LASTINC_TIME                  timestamp
IMPACT1                       number
IMPACT2                       number
IMPACT3                       number
IMPACT4                       number
SERVICE_REQUEST               text(64)
BUG_NUMBER                    text(64)

SWEEPERR

Name                          Type            NULL?
----------------------------- --------------- -----------
INCIDENT_ID                   number
SWEEP_TIME                    timestamp
TOP_ERROR1                    number
TOP_ERROR2                    number
DESCRIPTION                   text(64)

VIEW

Name                          Type            NULL?
----------------------------- --------------- -----------
OBJ_ID                        number
NAME                          text(64)
TEXT                          text(3800)
CREATION_TIME                 timestamp
SCOPE                         number
VERSION                       number

VIEWCOL

Name                          Type            NULL?
----------------------------- --------------- -----------
OBJ_ID                        number
ORDER_ID                      number
NAME                          text(64)
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License