Disabling enable_sproc_hist_logging

Learn how to disable enable_sproc_hist_logging.

Procedure

After you disable this parameter, queries from stored procedure that is run from current session are not recorded in the query history database.

Disabling enable_sproc_hist_logging globally

To disable the feature globally, you can either:
    1. Remove enable_sproc_hist_logging from postgresql.conf.
    2. Restart Netezza Performance Server
    1. Set the following line in postgresql.conf.
      enable_sproc_hist_logging = false
    2. Restart Netezza Performance Server

Disabling enable_sproc_hist_logging at a session level

  1. Set enable_sproc_hist_logging to false:
    1. SYSTEM.ADMIN(ADMIN)=> show enable_sproc_hist_logging;
    2. 
SHOW VARIABLE
SYSTEM.ADMIN(ADMIN)=> set enable_sproc_hist_logging=false;
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 on
SHOW VARIABLE
SYSTEM.ADMIN(ADMIN)=> set enable_sproc_hist_logging=false;
SET VARIABLE
SYSTEM.ADMIN(ADMIN)=> show enable_sproc_hist_logging;
NOTICE: ENABLE_SPROC_HIST_LOGGING is off
SHOW VARIABLE