Changing history configuration settings

Issue the ALTER HISTORY CONFIGURATION command to change the settings for a history configuration.

The ALTER HISTORY CONFIGURATION command, as described in the IBM® Netezza® Database User’s Guide.

Restriction: You cannot change the settings for the active configuration. For example, if the active configuration is histdb1_plan:
  1. Switch to a different history configuration. For example:
    nzsql -c "set history configuration histdb1_col"
  2. Activate the new history configuration (histdb1_col) by stopping and restarting the system, that is, by issuing the nzstop and nzstart commands.
  3. Change the settings for the formerly active history configuration (histdb1_plan) using the ALTER HISTORY CONFIGURATION command.
  4. Set the changed history configuration to be the active configuration again. For example:
    nzsql -c "set history configuration histdb1_plan"
  5. Reactivate the changed history configuration by stopping and restarting the system, that is, by issuing the nzstop and nzstart commands.