$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 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