SHOW HISTORY CONFIGURATION

Use the SHOW HISTORY CONFIGURATION command to display the query or audit history configuration settings. This command is run on the source system. By default with no arguments, it gives the current query or audit history configuration.

Syntax

Syntax for the command:

SHOW HISTORY CONFIGURATION [ <config-name> | ALL ]

Inputs

The SHOW HISTORY CONFIGURATION command has the following inputs:

Table 1. SHOW HISTORY CONFIGURATION inputs
Input	Description
ALL	Displays the details of all the query or audit history configurations.
`config_name`	Displays the details of the specific query or audit history configuration.

Outputs

The SHOW HISTORY CONFIGURATION command has the following outputs:

Table 2. SHOW HISTORY CONFIGURATION outputs
Output	Description
`SHOW HISTORY CONFIGURATION`	The message that the system returns if the command is successful.
`ERROR: permission denied.`	You must have Manage Security privilege to configure query or audit history logging.
`ERROR: <config-name> not found.`	The specified configuration name cannot be found.

Description

For details about all the options of the SHOW HISTORY CONFIGURATION command, see theIBM® Netezza® Database User’s Guide. This command displays the current or ALL or a specific query or audit configuration settings.

Privileges required: You must be an administrator or must have the Manage Security permission
Common tasks: Use the SHOW HISTORY CONFIGURATION command to display the query or audit history configuration settings.

Usage

The following provides sample usage:

SHOW HISTORY CONFIGURATION ALL;