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 IBM UrbanCode™ Deploy. Before
you install the IBM UrbanCode Deploy server,
install DB2 version
9.7 or later. If you are evaluating IBM UrbanCode Deploy, you can
install the database on the same computer as the IBM UrbanCode Deploy
server.
When
you install IBM UrbanCode Deploy,
you need the DB2 connection
information and a user account with table-creation privileges.
Note: It is recommended that the database be encoded in UTF-8. Changing the
database to a case-sensitive collation is also recommended.
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
ucd:
create database ucd 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
ucd to 30720
blocks:
update db cfg for ucd using logfilsiz 30720 immediate
Note: If you plan to use the
WebSphere® Application Server -
Configure plug-in with this installation of
IBM UrbanCode Deploy, use the
following
command:
update db cfg for ucd 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 IBM UrbanCode Deploy server.
- Copy the JDBC JAR file to installer_directory\lib\ext.
- If you are installing on IBM z/OS®,
edit the file ibm-ucd-install/database/deploy/ud-foreign-keys.ddl to
add the following line of code:
SET CURRENT RULES = 'STD';
- Begin server installation. See Installing the server. When you are prompted for the
database type, enter db2.
- Provide the JDBC driver class IBM UrbanCode 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:
jdbc:db2://DB_URL:DB_PORT/DB_NAME
For
example: jdbc:db2://localhost:50000/ibm_ucd
- Finish by entering the database user name and password.