DROP HISTORY CONFIGURATION
Use the DROP HISTORY CONFIGURATION command to drop the configuration for query or audit history logging.
Synopsis
DROP HISTORY CONFIGURATION <config-name> [ PASSPHRASE <phrase> ]Inputs
| Input | Description |
|---|---|
| config_name | This configuration name must exist. |
| PASSPHRASE <phrase> | The character string phrase of the configuration. If the configuration is TYPE AUDIT, then you must specify the matching phrase of the configuration for the DROP to succeed. |
Outputs
| Output | Description |
|---|---|
| DROP HISTORY CONFIGURATION | The message that the system returns if the command is successful. |
| ERROR: permission denied. | You must have Manage Security privilege. |
| ERROR: <config-name> not found. | The specified configuration name cannot be found. |
| ERROR: invalid passphrase. | The passphrase provided is not correct. |
Description
For details about all the options of the DROP HISTORY CONFIGURATION command, see theIBM® Netezza® Database User’s Guide. This command does not allow the current query or audit history configuration to be dropped. If you want to drop the current configuration you have from SET HISTORY CONFIGURATION to another configuration, restart the system and then DROP HISTORY CONFIGURATION.
After you drop a history configuration, any existing but unloaded history files in the staging or loading area for that configuration will not be loaded. When the loading process attempts to load those files, it will not be able to find the associated history-logging configuration, and will move the files to the error directory ($NZ_DATA/hist/error).
- Privileges required
- You must have Manage Security privilege to drop a history configuration.
- Common tasks
- The DROP HISTORY CONFIGURATION command does the following:
- Checks if the configuration is current configuration and if so, it returns an error.
- If the configuration is not current, it drops the configuration.
Usage
DROP HISTORY CONFIGURATION all_hist VERSION 2;