The Administrator's Console is a Web page, designed specifically to allow administrators an easy database monitoring.

As is the case with SQL Terminal, the Administrator's Console, although having a URL address, is not a real HTML file, but a part of code written in the server. See also Special URL Addresses in the HTTP Server.

Users can go to the Administrator's Console either by using the Console link of the SQL Terminal (if they had logged in as admin) or by choosing directly the Administrator's Console from the database home page. The initial administrator id and password are admin and pegasus respectively.
 
 

Home  .  Console home Log file Connections HTTP Sessions Threads  Shutdown Console home admin 1998-10-15 18:04:58 How do I operate the console?

Description of the Console Page

Home: Leads to the first connection screen, which is the home page for the database interface.

Console home: Leads back to the home console screen.

Log file: Displays the log file of the database where the user is connected. There are three kinds of messages: Info, Warning, and Error.

Connections: Displays connection information.

HTTP Sessions: Displays HTTP session information.

Shutdown: Closes the database server.

How do I operate the console? A link to this manual page.
 
 

Connections
Displays connection information as shown in caption admin-2.
 
 

Explanation of table entries.
 

Num	The connection ordinal number.
From	Internal or other source.  A connection may be established from the SQL Terminal or from a Scheme script, in which case it is considered internal. Or it may be established from any other source in which case it is considered external.
On since	Time stamp marking the beginning of the connection.  e.g. 1998-10-15 18:03:49
Idle since	Time stamp marking the time since the connection is idle.  e.g. 1998-10-15 18:08:50
User	The user name used for the connection
Status	Shows if the connection is ready to serve another request
WaitCount	The number of times a command under execution has had to wait
Delivered	The number of messages delivered through the connection
Stmts	How many statements there are  The last entry is a link which leads to a table of statements

 

When the Stmts link is expanded, another table, showing the executed statements is displayed. Among others, the Isolation level and the SQL statement are displayed here. Note that the SQL statement is in a slightly processed form in contrast to the original command typed. See also, the SQL compiler.
 
 

HTTP Sessions

The maximum number of HTTP connections is not the same as the number of the allowed connections, but may depend on it. Therefore, it may be useful to the system administrator to have information about the status of connections available.
The HTTP sessions page displays session information as shown in caption admin-3.
 
 

Explanation of table entries
 

Id	The session id
From	The computer address that made the call for the session
On since  Idle since	The time stamp marking the beginning of the session  e.g. 1998-10-22 16:38:22   The time stamp marking the time from which on the session was idle  e.g. 1998-10-22 16:40:22
Initial User	The user who initially logged in
User	The current session user
Realms	Realms are the /roadmap  and the /sqlterminal  Realms appear if the session user has visited these links.  If there is a realm, there is also a link that leads to this URL address.  Administrators may use the /sqlterminal page and shutdown the SQL connection if they notice that the session has remained idle for too long.

 
 

Threads

This screen displays thread usage information as shown in caption admin-4.

Explanation of table entries

Notice that the number and type of threads is in accordance with the thread parameters.
 

Id	Thread ordinal number
Kind	A thread may be either TCP or HTTP or SQL
Status	The thread status is either Idle or Busy
User	The current user of the thread (if the thread is busy)
Relevant link	If the thread is currently serving a request, the relevant link leads to the appropriate connection point

 
 

Shutdown

This option stops the database server. If  the database has open connections, a warning is issued about the fact and the number of running connections. The user may choose to return to the SQL Terminal to disconnect or to force the shuting down of the database through the administator console. In this case, all uncommited transactions will be rolled back.
 
 

Previous Chapter: User Interface

Next Chapter: SQLAPP4-A Client Application