Installation Guide › System Requirements › Database Requirements

Database Requirements

CA GovernanceMinder creates database instances for user, role, and resource information, and Workflow data (for the Workpoint database). You can implement a database in the following two ways:

• A dedicated local RDBMS installed on the CA GovernanceMinder server.
• An existing RDBMS in the network.

Note: We recommend using Microsoft SQL Server for CA GovernanceMinder databases. During testing in CA Technologies labs, SQL Server provided the best performance.

For a list of supported databases, see the Platform Support Matrix available at CA Technologies Support Online. For information about system requirements for your RDBMS, see the documentation for your product.

Disk Space

To help ensure the best performance, the system that hosts the database must have sufficient disk space. Use the following guideline for determining the required disk space:

Set the disk space to 4 GB for every 100,000 links in a certification.

For example, if you have a certification that consists of 200,000 links, set the disk space to 8 GB.

Case Sensitive Requirements

The following case-sensitive states are applied to these databases:

• eurekify_sdb—case-sensitive
• eurekify_ticket—case-sensitive
• WPDS (Workpoint)—case-insensitive
• Data Warehouse—case-sensitive

Microsoft SQL Server

The following privileges and settings are required for Microsoft SQL Server:

• User Account—The CA GovernanceMinder database user must have the following privileges:
  • System Admin (SA)—Required during install if the installer is creating the database.
  • Dbo—Required during install if the database administrator manually created the database before install.
  • Datareader, Datawriter, BulkAdmin, DDLAdmin—minimum required privileges after installation.
• Server Authentication mode—"Mixed Authentication mode" only
• Communications protocols—TCP/IP and Named Pipes protocols enabled

Oracle Database

The following privileges and settings are required for Oracle Database:

• Database—The database must be defined either in a local tnsnames.ora file (under the Oracle Client installation), or in an Oracle directory server.
• Encoding—CA GovernanceMinder databases must use UTF-8 (AL32UTF8) encoding.
• Database Sessions and Processes—When an Oracle database server hosts CA GovernanceMinder databases, allot a minimum of 250 sessions and processes for CA GovernanceMinder activity on the database server.
• Schemas—Empty, separate, schemas for SDB, ticketdb, and Workpoint (wpds), whose owners have the following roles and privileges:
  • Roles: CONNECT and RESOURCE. The CONNECT role provides the create session permission. The RESOURCE role provides several create system privileges, and provides for previous Oracle database compatibility releases.
  • System privileges:ALTER SESSION, CREATE CLUSTER, CREATE DATABASE LINK, CREATE SEQUENCE, CREATE SESSION, CREATE SYNONYM, CREATE TABLE, CREATE VIEW, CREATE CLUSTER, CREATE INDEXTYPE, CREATE OPERATOR, CREATE PROCEDURE, CREATE SEQUENCE, CREATE TABLE, CREATE TRIGGER, CREATE TYPE, SELECT ANY DICTIONARY.

Note: We recommend that your database administrator creates the empty schemas for you before you install CA GovernanceMinder. If you do not prepare empty schemas for the CA GovernanceMinder databases, the installation requires the credentials of an Oracle Database user with DBA privileges. The installation program then creates the schemas using the information you provide.

For more information:

Increase Oracle Database Sessions and Process Parameters-A