IBM Worklight v5.0.5 > WL server administration > Installation

Create the DB2 databases

The installer can create the databases if...

• You enter DB name and password for user with DB2 SYSADM or SYSCTRL privilege
• The account can be accessed through SSH

To create the databases manually...

1. Create system user wluser, with password wluser, in a DB2 admin group such as DB2USERS.

2. As user that has SYSADM or SYSCTRL permissions, open a DB2 command line processor...

   • On Windows...
     Start | IBM DB2 | Command Line Processor

   • On Linux or UNIX...
     cd db2_install/sqllib/bin
     ./db2

3. Create databases...
   create database wrklght collate using system pagesize 32768
   connect to wrklght
   grant connect on database to user wluser
   disconnect wrklght

   create database wlreport collate using system pagesize 32768
   connect to wlreport
   grant connect on database to user wluser
   disconnect wlreport

   create database appcntr collate using system pagesize 32768
   connect to appcntr
   grant connect on database to user wluser
   disconnect appcntr
   quit

DB2 has a user name and password length limit of 8 characters for Unix and Linux systems, and 30 characters for Windows.

Parent Installation

---

+

Search Tips   |   Advanced Search