38.3 Manually Generating the Database Schema

You can recreate the database tables after installation without having to reinstall. This section helps you create the database schema.

  1. Stop the application server.

  2. Log in to the server that hosts the Identity Reporting database.

  3. Delete the existing database.

  4. Create a new database with the same name as the one that you deleted in Step 3.

  5. In a text editor, open the NetIQ-Custom-Install.log file, located by default at the root of the installation directory for Identity Reporting. For example:

    /opt/netiq/idm

  6. Search for an entry similar to the following content:

    **************************************************
If a failure is encountered while creating the tables, verify that this string
is correct If not, you can modify this string and copy/paste to a command line to run
**************************************************

  7. Copy the command string from the entry.

  8. Log in to the server where you installed the database for Identity Reporting.

  9. In a terminal, paste the command string that you copied.

    NOTE:The command should be updateSQL. If it is update, change the command to updateSQL.

  10. In the command, replace the asterisks (*) that represent the database username and password with the actual values required to authenticate. Also, ensure the name of the SQL file is unique.

  11. Execute the command.

  12. (Conditional) If the process generates a SQL file instead of populating the database, provide the file to your database administrator to import into the database server.

  13. Start the application server.