Adding multiple resources

 Add multiple resources to the Monitor

As an administrator, you can add multiple resources to the Monitor by creating a comma separated values (CSV) file, and then importing the file.

You cannot use a CSV file to add a primary database in a database mirroring system as a resource; use the Administration window instead. See Add resources.

  1. Create a CSV file.

    Each line in the CSV file contains information about a single resource. Each comma-separated term within a line describes an attribute of the resource. The order of the terms is important. The following table describes the terms and their order:

    For terms that are optional, any preceding terms (including other optional terms) must be specified. For example, if you want to specify the database name, you must also specify the server name and port number, if you want to specify the encryption type, you must also specify the connection type and if you want to specify the Monitoring URL suffix, you must also specify the port number.

    • CSV file format for SQL Anywhere database resources   For terms that are optional, any preceding terms (including other optional terms) must be specified. For example, if you want to specify the database name, you must also specify the server name and port number.

      Position in the line Term Description
      1 Resource type Type sa to Indicate that the resource is a SQL Anywhere database. This term is required.
      2 Resource name Specify the resource name that the database will have in the Monitor. This term is required.
      3 Username Specify the DBA user name used to connect to the database. This term is required.
      4 Password Specify the DBA password used to connect to the database. This term is required.
      5 Host (SQL Anywhere) 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 term is required.
      6 Port (SQL Anywhere) Specify the port number on which the SQL Anywhere database server is running. The default port number for SQL Anywhere is 2638. This term is optional. The default value is 0.
      7 Server (SQL Anywhere) Specify the name of the database server that the database is connected to. This term is optional.
      8 Database (SQL Anywhere Specify the name of the database. This term is optional.
      9 Connection Parameters (SQL Anywhere) Specify additional connection parameters to use when connecting to the database. List the connection parameters as a semicolon delimited list of option=value pairs. The default value is "".This term is optional.

      The following is an example of a csv file that contains two SQL Anywhere database resources.

      sa,demo,DBA,sql,localhost,2638,demo12
sa,demo3,DBA,sql,localhost,49152,demo12,demo

    • CSV file format for MobiLink resources   For terms that are optional, any preceding terms (including other optional terms) must be specified. For example, if you want to specify the encryption type, you must also specify the connection type.

      Position in the line Term name Description
      1 Resource type

      Type ml to indicate that the resource is a MobiLink server.

      This term is required.
      2 Resource name Specify the resource name as it will appear in the Monitor. This term is required.
      3 Username Specify the username used to connect to the resource. This term is required.
      4 Password Specify the password used to connect to the resource. This term is required.
      5 Host (MobiLink server) Specify the hostname or IP address of the computer on which the server is running. You can use the name localhost to represent the current computer. This term is required.
      6 Port (MobiLink server) Specify the port number on which the MobiLink server is running. The default port number for MobiLink is 2439. This term is optional. The default value is 0.
      7 Connection type (MobiLink server)

      Specify the method to use to connect to the resource: Type one of the following:

      • tcpip

        This is the default.

      • http

      • https

      • tls

      This term is optional.
      8 Encryption type (MobiLink server)

      Specify the method used to encrypt the connection. Type one of the following:

      • N   No encryption. This is the default.

      • E   ECC encryption.

      • R   RSA encryption.

      • F   FIPS-certified RSA encryption.

      This term is optional.
      9 Connection parameters (MobiLink server) Specify additional connection parameters to use when connecting to the database. List the connection parameters as a semicolon delimited list of option=value pairs. This term is optional.

      MobiLink servers:

      The following is an example of an import file that contains two MobiLink server resources.

      ml,demo2,DBA,sql,localhost
ml,demo4,DBA,sql,localhost,0,tcpip,N

    • CSV file format for MobiLink server farm resources  

      Position in the line Term name Description
      1 Resource type

      Type mf to indicate that the resource is a MobiLink server farm.

      This term is required.
      2 Resource name Specify the resource name as it will appear in the Monitor. This term is required.
      3 MobiLink server name

      Specify the MobiLink server resources that are to be included in the MobiLink server farm. List the MobiLink server resources as a comma delimited list. This term is required.

      MobiLink server farm:

      The following is an example of an import file that contains two MobiLink server resources and a MobiLink server farm resource.

      ml,demo2,DBA,sql,localhost
ml,demo4,DBA,sql,localhost,0,tcpip,N
mf,collection_demo,demo2,demo4

    • CSV file format for Relay Server farm resources   For terms that are optional, any preceding terms (including other optional terms) must be specified. For example, if you want to specify the Monitoring URL suffix, you must also specify the port number.

      Position in the line Term name Description
      1 Resource type

      Type rf to indicate that the resource is Relay Server farm.

      This term is required.
      2 Resource name Specify the resource name as it will appear in the Monitor. This term is required.
      3 Host (Relay Server farm) Specify the hostname or IP address of the computer on which the server is running. You can use the name localhost to represent the current computer. This term is required.
      4 Port (Relay Server farm) Specify the port number on which the Relay Server farm is running. This term is optional. The default value is 0.
      5 Monitoring URL suffix

      Specify the URL suffix to locate the monitoring agent on the Relay Server farm. This term is optional.

      6

      Is HTTPS?

      Specify True for the Monitor to use HTTPS to connect to the Relay Server farm. This term is optional.

      The default is False.This term is optional.

      7

      Username for HTTP authentication

      If required, specify the HTTPS authentication user name. This term is optional.

      8

      Password for HTTP authentication

      If required, specify the HTTPS authentication password. This term is optional.

      The following is an example of an import file that contains two MobiLink server resources, a MobiLink server farm resource, and a Relay Server farm resource. 

      rf,rf_demo,rstest02.website.com

  2. Log in to the Monitor as an administrator.

  3. Click Administration.

  4. Click Resources.

  5. Click Import.

  6. Locate the CSV file and click Open.

    The resources from the CSV file are added to the Monitor and monitoring starts.

  7. Click Close.

  8. Click Close.

  9. The imported resource is added to the Resource List in the Overview dashboard.

Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1