Sybase mirroring parameters

The following table describes the Sybase mirroring parameters worksheet when building or copying a database. You need these values when you set up the mirror database.

Parameter

Description

Control-M Mirror Database Owner (DBO)

Defines the name of the Control‑M Mirror database owner. This name is used by Control‑M when accessing the mirror database. When building a new mirror database, the initialization script creates this user on the database server.

After using this utility, enter the DBO password to access the Control-M/Server database.

Default: ctrlm

Database Owner Password

Defines the password for the Control‑M/Server Mirror database owner (6 to 30 characters, alphanumeric). The characters you enter do not echo for security reasons. Control‑M processes and utilities use the password to access the mirror database.

Database Size

Defines the amount of space (in MB) to allocate for the data portion of the Control‑M/Server Mirror database.

This value is taken from the current size of the primary database and should not be modified. Verify that the secondary database server can host a database of this size and the value is the same as the primary database.

Database Name

Defines the name for the Control‑M/Server Mirror database. This name must be unique within the Sybase SQL server.

  • When building a new mirror database, the initialization script creates this database on the database server.
  • When copying to an existing database, this database must already be defined on the database server.

Default: ctrlm_ux

Sybase Interface Directory

Defines the full path to the Sybase interfaces file on the primary system. The value is displayed and is modified by changing the value of the installed Sybase root directory parameter.

Mirror Sybase Host Name

(Copying only) Defines the name of the host computer for the mirror Sybase Database server.

Mirror Sybase Port Number

(Copying only) Defines the communications port where the secondary database server listens for queries.

If you use a Control-M dedicated database SQL Server for the mirror database, the Port Number can be found in the QUERY_SPN field in the <controlm_owner>/install/install_defs file.

Refresh Type: Recycle

Mirror Sybase server name

(Copying only) Defines the name of the mirror database server and is automatically added to the primary database’s interfaces file. This value should be unique.

Default: CTRLM2

Control‑M Mirror database name

(Copying only) Defines the name of the Control‑M/Server Mirror database, which must be unique. When copying to an existing database, this database must already be defined on the database server.

Database Administrator Login

(Building only) Defines the name of the database administrator.

Database Administrator Password

(Building only) Defines the password of the database administrator.

Installed Sybase server alias name

(Building only) Defines the Sybase alias name listed in Sybase interfaces file.

Control‑M Mirror Database Data Device Name

(Building only) Defines the name of the Sybase device that is created in the data portion of the Control‑M/Server Mirror database.

Default: ctrlm_ux

Control‑M Mirror Database Log Device Name

(Building only) Defines the name of the Sybase device that is created in the log portion of the Control‑M/Server Mirror database.

Default: ctrlm_log

Data Physical Device Path Name

(Building only) Defines the full path or physical device name where the mirror database is located on the secondary database server. Specifying a pathname initiates a file-based installation and specifying a device name initiates an installation to a raw partition.

Log Physical Device Path Name

(Building only) Defines the full path or physical device name where the mirror database’s log database is located on the secondary database server. Specifying a pathname initiates a file-based installation and specifying a device name initiates an installation to a raw partition.

Mirror Retry

Defines the the number of retries the Control-M/Server attempts before marking the mirror as damaged.

Valid values: 0-99 seconds.

Default: 10 seconds

Parent Topic

Mirroring parameters