Configuring a DB2® database
To use a DB2® database with the server, before you install the server, install the IBM® DB2® database and provide the JDBC JAR file for the server installation process.
Before you begin
DB2® is bundled with HCL DevOps Deploy (Deploy). Before you install the server, install DB2® version 9.7 or later. If you are evaluating Deploy, you can install the database on the same computer as the Deploy server.
When you install Deploy, you need the DB2® connection information and a user account with table-creation privileges.
Procedure
- Create a database with a default page size of 32
K.Type the following text on the DB2® command line to create a database that is named deploydb:
create database deploydb pagesize 32 k
-
Increase the transaction log size of the database.
Type the following text on the DB2® command line to increase the transaction log size of a database that is named deploydb to 30720 blocks:
update db cfg for deploydb using logfilsiz 30720 immediate
Note: If you plan to use the WebSphere® Application Server - Configure plug-in with this installation of Deploy, use the following command:update db cfg for deploydb using logfilsiz 30720 logprimary 100 immediate
For more information, see the Troubleshooting page in the plug-in documentation.
- Obtain the DB2® JDBC
driver.The JDBC JAR file is included among the installation files for the database. The driver is unique to the edition you are using.
When multiple drivers are available, you might need to consult with the database provider to determine which driver to use. The JDBC driver version that you must use might depend on the version of the database and the version of Java™ used by the Deploy server.
- Copy the JDBC JAR file to installer_directory\lib\ext.
- Begin server installation. See Installing the DevOps Deploy server. When you are prompted for the database type, enter db2.
-
Provide the JDBC driver class Deploy uses to
connect to the database.
The default value is
com.ibm.db2.jcc.DB2Driver
. - Next, provide the JDBC connection string.Typically, it is similar to the following code:
For example:jdbc:db2://DB_URL:DB_PORT/DB_NAME
jdbc:db2://localhost:50000/deploydb
- Finish by entering the database user name and password.