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