Viewing Consolidated Database Properties

Review the consolidated database (CDB) properties that allow Unwired Server to connect to the database.

You cannot use Sybase Control Center to configure CDB properties. .
  1. Open Sybase Control Center.
  2. In the left navigation pane, expand the Servers folder and select a server.
  3. Select Server Configuration.
  4. In the right administration pane, click the Consolidated DB tab.
  5. Review these properties:
    • Database Thread Count – the number of worker threads used for the CDB. The default value is 20 threads. However, if you are experiencing performance issues, especially in a clustered environment, you may need to increase this value.

      For a SQL Anywhere CDB only, use this formula to estimate a new value:

      Value = Number of nodes in cluster * (sync threadcount + 1) + Number of scheduled EIS fetches + 10

      For example, if you have been using the default synchronization thread count of 20, but have added three Unwired Servers to your cluster, adjust the CDB thread count to 78 or (3 * (20 +1) + 5 + 10). If you set the value for this thread count to 78 or higher, the value is accepted. However, if you set the value lower than 78, the request is ignored, unless you remove some servers from the cluster or reduce the synchronization thread counts.

    • Database Type – the CDB type; Sybase_ASA for the default SQL Anywhere database.
    • Database DSN Name – CDB DSN name descriptor.
    • Database Name – database name descriptor.
    • Database Server Port – the port over which CDB communication takes place. The default is 5200.
    • Database Password – the database user password. In SQL Anywhere, the default is sql.
    • Database Server Host – the name of the machine where the existing database server is running.
    • Database Server – the name of the database server used to manage requests for the consolidated database. By default, the server is localhost. However, if the database is on another host or is part of a cluster, you may need to use another host name.
    • Database User – the CDB user name. In SQL Anywhere, the default user name is dba.
  6. (Optional) Expand the Show Optional Properties section and review values for these properties:
    • Database Install Type – the type of database installation; either default or custom.
    • Database ASA Mode – the database mode. The value of the first node of a cluster is "primary," the value of the second node is "arbiter," and the value of the third node is "mirror."
    • Database User Options – specify the CDB start-up user options.
Parent topic: Server Administration Overview