Set up DB2 databases - Windows

 

+

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:

• Supported database software is installed.
• Property files are modified.

See...

• Preparing your Windows operating system
• Installing WebSphere Portal on Windows
• Installing DB2 on the same server as WebSphere Portal
• Modifying database properties
• Create Local DB Windows

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. If you plan to transfer multiple instances of WebSphere Portal, increase the default number of concurrently active databases. For example, to change the default number to 30, enter the following command at the database prompt:

   update database manager configuration using numdb 30

   A message confirms successful completion of the update. Working with properties files:

2. Create the databases

   cd WP_PROFILE/ConfigEngine
   ConfigEngine.bat create-database

3. Edit...

   %SYSTEMROOT%\system32\drivers\etc\services

   ...and add the text...

   db2c_db2 50000/tcp

   ...where db2 is the default instance.

4. Create the database users...

   • ConfigEngine.bat setup-database

 

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

---