Database
Tools for FirstSQL/J
Both Professional and
Enterprise Server products
include
interactive SQL utilities and MaintGI tools for maintaining physical databases;
• Maint and MaintGUI
The Maint tools provide a single, easy interface to copy and backup physical databases, including online backup, restore a database, and build a new physical database.
• Ijdbc and IjdbcWin
is a Java AWT program
providing interactive
GUI access to JDBC drivers
and connections to the
database. It reads SQL
and DDL commands and
executes them with JDBC.
IjdbcWin produces formatted
output of the results
of each command. It
formats possibly multiple
result sets from queries
and stored procedures
in grid form.
• Ijdbc operates
with a command-line
interface to the database.
FirstSQL/J Enterprise
Server also includes
the following tools;
• GUI Administrator
-- Full package
of administrative capabilities
in one application,
including server startup
and shutdown and server
session control.
• AdmOptions Utility
-- Application for creating
and editing property
files for the GUI Administrator.
• Monitor --
Dynamic charting of
server activity, plots
a wide variety of elements
-- connects, SQL statements,
open tables, row access,
physical page read/write,
memory usage.
• Administrative
API – Set of classes
that support direct
administrative access
for controlling the
server.
The GUI Tools are
AWT applications for
administering the FirstSQL/J
Enterprise Server. The
tools runs locally (on
the server machine)
or remotely.
GUI Administrator
The GUI Administrator
is an AWT application
for administration of
the FirstSQL/J Enterprise
Server. It can run as
an application or as
a browser applet. The
GUI Administrator provides
an interactive interface
for performing all administrative
tasks. The administrative
tasks are:
• Server Control
o Display overall status
and server log
o Server startup
o Server shutdown
o Server startup configuration
• Session Control
o Display session statistics
and current sessions
o Rollback and kill sessions
o Control and resolve
deadlock
The Administrator
is configurable with
Java property files.
It can be configured
to provide a subset
of administrative services,
such as, session control
only. A separate application,
AdmOptions, allows maintenance
of the administrator
configuration.
AdmOptions Utility
The AdmOptions utility
provides creation and
maintenance of administrator
properties files. It
is an AWT tool and is
implemented with GUI
Components described
in a separate section
- GUI Administrative
API. AdmOptions provides
a single window containing
the administrative properties:
• Server Control -
mode for server control,
choices:
o None - no server control,
o Shutdown - server
shutdown only,
o Startup - server startup
and shutdown, or
o Startup Options - same
as Startup but also allows
changing startup options.
• Session Control - mode
for session display and
control, choices: o None
- no session display or
control,
o Display - display session
information,
o Control - allow kill
and rollback of session,
or
o Deadlock Control - same
as Control but also allows
acquistion of deadlock
resolution control.
• Server Properties -
designation of properties
file for server startup.
o Login Properties - designation
of properties file for
login defaults.
o Automatic Login - if
the Administrator is only
going to be used for server
startup.
• Log History Limits -
the value specifies the
number of lines of server
log history to save.
• Title - text of title
bar for the main administrator
window.
GUI Monitor
The GUI Monitor is
an AWT application for
monitoring server activity.
It plots selected activities
on a time-based graph.
The Monitor runs locally
(on the server machine)
and remotely. It can
run as an application
or as a browser applet.
The Monitor provides
2 modes for displaying
server activity:
• Chart -- plots selected
activities against horizontal
time line.
• Statistics -- displays
current value for each
server activity.
The Monitor provides
Enterprise Server statistical
activity on connections,
memory usage, pages,
files, rows, SQL calls,
and transactions.
Administrative API
The Administrative
API is a set of classes
that support administrative
access to the server.
It is similar in overall
structure to JDBC. An
alternate name could
be JDBA (Java Data Base
Administration). The
Administrative API provides
the following interfaces
to the server:
• Administrative Dialog
- send commands to server,
• Administrative Push
- receive server log
messages, and
• Administrative Immediate
- direct communication
with the server for
server startup.
Administrative Dialog
and Administrative Push
establish a communications
link with the server.
They can be used locally
or remotely. Both interfaces
require a connection
to an administrative
user name.
The Administrative
Immediate interface
talks directly to the
server. It must be run
locally, on the server
machine. The Administrator
Immediate interface
loads, starts up and
runs the server.
Copyright 2002 FFE Software,
Inc. All rights reserved
worldwide