Deleting Lookup Manager data from CSV files and with database

When you use at least one ITE application together with the Lookup Manager, which provides enrichment data, enrichment data can become irrelevant and you need to delete data from the Lookup Manager. In the case described here you are using CSV files as the data source.

Before you begin

Compile the Lookup Manager by using a LookupMgrCustomizing.xml file that contains all data source definitions, all segments with appropriate ITE applications, the required mapping to a access specification in the connections.xml file and the indexes that are defined in the CSV input files.

In your command file you use the delete command.

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 CSV files or databases.

Procedure

  1. Create your CSV enrichment data files that contain the data to delete and move them to the directory configured with lm.file.directory. Remember to now use the ‘.del.csv’ file extension.

  2. Create the command file that contains the delete command and affected segments. Remember to use file_ prefix or _file postfix for command if you use CSV files as source. Move the file into the directory that is configured with lm.commandsDirectory.

  3. Monitor the states of your jobs with the Streams Console

  4. When the applications are in RUN state, deletion finished successfully and you can use your applications