Preparing for Installation › Prerequisites › Database Prerequisites › Embedded Database

Embedded Database

If you choose the embedded database option, CA OM Web Viewer creates and initializes an embedded database (Apache Derby embedded database) with the proper settings. CA OM Web Viewer stores administrative data in this embedded database.

Note: The embedded database is created under a directory according to the type of application server where CA OM Web Viewer is deployed. For example:

• Tomcat: apache-tomcat/webapps/CAOMWebViewer12/database
• WebSphere: WebSphere/AppServer/derby/database

Important! Because an embedded database is a component that belongs to the installed CA OM Web Viewer application, undeploying or uninstalling (or both), CA OM Web Viewer also removes the embedded database if the embedded database is created under the application’s working folder.

This situation is applicable on some application servers such as Tomcat. To keep the content of an existing embedded database, you must manually back up and copy the database directory.

External Database

We recommend that you use an external database to keep administrative data from being affected by undeploying/uninstalling or redeploying/re-installing CA OM Web Viewer.

• If you choose an external database server, a database needs to be set up by the system administrator.
  • On the database server, a database specifically for CA OM Web Viewer must be created.
  • This database must be writable with a valid user account that has permission to access it.

Note:

• The external database server must provide a JDBC-3 compliant interface.
• For DB2, you must set up and run your DB2 server in new-function mode (NFM).

Be aware that the tables of the database can be created manually or automatically, depending on whether the account is granted with CREATE TABLE privileges:

• If this account has CREATE TABLE privileges, this database can be empty and CA OM Web Viewer automatically creates the necessary tables.
• If this account does not have CREATE TABLE privileges, ask your database administrator (DBA) to create tables according to the Data Description Language (DDL) statements provided with CA OM Web Viewer.

Note: These DDL statements can be found under the ddl folder in your installation media or the installed directory. For each supported database type, a pair of SQL scripts is provided as follows:

• create.sql For creating tables in the pre-created database
• drop.sql For deleting tables from the pre-created database

See the specific instructions in either the GUI or Console mode of installation.

Note: Currently we provide DDLs for the following types of database: DB2, Derby, Oracle, and SQL Server.