Dropping history configurations

You can use the DROP HISTORY CONFIGURATION command to remove a history configuration. You can drop a configuration that is not active.

About this task

The following sample command drops the basic_hist history configuration:
SYSTEM.ADMIN(ADMIN)=> DROP HISTORY CONFIGURATION basic_hist;

If you want to drop the active configuration, you must first set to a new configuration and restart the software, then you can drop the non-active configuration. As a best practice, you should not drop the configuration until the loader has finished loading any captured data for that configuration.

To verify whether there are any batches of history data for the configuration that you want to drop, complete the following steps.

Procedure

  1. Open a shell window to the Netezza Performance Server system and log in as the admin user.
  2. Change to the /nz/data/hist directory.
  3. Use a command such as grep to search for CONFIG-INFO files that contain the name of the configuration that you want to drop.
    For example: 
    grep -R -i basic .
  4. Review the output of the grep command to look for messages similar to the following messages: 
    ./loading/alc_20080926_162803.964347/CONFIG-INFO:BASIC_HIST
./staging/alc_20080926_162942.198443/CONFIG-INFO:BASIC_HIST

Results

These messages indicate that there are batches in the loading and staging areas that use the BASIC_HIST configuration. If you drop that configuration before the batch files are loaded, the loader classifies them as errors when it attempts to process them later. If you want to ensure that any captured data for the configuration is loaded, do not drop the configuration until after the command in step 3 returns no output messages for the configuration that you want to drop.

For details about the command, see the DROP HISTORY CONFIGURATION command syntax in the IBM® Netezza® Database User’s Guide.