11.2 Manually Generating the Database Schema after the Installation

You can recreate the databases after installation without having to reinstall. The following steps are for Identity Governance and Identity Reporting. Identity Governance and Identity Reporting provide a database initialization script that clears the checksums before initializing the databases for Identity Governance and Identity Reporting. Each script contains variables for the JRE path and the installation path for either Identity Governance or Identity Reporting, depending on the feature.

If you have changed your database information, you must ensure that the database initialization file contains the proper information for your database. For more information, see Section 5.12.3, Updating the Identity Governance Database Initialization File for the Database Changes.

To manually generate the database schema:

  1. Stop the application server, such as Apache Tomcat. For more information, see Section 3.4.3, Starting and Stopping Apache Tomcat.

  2. Record the names of the databases.

  3. (Conditional) Recreate the existing database.

    1. Backup the database in the database.

    2. Drop the existing database.

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

  4. Open the database initialization script in a text editor and ensure that the installation paths for Java and Identity Governance or Identity Reporting match what is in your environment.

    1. Access the directory where the database installation script resides. This is the default installation location:

      • Identity Governance

        • Linux: /opt/netiq/idm/apps/idgov/bin

        • Windows: c:\netiq\idm\apps\idgov\bin

      • Identity Reporting

        • Linux: /opt/netiq/idm/apps/idrpt/bin

        • Windows: c:\netiq\idm\apps\idrpt\bin

    2. Open the database script in a text editor.

      • Linux: db-init.sh

      • Windows: db-init.bat

    3. Ensure that the following items have the correct paths for your environment.

      • install_path: Installation path for Identity Governance.

      • java_home: Installation path for the JRE that was installed with Zulu OpenJDK.

      • reporting_path: Installation path for Identity Reporting.

    4. Save and close the file.

  5. (Conditional) If you do not want to generate SQL for re-initializing the databases, initialize the databases using the database script by entering the following at a command prompt in the directory where the database script resides.

    • Linux: ./db-init.sh -password database-password

    • Windows: db-init.bat -password database-password

  6. (Conditional) If you want to generate a single SQL file for re-initializing the databases, use the following command.

    1. Enter the following at a command prompt in the directory where the database script resides.

      • Linux: ./db-init.sh -password database-password -sql > /opt/netiq/idm/apps/idrpt/sql/output.sql

      • Windows: db-init.bat -password database-password -sql > c:\netiq\idm\apps\idrpt\sql\output.sql

    2. Have your database administrator open the output.sql file in a text editor and create a SQL file for each section in the file for each database listed. You must re-initialize each database one by one.

    3. Have the database administrator run each SQL script that they create in the prior step to re-initialize the databases.

  7. Start the application server such as Apache Tomcat. For more information, see Section 3.4.3, Starting and Stopping Apache Tomcat.