## 11.3 M\_SYSTEM\_AVAILABILITY System View
Monitors the availability of the system.
## Structure
| Column name   | Data type      | Description                           |
|---------------|----------------|---------------------------------------|
| EVENT_TIME    | TIMESTAMP      | Time this event was originally traced |
| GUID          | NVARCHAR ( 36  | Event guide                           |
| IS_ORIGIN     | VARCHAR ( 5 )  | Original entry                        |
| TRACE_HOST    | VARCHAR ( 64 ) | Host the trace file was read from     |
| EVENT_NAME    | VARCHAR ( 32 ) | Event name. Possible values include:  |
- database\_add
- database\_remove
- failover\_begin
- failover\_end
- host\_remove\_prepare
- host\_remove\_reorg
- host\_remove\_abort
- host\_remove
- ping
- recovery\_begin
- recovery\_end
- service\_remove
- service\_remove\_abort
- service\_remove\_prepare
- service\_remove\_reorg
- service\_started
- service\_starting
- service\_stopped
- service\_stopping
- service\_unknown
Additional information
Error message
EVENT\_DETAIL
ERROR\_MESSAGE
VARCHAR ( 256 )
VARCHAR ( 256 )
| Column name                      | Data type       | Description                                                                                                                   |
|----------------------------------|-----------------|-------------------------------------------------------------------------------------------------------------------------------|
| SYSTEM_ACTIVE                    | VARCHAR ( 16 )  | System active status (summary of ac­ tive values of all hosts). Possible values include: no, yes, unknown, starting, stopping. |
| SYSTEM_STATUS                    | VARCHAR ( 16 )  | System status. Possible values include: ● error ● ignore ● info ● ok ● warning                                                |
| HOST                             | VARCHAR ( 64 )  | Host that traced the event                                                                                                    |
| HOST_ACTIVE                      | VARCHAR ( 16 )  | Host active status (summary of active values of all services on that host)                                                    |
| HOST_STATUS                      | VARCHAR ( 16 )  | Host status                                                                                                                   |
| DATABASE_NAME                    | VARCHAR ( 256 ) | Database name                                                                                                                 |
| DATABASE_ACTIVE                  | VARCHAR ( 16 )  | Database active status                                                                                                        |
| SERVICE_NAME                     | VARCHAR ( 32 )  | Service name                                                                                                                  |
| PORT                             | INTEGER         | Port of service                                                                                                               |
| VOLUME_ID                        | INTEGER         | Volume ID                                                                                                                     |
| SERVICE_ACTIVE                   | VARCHAR ( 16 )  | Service active status                                                                                                         |
| HOST_CONFIG_ROLES                | VARCHAR ( 64 )  | Configured host roles                                                                                                         |
| HOST_ACTUAL_ROLES                | VARCHAR ( 64 )  | Actual host roles                                                                                                             |
| STORAGE_CONFIG_PARTITION         | INTEGER         | Configured storage partition                                                                                                  |
| STORAGE_ACTUAL_PARTITION         | INTEGER         | Actual storage partition                                                                                                      |
| TARGET_HOST                      | VARCHAR ( 64 )  | Failover target host                                                                                                          |
| TARGET_HOST_CONFIG_ROLES         | VARCHAR ( 64 )  | Same as TARGET_HOST_CON­ FIG_ROLES for failover target                                                                         |
| TARGET_HOST_ACTUAL_ROLES         | VARCHAR ( 64 )  | Same as TARGET_HOST_AC­ TUAL_ROLES for failover target                                                                         |
| TARGET_STORAGE_CONFIG_PARTI­ TION | INTEGER         | Same as TARGET_STORAGE_CON­ FIG_PARTITION for failover target                                                                  |
| Column name                      | Data type   | Description                                                  |
|----------------------------------|-------------|--------------------------------------------------------------|
| TARGET_STORAGE_ACTUAL_PARTI­ TION | INTEGER     | Same as TARGET_STORAGE_AC­ TUAL_PARTITION for failover target |
| SITE_ID                          | INTEGER     | Replication site ID                                          |