IBM PureData System for Analytics, Version 7.1

$hist_log_entry_n

The $hist_log_entry_n table captures the log entries for the operations performed. It shows the sequence of operations that are performed on the system. This table is not populated if history collection is never enabled or if hist_type = NONE.

Table 1. $hist_log_entry_2
Name Type Description
npsid integer Netezza® ID for the source system whose data is captured in this table
npsinstanceid integer The instance ID of the nzstart command for the source Netezza system
logentryid bigint Sequential ID of the operation in the source Netezza system. This ID and the NPS ID (npsid) and instance ID (npsinstanceid) form the primary keys for this table.
sessionid bigint The session ID. This is NULL for a failed authentication.
op integer An operation code, which can be one of the following codes:
  • OP_SESSION_CREATE = 1
  • OP_SESSION_LOGOUT = 2
  • OP_FAILED_AUTH = 3
  • OP_QUERY_PROLOG = 4
  • OP_QUERY_EPILOG = 5
  • OP_PLAN_PROLOG = 6
  • OP_PLAN_EPILOG = 7
time timestamp The GMT timestamp for this operation.
tzoffset integer The timezone offset in minutes. This field is available only in database version 2 or later.
Parent topic: History views and tables

Feedback | Copyright IBM Corporation 2014 | Last updated: 2014-02-28