4. Administering a FrontBase Server
4.3. Adminstration Tools
Table of Contents
FBManager.app lets you monitor and control the state of FrontBase servers, i.e. whether they are running or stopped. When the FBManager.app is started for the first time by a given user, the following two windows appear:
The first window is called Icon View and shows monitored databases as icons indicating the state of the database together with the name of the database and the host computer on which the database is located. The example above shows the databases Movies and Test on host mars. The second window is called List View and shows the same databases as rows in a tableview. Whether you use the icon view or the list view for administering databases is up to you. Which windows appear at application startup can be specified in the preferences panel.
You can open these windows at any time by clicking on the corresponding items in the File menu. To add existing databases to the monitor view(s), choose Database->Monitor... from the menu. The following panel appears.
The first column of the browser shows all currently monitored hosts. The second column shows all existing but not yet monitored databases on the selected host. To monitor databases on a not yet shown host simply enter the hostname in the textfield below the browser and press Return. To add a database to the monitor view(s) select the database in the browser and click on Select. You can also add multiple database at once. You can remove a database from the monitor view(s) by selecting it and choosing Database->Demonitor from the menu.
A database can assume 5 different states:
To start a database that is not yet running select it in any monitor view and choose Database->Start or Database->Start Advanced from the menu. In the first case the database is simply started and the cylinder should become green within 1-2 seconds. In the second case the following panel appears allowing you to specify options before the database is started.
If you for example check the box next to Log SQL statements, all sql statements send to the database are logged in a file <databasename>.fb.log. You can now connect to a database by either choosing Database->Connect from the menu or simply doubleclicking on a database icon. If you doubleclick on a not yet startet database, it is started automatically. Whether it is started in advanced mode - allowing you to specify options - or not depends on your selection in the preferences panel. After making sure the database is running the following panel is raised.
Enter a username and a password and/or database pasword if any in the corresponding fields and click on "Connect". You can also select a user from a list of usernames that have been used at earlier connects. If you connect to the database for the first time (e.g. immediately after creating it), only superuser _SYSTEM is offered. If a connection can be established, the following management window appears:
Note that the database, the user, and the host are shown in the title of the management window. You can have an arbitrary number of connections to the same database at once. Please note the "Show Log" button in the top right corner. A click on this button orders a log window to the front that shows all SQL statements that are sent to the database while working on the pages of the management window.
If you have feedback or questions on this document, please send e-mail to firstname.lastname@example.org. Please reference the section number and topic. Thanks!!
©2000 FrontBase, Inc. All rights reserved.