Enabling enable_sproc_hist_logging

Learn how to enable enable_sproc_hist_logging.

Procedure

Enabling enable_sproc_hist_logging globally

  1. If query history is not enabled, enable it.
  2. Add the following configuration parameter in postgresql.conf.
    enable_sproc_hist_logging = true
  3. Restart Netezza Performance Server.

Enabling enable_sproc_hist_logging at a session level

  1. If query history is not enabled, enable it.
  2. Use the set command.
    1. SYSTEM.ADMIN(ADMIN)=> show enable_sproc_hist_logging;
    2. SHOW VARIABLE
SYSTEM.ADMIN(ADMIN)=> set enable_sproc_hist_logging=true;
SET VARIABLE
SYSTEM.ADMIN(ADMIN)=> show enable_sproc_hist_logging;
      Example:
      SYSTEM.ADMIN(ADMIN)=> show enable_sproc_hist_logging;
NOTICE: ENABLE_SPROC_HIST_LOGGING is off
SHOW VARIABLE
SYSTEM.ADMIN(ADMIN)=> set enable_sproc_hist_logging=true;
SET VARIABLE
SYSTEM.ADMIN(ADMIN)=> show enable_sproc_hist_logging;
NOTICE: ENABLE_SPROC_HIST_LOGGING is on
SHOW VARIABLE