Dropping a history database

As with any user database, you can drop a history database to remove it from your system. When you drop the database, all of its tables and views and all of the collected history information it contains are also dropped.

To drop a history database:
  1. Issue the SHOW HISTORY CONFIGURATION command to ensure that the active history configuration does not load data to the database that is to be dropped. If you drop the active history database, subsequent operations that attempt to load data to that database will fail.
  2. Log in to the system database as a user who has the Drop privilege for the database that is to be dropped.
  3. Issue a DROP DATABASE command, as described in the IBM® Netezza® Database User’s Guide. For example:
    SYSTEM.ADMIN(ADMIN)=> DROP DATABASE qhist1;