2.13 Recreating the Database After Installation

Database table creation has been removed from the start-up process for the User Application and incorporated into the installation procedure. In previous releases (3.0.0 through 3.6.1), it was possible to recreate the database tables after installation without having to reinstall by deleting the database and creating a new database with the same name. In previous releases, the database tables were created at start up. If the tables did not exist, then the tables would be created. This approach does not work with this release.

In this release, you can recreate the database tables after an installation, without having to reinstall the product. However, the procedure is somewhat different. There are two options for recreating the database.

If a SQL file was generated during the User Application installation, follow these steps:

  1. Stop the Application Server.

  2. Login to the Database Server.

  3. Delete the database that is used by the User Application.

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

  5. Use the SQL file that was created during the installation of the User Application to create the database tables.

  6. Restart the Application Server.

If a SQL file was not generated during the User Application installation, or if the SQL file cannot be found, follow these steps:

  1. Stop the Application Server.

  2. Login to the Database Server.

  3. Delete the database that is used by the User Application.

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

  5. Open the Novell-Custom-Install.log file, which is located at the root of the User Application install directory. For example:

    /home/lab/IDM370/idm

  6. Search for an entry similar to the following:

    **************************************************
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 outlined and paste it into a terminal on the machine where the User Application is installed.

    NOTE:You will have to replace the the stars (*) that appear for the database username and password with the actual values required to authenticate.

  8. If a SQL file is generated, then use the generated SQL file to create the database. Otherwise, the database tables were created as a result of issuing the command.

  9. Restart the Application Server.