A long time ago, Novell introduced Analyzer tool as part of the Novell Compliance Management Platform.
After a number of reincarnations, Analyzer was included in the IDM Standard and Advanced Edition packages and is now available to all IDM folks.
NetIQ Analyzer for Identity Manager is an Eclipse-based tool that can help to understand your environment, analyze data from different sources, and sometimes fix some data problems.
The Internal Analyzer database (HyperSQL Database, HSQLDB) can work pretty well for a small test environment, but has a huge performance degradation issue when the number of records grow, that almost don't allow you to use Analyzer in a real medium size or corporate environment.
NetIQ recommends using the external database (MySQL) for work with big data volume, but unfortunately didn't provide any “official” documentation on how to do it.
Ensure that you shift from the local database (HSQLDB) to the external database (MYSQL) if you are importing data more than 40,000 records.
We had a number of requests on our Support Forum about this topic and when once again I failed to recommend a link to “official” information, I decided to create a “How-to configure Analyzer to use external MySQL database” myself.
Most of the time I work in MS Windows and I will provide step by step instructions for Analyzer/MySQL for the Windows platform, but similar configuration steps can be used for Linux.