Managing an SAP ASE server

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 server, click Start Server.
7. (Optional) To stop a running the server, click Stop Server.
8. (Optional) To view the error log of a server, click View Log. You can further choose to filter the error log.
9. (Optional) To view the properties of the server and agent, click Properties.

• Executing SQL Statements
  Execute SQL statements on one or more servers.
• Registering the Agent for an SAP ASE Server
  Register the remote command and control agent.
• Authenticating the Unified Agent
  (SAP ASE versions 15.7 and earlier) Authenticate the Unified Agent using the Authenticate Agent option in the Administration Console.
• Authenticating the SCC Agent
  (SAP ASE versions 15.7 ESD #1 and later) Authenticate the SCC Agent using the Authenticate Agent option in the Administration Console.
• Starting an SAP ASE Server
  Start an SAP ASE server using the Start Server option in the Administration Console.
• Stopping an SAP ASE Server
  Shut down an SAP ASE Server using the Stop Server option in the Administration Console.
• Configuring Retrieval Thresholds for the Administration Console
  Set limits on the length of time the Administration Console waits for data to load or on the number of rows it loads.
• SAP ASE Error Log
  Server messages are written to an error log that can provide information about various aspects of the server, such as connections, database objects, syntax, semantics, and permissions.
• Server Configuration
  Display and monitor SAP ASE configuration values.
• Server Properties
  Use the Server Properties window to view server and agent information, to configure the agent, and to stop or restart the server.
• Activating a Role
  The system security officer or user assigned the role can determine whether to activate roles granted by default at login.
• Managing Permissions
  Grant or revoke command permissions or object permissions to or from users, groups, or roles.
• Replacing Compiled Object Definitions
  Replace existing compiled objects with a new definition while preserving the original name, object ID, auditing options, and permissions.