Configuring Liberty profile for DB2 manually for Application Center

You can set up and configure your DB2® database manually for Application Center with WebSphere® Application Server Liberty profile.

1. Add the DB2 JDBC driver JAR file to $LIBERTY_HOME/wlp/usr/shared/resources/db2.

   If that directory does not exist, create it. You can retrieve the file in one of two ways:

   • Download it from DB2 JDBC Driver Versions.
   • Fetch it from the db2_install_dir/java on the DB2 server directory.
2. Configure the data source in the $LIBERTY_HOME/wlp/usr/servers/worklightServer/server.xml file as follows:
   In this path, you can replace worklightServer by the name of your server.

   <library id="DB2Lib">
     <fileset dir="${shared.resource.dir}/db2" includes="*.jar"/>
   </library>
   
   <!-- Declare the IBM Application Center database. -->
   <dataSource jndiName="jdbc/AppCenterDS" transactional="false">
     <jdbcDriver libraryRef="DB2Lib"/>
     <properties.db2.jcc databaseName="APPCNTR"  currentSchema="APPSCHM"
                         serverName="db2server" portNumber="50000"
                         user="worklight" password="worklight"/>
   </dataSource> 

   The worklight placeholder after user= is the name of the system user with CONNECT access to the APPCNTR database that you have previously created. The worklight placeholder after password= is this user's password. If you have defined either a different user name, or a different password, or both, replace worklight accordingly. Also, replace db2server with the host name of your DB2 server (for example, localhost, if it is on the same computer).

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

3. You can encrypt the database password with the securityUtility program in <liberty_install_dir>/bin.