Database server requirements

The following table lists the database server options for the Control-M full installation.

NOTE: You might experience performance degradation when the following occurs:

• Too much workload is placed on too few hard disks
• RedoLog files are placed on RAID-5 disks
• Rollback tablespace is placed on RAID-5 disks

  For more information, see 000105549.

  Database server	Description	Version
  PostgreSQL (BMC-supplied)	Installs automatically in the background when you install Control-M. NOTE: During an upgrade, the PostgreSQL database server versions is not updated.	10.0.0
  PostgreSQL (Existing)	A customer-supplied existing PostgreSQL full database server must be present (non-BMC source). The database server must have the following two extensions: plpgsql dblink NOTE: The database Administrator name must be postgres. OS authenticated logins to the database are not supported. An External PostgreSQL database is supported only if it is compatible with the Open Source PostgreSQL. The database must be configured to use user/password authentication. Trust authentication is not supported. The external PostgreSQL server must be configured to password based connectivity. EXAMPLE: The $PGDATA/pg_hba.conf file can have a line such as : host all all 0.0.0.0/0 password	9.5.x 9.6.x 10.x
  Oracle	A customer-supplied existing Oracle full enterprise/standard edition database server must be present. An Oracle instant client is supplied in the background when you install Control-M. For more details, see Oracle requirements. NOTE: Oracle 12c is supported in the following scenarios: Installed as a regular database server that is not part of a Container database. Installed as a regular pluggable database (PDB) NOTE: Control-M/EM or Control-M/Server cannot be installed on an Oracle 12c Container database (CDB).	11g 12c
  MSSQL	A customer-supplied existing MSSQL full database server must be present. A Full MSSQL 2012,2014, or 2016 client that includes the OSQL and SQLCMD components must be present on any computer that hosts Control-M/EM or Control-M/Server. You must use an MSSQL server SA account to perform the installation. Installation with a Windows User is not supported. NOTE: Control-M installation with MSSQL must always be performed using an existing English language MSSQL database server. NOTE: If you want to have the database built with a different collate than the standard Latin1 or CJK, you need to define the CTM_FORCE_COLLATE environment variable such as Chinese_Taiwan_Stroke_CI_AS or HEBREW_Bin.	2016 2014 2012

The following table contains the parameter information required to install Control-M on supported existing database servers. Check with your system administrator for the exact information required.

NOTE:

• PostgreSQL and MSSQL: The username and password must begin with a letter (A-Z, a-z) followed by 5-29 alphanumeric characters, and underscores.
• Oracle: The username and password must begin with a letter (A-Z, a-z) followed by 5-29 alphanumeric characters, and underscores.