IBM PureData System for Analytics, Version 7.1

$hist_state_change_n

The $hist_state_change_n table logs the state changes in the system. It logs Online, Paused, Offline, and Stopped.

For the Online state change, the logging occurs after the system goes Online. In other cases, the logging occurs before the state transition is made to the respective state. This information is collected in the history when COLLECT STATE is enabled in the history configuration. For more information, see the IBM Netezza Advanced Security Administrator's Guide.

Table 1. $hist_state_change_n
Name	Type	Description
npsid	integer	This value along with the npsInstanceId and opid form the foreign key into the operation table.
npsinstanceid	integer	Instance ID of the source IBM® Netezza® system
logentryid	bigint	This ID and the NPS ID (npsid) and instance ID (npsinstanceid) form: A foreign key into the hist_log_entry_n table A primary key for this table
changetype	bigint	The code for the change type, which is one of the following integer values: 1 = The system is Online. 2 = The system is going into the Paused state. 3 = The system is going into the Offline state. 4 = The system is going into the Stopped state.
change	varchar(512)	The text string for the change code as described in changetype