IBM Worklight v5.0.5 > WL server administration > Installation

Create the DB2 databases


The installer can create the databases if...

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