ADMINISTRATOR INTERFACE
 
Previous Chapter: User Interface
Next Chapter: SQLAPP4-A Client Application
 

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? 
 
 

 
Caption admin-1 Administrator's 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.
 
 

Connection 0


admin 1998-10-15 18:11:59
Num From On since Idle since User Status Waitcount Delivered
0 Internal  1998-10-15 18:03:49 1998-10-15 18:08:50 ADMIN Ready 0 0
Statements
 
Num Status State Isolation level SQL
0 Active Cursor READ COMMITTED  select TABLES_0.table_id, TABLES_0.owner, TABLES_0.table_name, TABLES_0.table_type, TABLES_0.check_constr from SYS.TABLES as TABLES_0
Please note that this is volatile information and may have changed even while generating this page
 
Caption admin-2  Connections screen.

One connection with the relevant statement link expanded is shown here.

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.
 
 

HTTP Sessions


admin 1998-10-22 16:40:19
 
Id From On since Idle since Initial User User Realms
39761E76 194.219.34.132 1998-10-22 16:38:22 1998-10-22 16:40:22 admin admin  
79C9F272 127.0.0.1 1998-10-22 16:39:36 1998-10-22 16:39:43 admin admin /sqlterminal
394C58D5 194.219.34.132 1998-10-22 16:39:56 1998-10-22 16:39:56 admin admin /roadmap 
435C2556 194.219.34.132 1998-10-22 16:40:10 1998-10-22 16:40:10 admin admin  
Please note that this is volatile information and may have changed even while generating this page
 
Caption admin-3.  HTTP Sessions

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.

 
Caption admin-4. Threads

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