Populate the database - assure_dq

The system administrator must complete either the custom or express database setup procedure below. Use the custom procedure if you or a DBA already performed the custom database setup steps described above. Otherwise, follow the express procedure.

Configure all properties and validate the configuration before you perform the procedure to populate the database.

Custom database setup

If you performed the custom database setup procedure described on page 31, complete the following steps. Otherwise, follow the Express Database Installation procedure.

Open <install_folder>/Infogix/bin and run the following script:
- For Windows:
```
populate-base-data.bat
```
- For UNIX or Linux:
```
./populate-base-data.sh
```
where product is the parameter for your Precisely application:
- For Assure DQ, specify IA.
- For ER, specify ER.
- For Insight, specify II.
- For Perceive, specify IV.
Attention: Product parameters are case-sensitive.

This script initializes the database and populates it with base data. It is not necessary to edit this script.
Open <install_folder>/Infogix/logs/default/ and review populate-base-data.log to verify that there were no errors.

Important: If you encounter errors, do not rerun the script or continue with the installation process until you have resolved the errors. See “Contacting Customer Support” on page 12.

Express database setup

The express setup procedure requires the application server administrator to run a single script to create the tables, initialize the database, and populate it with base data. All tablespaces are created in the same directory.

Before completing this procedure, edit the database, application server, and, if using LDAP, security and user directory properties files, as needed. Make sure that the administrative user ID and password for the database are entered in the database properties file.

Warning: Plain text passwords are visible to all users during the express procedure. Because this could pose security risks in some environments, consider running the password encryption script before you follow the steps below. See “Encrypt Passwords”.

Important: If you used the custom procedure above, skip the express procedure below.

Open <install_folder>/Infogix/bin and run the following script:
- For Windows:
```
populate-db.bat
```
- For UNIX or Linux:
```
./populate-db.sh
```
Specify the parameter for your Precisely application:
- For Assure DQ, specify IA.
- For ER, specify ER.
- For Insight, specify II.
- For Perceive, specify IV.
Attention: Product parameters are case-sensitive.
Open <install_folder>/Infogix/logs/default/ and review populate-db.log to verify that there were no errors.

Important: If you encounter errors, do not rerun the script or continue with the installation process until you have resolved the errors.

Populate the database - assure_dq - 10.1.0

Assure DQ Server Installation

Custom database setup

Express database setup