Post-installation database configuration

The following steps are required for either Oracle or Microsoft SQL Server, after you have installed Codar.

Configure Oracle tablespace

Configure the Oracle tablespace you created for Application Release Automation only if you are installing Application Release Automation for the first time and there is no data in the CODAR_DOCUMENT table. The tablespace must have been created before Application Release Automation is installed and then must be configured immediately after Application Release Automation is installed (see Configure Oracle Database for information on creating the Oracle tablespace).

Work with the database administrator to perform the following (or see the manufacturer’s documentation for more information):

Modify the CODAR_DOCUMENT table such that LOB segments are stored in the tablespace. For example:

ALTER TABLE CODAR_DOCUMENT
MOVE LOB(content)
STORE AS (TABLESPACE <new_tablespace>);

Configure Microsoft SQL Server filegroup

Configure the Microsoft SQL server filegroup you created for Application Release Automation only if you are installing Application Release Automation for the first time and there is no data in the CODAR_DOCUMENT table. The filegroup must have been created before Application Release Automation is installed and then must be configured immediately after Application Release Automation is installed (see Configure Microsoft SQL Server for information on creating the Microsoft SQL server filegroup).

Work with the database administrator to perform the following (or see the manufacturer’s documentation for more information):

  1. Drop all constraints from the CODAR_DOCUMENT table.
  2. Drop the CODAR_DOCUMENT table.
  3. Recreate the CODAR_DOCUMENT table and associate it with the filegroup.
  4. Recreate the constraints for the CODAR_DOCUMENT table.