Worklight Server/DB2/Multi Schema

Worklight Server/DB2/Multi Schema

7. 
   Before beginning the Worklight Install, create the DB2 user that you will use for Worklight and assign the user to the DB2ADMIN group such as DB2USERS on the operating system hosting your DB2 database. Note: The DB2 user is created at the Operating System level. Create an OS user for DB2 to use with the Worklight DB. We create a user called “wluser” as an example. Replace instances of wluser with the username you create.
   
   
   
8. 
   Create your Worklight Database and grant access to the DB User using the DB2 Command Line Processor using the following command:
   

7. 
   Click on the 'Install Maximo Anywhere Work Manager' and check the box beside 'IBM Worklight Server for Worklight Consumer Edition'
   
   
8. 
   Select the Work Light Version 5.0.6 Install Package and click next.
   
   
9. 
   Choose your shared install directory path then click next then chose the installation directory for Worklight, click next again.
   
   
10. 
    On the database configuration screen choose 'Install Apache Derby 10.8 Release (not for production use)
    

7. 
   Click next until you reach to Application server choice page. Choose Install WebSphere Application Server Liberty Profile.
   

7. 
   Click next until you see Install then click Install. If prompted for a Disk Location point to the Disk 1 Folder you extracted to Launchpad\masterSetupDisk.
   
   
8. 
   Remove the Liberty Profile and Derby Databases after the install is successful by deleting the c:\ProgramData\IBM\Worklight folder.
   
   
9. 
   Create the Worklight Database tables and set their individual Schema's using the following scripts and pointing to the db creation scripts installed with Worklight previously
   

7. 
   Create the WebSphere Data Sources to connect to DB2 in the WebSphere Console.
   
   
8. 
   Download the DB2 JDBC Driver JAR files and copy to {WAS_HOME}/optionalLibraries/IBM/Worklight/5.0.6/db2
   
   
9. 
   Expand Resources - > JDBC - > JDBC Providers - > Click on New and provide the following information
   

Then click Next -> Finish

20. 
    Expand Resources - > JDBC -> Data Sources - > Click New Data Source
    

21. 
    Click “Next” and select the JDBC Provider you created then enter the database information for your DB2 Worklight
    
    
22. 
    On the Setup Security Alias Screen, click on Global J2C authentication alias at the bottom and enter the information for your Work Light Database User. Once created go back and under Component-Managed Authentication Alias, choose the Alias you created the click next and finished.
    
    
23. 
    In the Data Source you just created, click on WebSphere Application Server Data Source Properties and check the "Non-transaction data source" box.
    
    
24. 
    Again in the Data Source you just created, click on Custom Properties and select the property "currentSchema". Set this to the Schema for the Worklight Database (WRKSCHM)
    
    
25. 
    Repeat steps 20 - 24 for the Application Center Schema and the Work Light Reports Schema using the following information
    

CurrentSchema: WLRESCHM

-----------

Data source name: Application Center Database

JNDI name: jdbc/AppCenterDS

Current Schema: APPSCHM

21. 
    Restart the WebSphere services then test the connection on your data sources.
    
    
22. 
    Once your data sources have been tested you will need to modifying  the worklight.properties inside the worklight war file. Open the file in a archive tool and edit the properties file.
    
    
23. 
    Rremove the comments on the #wl.db.type and #wl.reports.db.type properties by removing # and replace with your corresponding database type in this case you would have:

    wl.db.type=DB2

    
    wl.reports.db.type=DB2
    
    
24. 
    Comment out the JDBC string as data sources are being used to make the connection by adding # infront of wl.db.url and wl.reports.db.url so it looks like

    #wl.db.url

    
    #wl.reports.db.url
    
    
25. 
    Save the properties file back into the war
    
    
26. 
    Manually configure WebSphere for Worklight  server and deploy the Worklight war using the Worklight step by step documentation