Managing an Adaptive Server

Sybase Control Center allows you to register and authenticate a running Unified Agent, start and stop your server, and view the server error log.

1. In the Perspective Resources view, select a resource, then select Administration Console.
2. Click ASE Servers.
   You see a list of monitored servers.
3. Click the Name field of the server you want to manage.
   You see a list of options allowing you to start and stop the server, register the agent, and so on.
4. (Optional) To register the Unified Agent, click Register Agent. To clear agent registration, click Clear Agent Registration.
5. (Optional) To authenticate the Unified Agent, click Authenticate Agent. To clear agent registration, click Clear Agent Authentication.
6. (Optional) To start the Adaptive Server, click Start Server.
7. (Optional) To stop a running Adaptive Server, click Stop Server.
8. (Optional) To view the error log of an Adaptive Server, click View Log. You can further choose to filter the error log.
9. (Optional) To view the properties of the Adaptive Server and agent, click Properties.

• Executing SQL Statements
  Use Sybase Control Center to execute SQL statements on a monitored Adaptive Server.
• Registering the Unified Agent for an Adaptive Server
  Use the Adaptive Server Administration Console to register the Unified Agent by providing the host name and port number.
• Authenticating the Unified Agent
  Authenticate the Unified Agent using the Authenticate Agent option in the Adaptive Server Administration Console.
• Starting an Adaptive Server
  Start an Adaptive Server using the Start Server option in the Administration Console.
• Stopping an Adaptive Server
  Shut down an Adaptive Server using the Stop Server option in the Administration Console.
• Viewing and Filtering the Adaptive Server Error Log
  Apply filters and view the Adaptive Server error log.
• Server Properties
  Use the server Properties wizard to view server and agent information, to configure the agent, and to stop or restart the server.