The following components store information in a database:
Enterprise Dashboard: The database is used for the DevTest Solutions Usage Audit Report data, other registry information, historical event logs, and metrics.
By default, these components use an Apache Derby database that is included with DevTest. This database is adequate only for small deployments that do not require load and performance testing, and is not supported. For all other scenarios, configure DevTest to use an external database.
To ensure correct performance when using an external database, the database server and DevTest server should have high network bandwidth and low latency.
DevTest, when run in a distributed configuration, strongly depends upon any server components having a high-bandwidth, low latency connection to a well-maintained enterprise class database.
All DevTest server components communicate directly with the database to record their actions, and any restriction to the flow of this data has adverse effects.
In order to ensure that your DevTest functions correctly, no DevTest server components should have a Round Trip Time (RTT) of greater than 20 ms to the database host. If the network latency exceeds this 20 ms value, you can expect performance problems.
The following external databases are supported:
The schema is automatically created in the external database when the registry starts for the first time. Before the schema is created, ensure that the DevTest user has DBA privileges. After the schema is created, you can remove the DBA privileges from the user.
If your security policy does not permit this approach, the database administrator can manually create the schema. The DDL files in the LISA_HOME\database directory contain SQL statements for creating the reporting tables and indexes, for creating the Enterprise Dashboard database schema, and for creating the agent database schema that CA Continuous Application Insight uses. Provide this information to your database administrator.
For Enterprise Dashboard, we provide the following DDL files in the LISA_HOME\database directory:
For load and performance testing, tune the external database to ensure that it can support the amount of data storage that DevTest requires.
The registry, coordinator, simulators, and any virtual service environments require high-performance database access. Performance data is recorded directly to the database by these components. CA recommends that the database be present within the same data center. Databases hosted within a virtual machine are not recommended for general availability use.