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.
About this task
To remove all of the probing
data from the database:Procedure
- Connect to the
database where the warehousing data resides.
- 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.