To Remove Existing Data from the Master Index Database

If you run test data through the PIX/PDQ Manager you can clear out the data to start over with a fresh database. This only clears out the master index tables, and does not affect the audit repository database, the PIX checkpoint database, or the PIX/PDQ tables in the master index database.

This procedure will only work on the default database; if you change the object structure and recreate the database, use the scripts provided in the master index project to drop the database tables. For more information, see Dropping Master Index Database Tables in Sun Master Index User’s Guide.

1. Navigate to the directory to which you downloaded the PIX/PDQ projects during installation, and then navigate to the SQL folder.

2. Log in to the midm schema as the midm user.

3. From a SQL editor, run the clean_mdm.sql file against the midm schema.