state database schema

The state database schema is defined in the NCHOME/etc/precision/VirtualDomainSchema.cfg directory. The state database schema has three tables: state.services, state.domains, and state.filters.

The services table holds the status of the processes monitored by the CTRL process. The table below describes the columns of the services table.

Table 1. state.services Table Descriptions 
Column name Constraints Data type Description
m_ArgList   List Specifies a list of arguments sent to the service process.
m_ChangeTime NOT NULL Timestamp Specifies a timestamp from the last time the status of this service was updated by the CTRL process.
m_CtrlState NOT NULL Integer

Specifies an integer which reflects the operational state of the service.

  • 0 - The service is alive but idle.
  • 1 - The service is waiting for its prerequisites, that is, waiting for its dependencies to be satisfied.
  • 2 - The service is waiting for a heartbeat from another service.
  • 3 - The application is starting, that is, Fork service.
  • 4 - The service is alive and running.
  • 5 - The service is not functioning correctly.
  • 6 - The service is stopped.
  • 7 - The service failed.
  • 8 - The service is shutdown.
m_Domain NOT NULL Text Specifies the domain name under which the service is running.
m_ExtraInfo   Vblist Specifies additional information. The default value is empty.
m_Pid NOT NULL Integer Specifies the process ID for the component.
m_ServiceName

PRIMARY KEY

NOT NULL

Text Specifies the service name of the component monitored by the CTRL process.

The domains table holds the status of the primary and backup domains in the failover architecture. This table always contains an entry for the primary server and the backup server.

The table below describes the columns of the domains table.

Table 2. state.domains Table Descriptions 
Column name Constraints Data type Description
m_ActingPrimary NOT NULL Integer

Specifies whether the Network Manager server is acting as the primary server and is monitoring the network.

  • 0 - Not acting as the primary server
  • 1 - Acting as the primary server
m_Backup NOT NULL Integer

Specifies whether the server is configured as the backup server. This value is automatically set by the configuration defined in the $NCHOME/etc/precision/ConfigItnm.DOMAIN.cfg file, or by inclusion of the -primaryDomain command-line option on components started by the CTRL process.

  • 0 - Not configured as the backup server
  • 1 - Configured as the backup server
m_ChangeTime NOT NULL Long Specifies the timestamp from the last time the status of the domain was updated by the Event Gateway.
m_Domain NOT NULL Text Specifies the domain in which this installation of Network Manager is running. The domain name must be different from the names of the primary and backup servers.
m_HealthStatus NOT NULL Integer

Specifies the status of the Health Check events.

  • 0 - Unhealthy. The Network Manager server generated a Health Check Problem event or the existing Health Check Resolution event exceeded the m_failover time period.
  • 1 - Healthy. The Network Manager server generated a Health Check Resolution event within the m_failover time period.

The filters table contains the filters that are to be applied to the values in the state.services table. The table below describes the columns of the filters table.

Table 3. state.filters Table Descriptions
Column name Constraints Data type Description
m_ServiceName NOT NULL Text Specifies the unique name of the service to which the filter is applied.
m_Filter NOT NULL Text Specifies the OQL filter to apply.
m_Description   Text Specifies a description of the filter operation.

Network Manager provides a default filter for the following components:

There is one filter for each component except for the ncp_poller component, which instead can have a filter for each poller defined. Each filter checks that the m_CtrlState value is not set to 7 (the service has not failed), and that the timestamp m_ChangeTime is not older than 300 seconds.

Default filters for the state.filters table are provided for the components below.

  • Polling engine, ncp_poller: multiple filters can be defined, one for each poller defined in the CtrlServices.cfg file.
  • Event Gateway, ncp_g_event
  • Topology manager, ncp_model