Advanced query history

Query history captures details about the user activity on the Netezza Performance Server system, such as the queries that are run, query plans, table access, column access, session creation, and failed authentication requests. This section describes the advanced query features used with the new security capabilities.

History information is saved in a history database. Users with the correct privileges can review the query history information for details about the users and activity on the Netezza Performance Server system. These features enhance the query history with auditing and the following benefits:
  • Guaranteed audit capture of all operations
  • Digital signing of audit data
  • Audit data stored in row-secure tables
  • Secure data offload to a different Netezza Performance Server system, lowering the impact on a production system and improving the security of the audit

For more information about query history, see the IBM Netezza® System Administrator’s Guide.