Set up databases



Search Tips   |   Advanced Search


This section provides information on using ConfigEngine tasks to create databases and users.

Before you begin, ensure that the following prerequisites are met:


Prepare the Windows operating system

Installing WebSphere Portal on Windows

Installing DB2 on the same server as WebSphere Portal

Configure JCR collation support

Modifying database properties

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. To create the databases...

      cd profile_root/ConfigEngine
      ./ConfigEngine.bat create-database -DWasPassword=wpsadmin

  2. 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.

  3. To create the database users

      ./ConfigEngine.bat setup-database -DWasPassword=wpsadmin

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

Parent topic:

Set up a single server

Previous topic:

Modifying database properties

Next topic:

Assigning custom table spaces

Related tasks

Creating local databases on Windows