IBM PureData System for Analytics, Version 7.1

$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 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: A foreign key into the hist_log_entry_n table A primary key for this table
sessionid	integer	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.
pid	integer	Process ID of Postgres on source Netezza system.
connecttime	timestamp	Connection time on the source Netezza system.
priority	integer	Session priority on the source Netezza 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 tool 10 = OLE DB client
npsclientid	integer	Netezza 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.