The $hist_session_epilog_n table stores details about each session when the session is terminated. Each session completion creates an entry in this table with a unique operation ID.
Name | Type | Description |
---|---|---|
npsid | integer | Unique ID of the source IBM® Netezza® system. |
npsinstanceid | integer | Monotonically increasing nzstart instance ID of the source Netezza system. |
logentryid | bigint | This ID and the NPS ID (npsid) and instance ID (npsinstanceid)
form:
|
sessionid | bigint | Netezza session ID. This value is not unique for more than one nzstart command. This ID with the NPS ID (npsid) and instance ID (npsinstanceid) form the foreign key from query, plan, table, and column access tables. |
endtime | timestamp | GMT timestamp of the session termination. |
tzoffset | integer | The timezone offset in minutes. This field is available only in database version 2 or later. |