IBM PureData System for Analytics, Version 7.1
IBM PureData System for Analytics, Version 7.1
The $hist_nps_n table describes each source IBM® Netezza® system for which history is captured in the target database. When a Netezza system connects to a history database for the first time, a record is added to this table.
| Name | Type | Description |
|---|---|---|
| npsid | integer | A unique ID for the Netezza system, and the primary key for this table (This value is generated as a sequence on the target database where this table is defined.) |
| uuid | char(36) | UUID of the Netezza system, which is a unique ID (generated on the source Netezza system) |
| serverhost | varchar(256) | Host name of the source Netezza system |
| serverip | char(16) | IP address of the source Netezza system |
| npsinstanceid | integer | Instance ID of the source Netezza system when this record was inserted |