Database Connections


The Database Connections screen displays a list of all the connections that are currently open to databases and the driver of origin. For each connection the currently active request will be displayed.

Column definitions

Connection Headers

Request Headers

Controlling Connections

Closing a connection

To close a connection click once on it. A popup menu will be displayed. Choose Close Connection. The connection will then be closed. If a request for this database comes in a new connection will automatically be opened by JaggServer and subsequently displayed on this screen when it is refreshed.

Adjusting the screen refresh interval

To adjust how often the connection list is refreshed click on a connection and choose Refresh Every from the popup menu. Then select the desired interval. The connections screen will then automatically refresh at the new interval. The screen will only refresh if it is visible. If another tab in the menu system is selected refreshing will not occur until the Server Manager is reselected and the Database Connections tab is selected. The screen will also automatically refresh each time the Database Connections tab is selected. Note that refreshing the screen continuously can cause an unnecessary load on the server. The default refresh rate is 60 seconds.

Controlling Requests

Holding and releasing a request

To hold a request that is currently running click once on it. A popup menu will be displayed. Choose Hold from the menu. The request is now held. To release the request click on it and choose Release from the popup menu. It is now once again active.

Killing a request

To kill a request that is currently active or held click once on it. A popup menu will be displayed. Choose Kill from the menu. The request will be killed. Note that there is no confirmation dialog when killing requests.

Adjusting the request priority

To adjust the request priority click once on the request. A popup menu will be displayed. Choose Set Priority and choose the desired priority. 10 is the highest priority, 1 is the lowest. That is, requests running at priority 10 will receive more system resources than those running at a lower priority.

Displaying details of a request

To display a detailed description of a request click once on the request. A popup menu will be displayed. Choose Display Details from the menu. The detail for the request will be display in the lower half of the screen. To hide the request details press the Hide Details button at the bottom of the screen.