Using the Internal Derby Database with OM Web Viewer 12.1?

Products

• Output Management Web Viewer

Issue/Introduction

When running the ConfigTool after the install, you will be asked to choose between using the internal Derby database or an external database. The database size used by Web Viewer is small, so from the point of performance it is really no reason to prefer one or other database.

 

Environment

• Output Management Web Viewer 12.1
• MS SQL Server
• IBM Db2
• Oracle Database
• Apache Derby

Resolution

We recommend performing the test installation with the internal Derby database (because it is easier). We recommend using the external database for production due to following reasons: 

1. If you undeploy Web Viewer with Tomcat or Websphere, or if you uninstall Web Viewer temporarily, the internal database is deleted during this process. So you have to remember you should back up the database folder or export your repositories, users, preferences etc. before undeploying or uninstallation, otherwise you have to define them manually after you deploy or install Web Viewer again.  The external database would remain in these instances.
2. The internal Derby database can not be used when you scale your Web Viewer installation to run on additional application servers (e.g. when you have a lot of users or when you have users in long-distance regions). In that case you have to use an external database or to guarantee mirroring of internal databases on all Web Viewer servers. 
3. You cannot turn off the database error messages that are displayed when bringing up Web Viewer when you have internal Derby.
4. The internal Derby database can be corrupted.

Additional Information

Please view the Web Viewer Compatibility Supportability Matrix for supported versions of the databases.  You will need to log in to view it.

An internal Derby database may be converted to a Db2 database following instructions in RO74120 NEED CONVERSION FROM INTERNAL DATABASE TO DB2