Services

Management ‣ Services

Services run a database. Normally you will run services on a main server and client computers will connect to this service. The service can be on the same computer as clients in single user systems or remote desktop environments.

The service screen generates a service prefixed with “Adaptive Server Anywhere” in the Administrative Tools, Services application. Normal windows administration tools can be used to start and stop these services once created.

The services screen has a list of services set up on the computer in a grid and a number of buttons below.

The buttons perform the following functions:

Start:

Starts a service running, it will only start a service if the selected service is not running.

Stop:

Stops a running service.

New:

Create a new service, see below for more details.

Modify:

Edit an existing service. Making changes to an existing service will stop it from running.

Database State:

Database state shows all the databases that are running on the service. An individual database on the service can be stopped. For example, you may want to stop a test database to copy in backup without stopping the live database.

The “Create ODBC” option will save the connection details for the database to a file that can be loaded on the ODBC Connections screen. This can be useful to load ODBC details onto client computers.

Delete:

Removes the service from the list of services.

Editing a Service

The new or modify button shows the edit screen for services. The following fields can be edited:

Name:

This will be the name of the service. This name is not used for any connection purpose, rather is used to refer to the service in the Administrative Tools services applet.

For example, if you use the name: prod. In the Services applet, the service will have a description of “Adaptive Server Anywhere - prod” and a name in the Services applet of ASANYs_prod.

Description:

The description will be saved together with the service and has no use outside the service definition.

Type:

Generally this will be set to Network. Standalone services can be used for single client systems, but Network will make the service available for wider use.

Startup:

One of Automatic, Manual, Disabled. This is the Start up type that is set on the Administrative Tools, Services application. Normally the startup will be automatic, so the service re-starts on reboot.

Port:

Normally this will be blank, the first service to start will normally use port 2638. Multiple other services will be assigned available ports after 49152 if port 2638 is unavailable.

You may want to specify the port if you are setting up multiple services. If left blank, the port may vary depending on the ports available when a service starts.

Server Name:

This is the name given to this database server when connecting. This is not the machine name nor is it the service name, rather it’s just the name used by client connections to identify the service.

On a network, the server name will generally need to be unique as on start, a server will broadcast looking for database services with the same name.

Extra Parameters:  

In this box you can specify additional parameters controlling issues like memory usage or networks, but generally these are not needed.

Login Settings:

Generally the service will run under the Local System Account, but you can specify a particular windows account and password if you want to run the service under a particular user.

Database Grid:

You can run multiple databases on a single service. The grid will list each database name as well as the path to the file.

You can add an additional database to the grid with the name and database file option at the bottom of the service. After entering the details click “Add Database” to add the database to the grid.

When connecting to a database, the ODBC connection with connect to a particular Server Name/Database name pair.

The “Create ODBC” button on this screen can be used to save the ODBC connection details to a file. This can subsequently be loaded into client computers using the “Load from File” option on the ODBC Connections screen.

The following buttons are available at the bottom of the screen:

Import:Allows you to import details of the service from a file. For example, if you are transferring the database to a new machine, you can import the details of the service you previously saved using the “Export” button. Export:Saves details of the service to a file so they can be loaded later. Save:Saves changes to the service back to the list of services. New:Creates a blank form to enter a new service from scratch. Cancel:Undo any changes and exit the screen.