Deleting Lookup Manager data from database
When you use at least one ITE application together with the Lookup Manager, which provides enrichment data, the data can become irrelevant and you need to delete entries from the Lookup Manager. In the case described here you are using a database as the data source.
Before you begin
Configure the access specification with query statement for data removal in the connections.xml file.
Compile the Lookup Manager by using a LookupMgrCustomizing.xml file that contains all data source definitions, all segments with appropriate ITE applications and the required mapping to access specification defined in the connections.xml file.
In your command file you use the delete command.
Ensure that the database is up and running.
The ITE and Lookup Manager applications are already running in an IBM Streams instance.
About this task
Delete the Lookup Manager’s enrichment data from database.
Procedure
- Create the command file that contains the delete command and affected segments. Move the file into the directory that is configured with lm.commandsDirectory.
-
Monitor the states of your jobs with the Streams Console
-
When the applications are in RUN state, deletion finished successfully and you can use your applications