FrontBase logo

FrontBase Documentation

FrontBase logo

Updated: 20-Nov-2000
Table of Contents

4. Administering a FrontBase Server

FrontBase is designed to be "zero-maintenance", and for many applications, starting up a database may be all you need to do. More advanced or critical applications may involve managing user, backing up, keeping your installation current, tuning, and other tasks. These tasks are designed to be simple and straight-forward. This section explains how to do them.

Section/Article Description
4.1. FrontBase-Related Processes This section describes the three main processes which execute in a FrontBase installation: FBExec, FrontBase, and FBWebEnabler. It explains how to detect if FBExec or FBWebEnabler are running and how to restart them if necessary. It also describes command-line options which specify behavior of FrontBase server processes.
4.2. FrontBase Directory The FrontBase directory contains all the files required for your FrontBase installation. The files are subdirectories of the FrontBase directory are explained in this article.
4.3. Adminstration Tools This section introduces the three primary tools for administering your FrontBase server: the sql92 command-line tool, the web-based FBWebManager tool, and the FBManager application (for MacOS X and Windows NT only).
4.4. Basic Administration This article explains how to execute basic administration tasks, including creating/deleting databases, starting/stopping databases, setting database passwords, managing users, and creating white/black ("whiskey") lists.
4.5. Removing FrontBase Should you ever need to completely remove FrontBase from your computer, this article describes how to do that.
4.6. Keeping Current FrontBase is continually improved. This article describes how to ensure that you are running the latest version and upgrade your FrontBase server as needed.
4.7. Understanding Transactions This article describes the database concepts of transactions, isolation levels, locking discipline, and updatability as implemented by FrontBase to manage simultaneous access.
4.8. Row Level Privileges This article explains how to invoke and use Row Level Privileges.
4.9. Backup and Restore This section describes how to backup to and restore from FrontBase flat files.
4.10. Tuning FrontBase As your FrontBase database gets large or your performance demands increase, you can tune FrontBase to improve overall and specific-query performance. This section describes how to tune FrontBase using the Raw Device Driver feature (overall performance) as well as table and index caches (specific query performance).
4.11. Replication and Clustering This article explains clustering and replication, which are useful for both redunancy (protect from downtime when a server becomes unavailable) and load distribution (increase response time in heavy load situations).
4.12. Migration This section explains how to use FrontBase's import features to migrate databases from other vendors' database servers.
4.13. Indexing FrontBase offers two strategies for maintaining indices: PRESERVE SPACE and PRESERVE TIME. This article explains these strategies and how to use them.

If you have feedback or questions on this document, please send e-mail to Please reference the section number and topic. Thanks!!

©2000 FrontBase, Inc. All rights reserved.