FrontBase Documentation

Backtrack:
Welcome!
Updated: 20-Nov-2000
prev — next
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 doc-feedback@frontbase.com. Please reference the section number and topic. Thanks!!