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 are prompted to specify the database parameters. The database parameters are stored in the installed.properties file in the installation_directory/conf/server/ directory.

Because IBM UrbanCode Release is deployed as a Tomcat web application, the values in the installed.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 installed.properties file and restart Tomcat.