IBM Worklight v5.0.5 > WL server administration > Troubleshooting

Set up the DB2 database manually

IBM Worklight V5.0.5. automatically configures the databases. However, if you are using an older version of IBM Worklight, or if you are experiencing problems with the automatic configuration process, manually set up and configure your DB2 database.

  1. Create the database schema:

    1. Create a system user worklight in a DB2 admin group such as DB2USERS. Give it the password worklight.

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

    2. Open a DB2 command line processor, with a user that has SYSADM or SYSCTRL permissions:

      On Windows systems, click...

        Start | IBM DB2 | Command Line Processor

      On Linux or UNIX systems

        cd db2_install/sqllib/bin
        ./db2

    3. Create a database called WRKLGHT:

        CREATE DATABASE WRKLGHT COLLATE USING SYSTEM PAGESIZE 32768
        CONNECT TO WRKLGHT
        GRANT CONNECT ON DATABASE TO USER worklight
        QUIT

    4. Create the WRKLGHT tables:

        db2 CONNECT TO WRKLGHT USER worklight USING worklight
        db2 -vf worklight_home/path_to_script/ createworklight-db2.sql –t

    5. Create a database called WLREPORT:

        CREATE DATABASE WLREPORT COLLATE USING SYSTEM PAGESIZE 32768
        CONNECT TO WLREPORT
        GRANT CONNECT ON DATABASE TO USER worklight
        QUIT

    6. Create the WLREPORT tables:

        db2 CONNECT TO WLREPORT
        db2 -vf WKLT_HOME/WorklightServer/databases/create-worklight-reports-db2.sql -t

  2. Create a worklight.properties file.

    Give the file the following contents, depending on whether you are using JDBC or JNDI.

    1. JDBC version:

    2. JNDI version

  3. Replace...

      WEB-INF/classes/conf.worklight.properties

    ...in worklight.war with the file you created in the previous step.


Parent Troubleshooting