Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » Database monitoring » SQL Anywhere Monitor » Tutorial: Monitoring resources with the Monitor

 

Lesson 6: Closing database connections

Close a connection to a resource database.

Prerequisites

This lesson assumes that you have completed all preceding lessons. See Lesson 1: Logging in to the Monitor.

This lesson assumes that you have the roles and privileges listed in the Privileges section at the start of this tutorial: Tutorial: Monitoring resources with the Monitor.

 Task

  1. Open the demo16 dashboard.

  2. In the Connections widget, click the x beside the name of the connection you want to close.

    Connections widget

  3. When you are prompted for the required authorization, in the User ID field, type DBA, and in the Password field, type sql.

    The Monitor uses the user ID and password to connect to the resource database and drop the connection. This user ID must have DROP CONNECTION system privilege. The user ID and password are not kept by the Monitor.

  4. Click OK.

    The connection is removed from the Connections widget.

Results

A connection is closed.

Next

Proceed to Lesson 7: Stopping monitoring of resources.

Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0