Add a database (including databases in read-only scale-out and mirroring systems) as a resource to the Monitor.
You must be a Monitor administrator.
To add a version 16 database, you must have the user ID and password for a user in the database that has the SYS_SAMONITOR_ADMIN_ROLE role. To add an earlier database, you must have the user ID and password for a user in the database that has DBA authority.
Context and remarks
You can add a resource one at a time or you can add multiple resources via a CSV file.
There is no difference in the resource configuration for a root node in a read-only scale-out system and other database servers. When the resource is configured, the Monitor detects that the resource is the root node in a read-only scale-out system.
Log in to the Monitor.
In the Add Resource window:
Click SQL Anywhere Server
In the Name field, type a name for the resource. This is the name that appears in the Monitor, and then click Next.
In the Host field, specify the hostname or IP address of the computer on which the database server is running. You can use the name localhost to represent the current computer. This value is required.
If monitoring the primary database in a mirroring system, specify the host names and port numbers of the computers running
the primary and mirror servers in a comma-separated list. For example:
(Optional) In the Port field, specify the TCP/IP port that the database is running on.
If monitoring the primary database in a mirroring system, ensure that the Port field is empty.
(Optional) In the Databases field, specify the database name.
(Optional) In the Server field, specify the server name.
If monitoring the primary database in a mirroring system, n the Server field, type the alternate server name for the primary server. That is, specify the name that clients use to connect to the database server that is acting as the primary server in the database mirroring system.
(Optional) In the Other field specify a semicolon delimited string of connection parameters.
Follow the remaining instructions.
When prompted, enter the user ID and password of a user that has the SYS_SAMONITOR_ADMIN_ROLE role or DBA authority, and then click Close.
These credentials are used to:
Connect to the database.
Create a new user named sa_monitor_user. The Monitor uses the sa_monitor_user to connect to the database and monitor it.
Install the database objects needed by the sa_monitor_user to monitor the database.
Discard from the Monitor the user credentials. Because the sa_monitor_user is added to the database being monitored, it is not necessary to store the user credentials outside the database that is being monitored.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|