Used to store messages captured by the Automation Point Desktop application. These stored messages are then available for retrieval upon request from the remote Web MV GUI client applications, providing these clients with a limited message scroll-back capability.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| webmv_key | integer | not null | The unique key assigned to each captured message that corresponds to the row in the database table used to store the message. |
| vte_handle | integer | not null | The handle of the session used to represent the session by the virtual terminal emulator (VTE) logic contained within the AP Desktop. |
| job_id | varchar(21) | not null | The current JES job ID associated with the message. |
| job_nm | varchar(31) | not null | The job name of the address space that issued the message. |
| processor_id | varchar(10) | not null | The processor ID of the host system (if available), or the host system name as defined in the AP session definition (SYSNAME). |
| action | varchar(2) | not null | If the message is an action message, this field will contain the character used to denote action messages on the host system. |
| reply_id | varchar(6) | not null | The reply number for a message that is a WTOR. |
| message_txt | varchar(512) | not null | The entire text of the captured message. |
| alarm | integer | not null | This field contains indicators that describe the event message. Currently, the only additional information stored about the message in this field is the type of alarm to trigger. |
| session_state | integer2 | not null | This field will contain the type of session from which the event was captured. This field is a short integer (2 bytes) and can currently have one of the following values: 0 - NULL (default), 1 - MCS, 2 - ECS, 3 - RCS, 4 - JES3, 5 - VM, 6 - VSE, 7 - VAX, 8 - ASYNC, 9 - VAXALL, 10 - DTX, 11 - TANDEM, 12 - TANDEMALL, 13 - JES3MCS, 14 - IPL, 15 - PAUSE, 16 - INIT, 17 - SYSPLEX. |
| action_fl | integer2 | not null | This field is used to signify if the captured event is either an action message or a normal message. This field is a short integer (2 bytes) and can have one of two possible values: 26 - the event is an action message, 27 - the event is a normal message. |
| xc_color | integer2 | not null | This field contains the color to use when displaying the event message. This field is a short integer (2 byte) and can have one of the following values: 0 - BLACK, 1 - BLUE, 2 - GREEN, 3 - CYAN, 4 - RED, 5 - PURPLE, 6 - BROWN, 7 - WHITE, 8 - GRAY, 9 - BRIGHT BLUE, 10 - BRIGHT GREEN, 11 - BRIGHT CYAN, 12 - BRIGHT RED, 13 - BRIGHT PURPLE, 14 - YELLOW, 15 - BRIGHT WHITE. |
| assigned_id | integer | not null | This field contains the ID assigned by Automation Point to the captured event. |
| sequence_id | integer | not null | This field contains the sequence number assigned by Automation Point to the current segment of the multi-line event. If Automation Point captures a multi-line message, each message part will share the same message ID, but each message segment will have a different sequence number assigned sequentially. |
| mon_num | varchar(31) | not null | This field can contain different values, depending upon the source of the captured event. If the event was captured from a DataFrame device, this field will be the source system number for the DataFrame message. If this message was captured from the Unicenter Event Console, this field will be the name of the Event Manager host from which the event was captured. If this message was captured from a Windows Event Log, this field will be the name of the Windows host from which the event was captured. If this message was captured through the OPS/AP interface, this field will contain the system ID of the Event Notification Facility (ENF) that issued the original WTO message. |
| mon_name | varchar(31) | not null | This field can contain different values, depending upon the source of the captured event. If the event was captured from a DataFrame device, this field (mon_name) will be the source system name for the DataFrame message. If this message was captured either from the Unicenter Event Console or a Windows Event Log, this field will be the name of the host that generated the event. If this message was captured through the OPS/AP interface, this field will contain the name of the OPS Multi-System Facility (MSF) that generated the message. If this message was captured from the HMC Access Facility (HAF) session, this field (haf_hmc) will contain the name of the Hardware Management Console (HMC) that generated the message. |
| mon_type | varchar(42) | not null | This field can contain different values, depending upon the source of the captured event. If the event was captured from a DataFrame device, this field (mon_type) will be the type of alert message issued by the DataFrame system. If this message was captured from the Unicenter Event Console, this field will contain the values from the Unicenter Facility and Category fields in the form Facility,Category. If this message was captured from a Windows Event Log, this field will contain the name of the event log (System, Application, or Security) from which the event was extracted. If this message was captured from the HMC Access Facility (HAF) session, this field (haf_object) will contain the type name of the object that this event is describing (CPC, LPAR, profile, IOCDS, etc.). This field is currently defined to hold 42 characters (including the null terminator). |
| mon_prty | varchar(8) | not null | This field can contain different values, depending upon the source of the captured event. If the event was captured from a DataFrame device, this field (mon_prty) will be the priority of the alert message issued by the DataFrame message. If this message was captured from either the Unicenter Event Console or a Windows Event Log, this field will contain the severity of the event (Error, Warning, Info, Success, or Failure). If this message was captured through the OPS/AP interface, this field will contain the console name indicated on the ADDRESS WTO command issued from OPS. If this message was captured from the HMC Access Facility (HAF) session, this field (haf_msgtype) will contain the message segment type for the current message segment (FIRST - the first message segment, LAST - the last message segment, MIDDLE - not the first segment and not the last segment). This field is currently defined to hold 8 characters (including the null terminator). |
| ems_dt | varchar(9) | not null | This field can contain different values, depending upon the source of the captured event. If the event was captured from a Tandem system, this field will contain the date specified at the beginning of the Tandem EMS message. If this message was captured from the HMC Access Facility (HAF) session, this field (haf_msgnum) will contain the message number assigned by AP to the HAF message (each defined HMC will have its own internal message counter). |
| jes3_nm | varchar(9) | not null | This field can contain different values, depending upon the source of the captured event. If the event was captured from either a JES3 system or a Sysplex console, this field will contain the system name from which the event was captured. If this message was captured from the HMC Access Facility (HAF) session, this field (haf_msgseq) will contain the message sequence number assigned by AP to the HAF message segment (a HAF message can be broken into multiple message segments). |
| pc_tm | varchar(9) | not null | This field stores the time that the event was captured by Automation Point. This field is in HHMMSS format. |
| host_tm | varchar(9) | not null | This field stores the time that the message was initially generated by the host (if available). This field is in HHMMSS format. |
| vfp_day | varchar(4) | not null | This column represents the day of the week a message was received i.e. MON, TUE, WED |
| ap_dt | varchar(11) | not null | This field stores the date that the event was captured by Automation Point. This field is in the format dd/mm/yyyy. |
| ap_julian_dt | varchar(8) | not null | This field is used to store the julian date that the event was captured by Automation Point. This field is in the format yyyyddd. |
| session_action_id | integer | not null | This field will contain the numeric representation of the session from which the event was captured if the message is an action message. If the message is not an action message, this field will have the value of zero. |
Product Name: Unicenter Automation Point
Table Type: Table