SET HISTORY CONFIGURATION
Use the SET HISTORY CONFIGURATION command to specify which history configuration settings are to take effect after the next Netezza Performance Server system restart. Until then, the current settings remain in effect. After the restart, the history loader process attempts to load any existing history data in the staging or loading area for the previous configuration. This command is run on the source system.
Syntax
SET HISTORY CONFIGURATION <config_name>
Input
Input | Description |
---|---|
<config_name> | The name of the history configuration whose settings are to take effect after the next Netezza Performance Server system restart. |
Outputs
Output | Description |
---|---|
SET HISTORY CONFIGURATION | The command was successful. |
ERROR: permission denied | You do not have the necessary permissions. |
ERROR: <config_name> not found. | The specified configuration name cannot be found. |
Privileges
You must be the admin user, or your account must have Manage Security permissions to set a history configuration.
Usage
all_hist
:MYDB.SCH1(USER)=> SET HISTORY CONFIGURATION all_hist;