4.3 Creating a Connect Database

IMPORTANT: Ensure your DBA has properly setup the Connect database table spaces before proceeding.

Execute these steps to create and populate a new Connect database schema. To upgrade an existing Connect schema, go to the next section (Section 4.3).

If Connect is installed in C:\Connect\kc, go to the install subdirectory (i.e. C:\Connect\kc\install).

Run installdb.bat
Run seeddb.bat

Note: The installdb and seeddb scripts require the database.connect property in the database.properties file to be unencrypted.

Troubleshooting

Installdb will write a log file in C:\Connect\kc\initdb\logs.

Seeddb will write a log file in C:\Connect\kc\logs.

Encrypting and Re-Encrypting Database Passwords

If you have configured a non-default encryption provider, you must convert the user passwords in the database to the new encryption scheme. To do this, run the cryptoutil utility:

cd C:\connect\kc\install
cryptoutil.bat -migrate

This will re-encrypt each user password using the new encryption scheme.