$hist_session_epilog_n

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.

Table 1. $hist_session_epilog_n
Name Type Description
npsid integer Unique ID of the source system.
npsinstanceid integer Monotonically increasing nzstart instance ID of the source Netezza Performance Server 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
sessionid bigint Netezza Performance Server 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.