$hist_session_prolog_n

The $hist_session_prolog_n table stores details about each created session. Every successful authentication or session creation adds an entry to this table with a unique operation ID.

Table 1. $hist_session_prolog_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 integer 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.
pid integer Process ID of Postgres on source Netezza Performance Server system.
connecttime timestamp Connection time on the source Netezza Performance Server system.
priority integer Session priority on the source Netezza Performance Server system.
maxpriority integer Maximum priority for this session.
sessionuserid bigint User ID that created this session.
currentuserid bigint Current user ID for this session. This ID can be different from the sessionUserId.
operatinguserid bigint The operating user ID for whom the ACL and permission is used for validating permissions.
sessionusername nvarchar(128) The session user name that corresponds to sessionUserId.
currentusername nvarchar(128) The user name that corresponds to currentUserId.
operatingusername nvarchar(128) The user name that corresponds to operatingUserId.
dbid bigint The OID of the database to which the session is connected.
dbname nvarchar(128) The name of the database to which the session is connected.
clienthost varchar(256) The host name of the client that established the session.
clientip char(16) The IP address of the client that made the connection.
clientpid integer The process ID of the client.
clienttype integer The type of the client such as:
  • 0 = None
  • 1 = LibPq client (for example, nzsql)
  • 2 = ODBC client
  • 3 = JDBC client
  • 4 = nzload / nzunload
  • 5 = Client of the client manager
  • 6 = nzbackup / nzrestore
  • 7 = nzreclaim
  • 8 = Unused
  • 9 = Internal Netezza Performance Server tool
  • 10 = OLE DB client
npsclientid integer Netezza Performance Server client ID of the client.
rowsetlimit integer The value of the session variable for sessionUserId.
sessiontimeout integer The value of the session variable for sessionUserId.
querytimeout integer The value of the session variable for sessionUserId.
srqueuetimeout integer The value of the session variable for sessionUserId.
qcmaxrestarts integer The value of the session variable for sessionUserId.
resourcegroupid bigint The value of the session variable for sessionUserId.
resourcegroupname nvarchar The value of the session variable for sessionUserId.
resourcepercentage integer The value of the session variable for sessionUserId.
tzoffset integer The timezone offset in minutes. This field is available only in database version 2 or later.