Previous Topic: External Database ConfigurationNext Topic: Configure DevTest to Use MySQL


Configure DevTest to Use DB2

This topic describes how to configure DevTest to use an IBM DB2 database.

In the following procedure, you configure the DB2 version of the site.properties file. The following properties in this file are relevant to the database configuration:

lisadb.reporting.poolName=common
lisadb.vse.poolName=common
lisadb.acl.poolName=common
lisadb.broker.poolName=common
  
lisadb.pool.common.driverClass=com.ibm.db2.jcc.DB2Driver
lisadb.pool.common.url=jdbc:db2://HOSTNAME:PORT/DATABASENAME
lisadb.pool.common.user=database_username
lisadb.pool.common.password=database_password
 
lisadb.pool.common.minPoolSize=0
lisadb.pool.common.initialPoolSize=0
lisadb.pool.common.maxPoolSize=10   
lisadb.pool.common.acquireIncrement=1   
lisadb.pool.common.maxIdleTime=45
lisadb.pool.common.idleConnectionTestPeriod=5

To minimize the number of connections to the database, connection pooling is used. The underlying implementation of the pooling functionality is c3p0. For detailed information about the settings, see http://www.mchange.com/projects/c3p0/index.html#configuration_properties. By default, all the components use the common connection pool. However, you can define a separate pool for each component or mix and match.

For the reporting database, we recommend at least 10 GB for optimal performance. A database for VSE is required only if you are working with legacy images created in a release earlier than 6.0.

The value of any property that ends with password is automatically encrypted at startup.

Note: The remote installations of DevTest Workstation, coordinator, simulator server, VSE, or any other remote DevTest component do not require more configuration. They all receive site.properties from the registry when they connect and configure their database access accordingly.

Follow these steps:

  1. Ensure that the code page of the DB2 database is 1208.
  2. Ensure that the page size of the DB2 database is at least 8 KB.
  3. In the LISA_HOME directory, locate the _site.properties file.
  4. Change the file name to site.properties.
  5. Open the site.properties file.
  6. Configure the database configuration properties.

    You typically update the following properties:

  7. The schema is automatically created in the database when the registry starts for the first time. However, if you do not want the DevTest user to have DBA privileges, you can manually create the schema beforehand. The db2.ddl file in the LISA_HOME\database directory contains SQL statements that can serve as the basis for creating the reporting tables and indexes.
  8. Set the lisadb.internal.enabled property to false.
  9. Add the DB2 JDBC driver to both LISA_HOME\lib\shared directory and LISA_HOME\webserver\phoenix\phoenix-1.0.0\WEB-INF\lib directory.

    Important! The JDBC driver must be added to both directories.

  10. Start the registry.