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.
Prerequisites
- 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.
- To create the databases...
cd profile_root/ConfigEngine
./ConfigEngine.bat create-database -DWasPassword=wpsadmin
- 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.
- Edit the file %SYSTEMROOT%\system32\drivers\etc\services.
- 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.
- 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