Set up databases

This section provides information on using ConfigEngine tasks to create databases and users. Before you begin, ensure that the following prerequisites are met:

• Supported database software is installed.

• Property files are modified.

• Database user names and passwords should not contain spaces and should comply with both the database management system software requirements and WebSphere Portal requirements for administering users and groups.

The following steps are the same for root and non-root users, except that the create-database task cannot be run by a non-root user.

1. cd profile_root/ConfigEngine

2. To create the databases, type the following command:

   • ConfigEngine.bat create-database -DWasPassword=password

3. Check the services file on the DB2 server system.

   If it does not specify DB2 connection and interrupt service ports, specify the ports for your operating system.

   1. Edit the file %SYSTEMROOT%\system32\drivers\etc\services.

   2. Add the text db2c_db2 50000/tcp, where db2 is the default instance.

      Ensure the port number used is not already in use. If 50000 is already is use, select a different port number.

4. To create the database users, type the following command:

   • ConfigEngine.bat setup-database -DWasPassword=password

   This task will automatically create the necessary users permissions, and table spaces.

Parent topic:

Configure a local database

---