Managing an Adaptive Server

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

1. In the Perspective Resources view, select a resource, click the drop-down arrow that appears next to the name, and select Administration Console.
2. Click ASE Servers.
   You see a list of monitored servers.
3. Select the server you want to manage and click the drop-down arrow that appears next to the name.
4. (Optional) To register the agent, click Register Agent. To clear agent registration, click Clear Agent Registration.
5. (Optional) To authenticate the 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 one or more Adaptive Servers.
• Registering the Agent for an Adaptive Server
  Use the Adaptive Server Administration Console to register the remote command and control agent.
• Authenticating the Unified Agent
  For Adaptive Server versions 15.7 and earlier. Authenticate the Unified Agent using the Authenticate Agent option in the Adaptive Server Administration Console.
• Authenticating the SCC Agent
  For Adaptive Server versions 15.7 ESD1 and later. Authenticate the SCC 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.
• Configuring Retrieval Thresholds for the Administration Console
  Set limits on the time the Administration Console waits for data to load or on the number of rows it loads.
• Browsing and Managing Resources
  Create new resources or browse and manage existing resources.
• Searching for Objects in Adaptive Server
  Search for a list of objects based on the resource, resource type, object type, and name.
• Adaptive Server Error Log
  Server messages are written to an error log which can provide information about various aspects of the server, such as connections, database objects, syntax, semantics, and permissions.
• Server Properties
  Use the server Properties wizard to view server and agent information, to configure the agent, and to stop or restart the server.
• Enabling Granular Permissions
  Granular permissions enable you to grant system privileges; allowing you to construct site-specific roles with privileges to match your requirements, and restrict system administrators and database owners from accessing user data.
• Activating a Role
  The System Security Officer or user can determine whether to activate roles granted by default at login.