Installing the database

In production environments, IBM® UrbanCode Release can be used with DB2®, Oracle, MySQL, or Microsoft SQL Server databases. By default, IBM UrbanCode Release uses the Apache Derby database. The bundled Derby database is for evaluation purposes.

IBM UrbanCode Release supports Oracle, Microsoft SQL Server, DB2, and MySQL relational databases. The provided Derby database, though sufficient for proof-of-concept work, is insufficient for the enterprise. Ideally, the database you use is configured for high-availability, high-performance, and is backed up regularly.

Database storage of 10-20 GB is sufficient for most environments. The following configurations are sufficient in most cases:

Oracle RAC
Microsoft SQL Server, clustered
MySQL, cluster
DB2 9.7 or later

Note: If you are installing IBM UrbanCode Release on Windows Server 2008 or Windows Server 2012, disable Windows User Account Control (UAC) before installing the product. See Configuring Windows UAC.

When you install IBM UrbanCode Release, you specify the database parameters on the database setup page in IBM Installation Manager. The database parameters are stored in the server.properties file in the server_installation\conf directory.

Because IBM UrbanCode Release is deployed as a Tomcat web application, the values in the server.properties file are not used until IBM UrbanCode Release is deployed.

To change the database configuration, shut down the Tomcat application server by running the file server.shutdown on Linux or server.shutdown.bat on Windows. This file is in the server folder of the server installation directory. Then, edit the server.properties file and restart Tomcat.

Feedback