The following table lists Control‑M/Server database parameters for the MSSQL environment.
Parameter |
Description |
---|---|
Server Host Name |
Defines the host name of the machine where the SQL Server resides. If you install the dedicated SQL Server, the value is the current machine. For a silent installation the value of this parameter is blank, and the installation procedure uses the name of the current machine. |
Query Port Number -and- Backup Port Number |
Defines two TCP/IP ports for communication between Control‑M/Server and the SQL Server. The port numbers must be different from each other. If these port numbers are already used by an existing application, choose other values, each in the range 1024 to 65534 inclusive. Default: 7102 and 7103 Refresh Type: Recycle |
System Administrator (SA) Password |
Defines the password (6 to 30 alphanumeric characters) for the database administrator (user sa). The characters you enter, do not echo for security reasons. Control‑M/Server utilities uses the password to access restricted sections of the Control‑M/Server database. Default: password |
Control‑M/Server Database Name |
Defines the name for the Control‑M/Server database, which must be unique. If you use unique values for owner name, database name, and device assignments, a new database is built on the server. By using an existing owner name, database name, and device assignment, you delete and recreate the database elements. Every computer type uses a different character set for the server. Default: ctrlm |
Control‑M/Server Database Owner |
Defines the database name of the Control‑M/Server database owner. The installation script creates this user in the database. Control‑M/Server uses the name when accessing its database. Default: ctrlm |
Control‑M/Server Database Owner (DBO) Password |
Defines the password of the Control‑M/Server database owner (6 to 30 alphanumeric characters). The characters you enter, do not echo for security reasons. The first character must be a letter (A – Z). Control‑M/Server uses the password for processes and utilities to access the Control‑M/Server database. Default: password |
Data Device Logical Name |
Defines the name of the device where the Control‑M/Server database is located. Default: ctrlm_ux |
Data Device Path |
Defines the full path name of the Control‑M/Server database. Default: c:\<sql_dir>\data\ctrlm_ux |
Data Device Size |
Defines the amount of space (MB) allocated for the data portion of the Control‑M/Server database. Default: 75 (MB) |
Log Device Logical Name |
Defines the name of the device where the Control‑M/Server database is located. Default: ctrlm_log |
Log Device Location |
Defines the full path name where the Control‑M/Server database log is located. Default: c:\<sql_dir>\data\ctrlm_log |
Log Device Size |
Defines the amount of space (MB) to allocate for the Control‑M/Server database log. Default: 25 (MB)
|
Parent Topic |