Removing probing data from the database

After you no longer need the probing data, you can use a SET ENVIRONMENT statement to remove it from the database that contains the warehousing data. Remove probing data when you want to start a new probing session and you want to ensure that none of the previous probing data that is stored in memory is included in the new data mart definition.

1. Connect to the database where the warehousing data resides.
2. Run the SET ENVIRONMENT use_dwa 'probe cleanup' statement.
   For example:

   $ dbaccess stores_demo -
   > set environment use_dwa 'probe cleanup';
   Environment set.

   To check if the probing data is removed, run the onstat -g probe command.

   Important: The probing data is stored in memory. The data is automatically removed when the database server is shut down.