Database Administrator's Guide

Next Topic

Introduction to c-treeACE Server Administration

The c-treeACE database server provides a powerful engine you can use in your database-driven applications. This guide explains how to install and operate the c-treeACE Server. Installation is simple as the c-treeACE Server is ready to run right out of the box. This guide explains options explained that allow you to fine-tune this engine your your applications.

This manual has two main purposes for the c-treeACE Server Administrator:

  1. To provide a quick, easy way to see what responsibilities you have, and
  2. To provide the information needed to manage c-treeACE Server operation.

The c-treeACE Server supports high-level database management, including:

  • client/server computing - Increases performance and provides the ability to maintain database integrity, especially in multi-user environments. The basic principle of client/server computing is: applications, or “clients”, interact with the server, which manages file operations and communicates with clients.
  • online transaction processing (OLTP) - The c-treeACE Server can group a specified set of operations, called a “transaction,” and ensure either all of them are done or, if there is a problem, none will be done, e.g., either all of an invoice is processed, or none of it.
  • security controls - c-treeACE Server access is controlled with user IDs, passwords, file permissions, and encryption. Users and files may be added to Administrator defined “groups”, e.g., shipping department, payroll department.
  • database maintenance and utilities - The c-treeACE Server automatically saves necessary information for use in automatic or Administrator-specified backups and recovery from problems.
  • configuration flexibility - From basics such as which communication protocol the c-treeACE Server uses and memory allocations to enforce for specific users, to a wide range of advanced controls.

The c-treeACE Server Administrator has the following areas of responsibility, each of which could be divided among several people:

1. Installation

Someone, not necessarily the Administrator, must physically load the c-treeACE Server software onto the computing environment. Once completed, installation issues usually are no longer a concern unless the c-treeACE Server needs to be re-installed, for example, to install a new version. See Server Quick Start for details.

2. Operating the c-treeACE Server

Starting and stopping the c-treeACE Server: Any user can start the c-treeACE Server by running the executable module, ctreesql (or ctsrvr for non-SQL versions), as any other program in the environment. See c-treeACE Server Operation for details.

3. Controlling access to the c-treeACE Server

Begin by setting up valid User IDs and passwords (including your own). Establish rules of access to given database files. Establish groups where users and files can be associated and control access according to membership in those groups.

Use the graphical c-treeACE Monitor (c‑treeMonitor.jar) or the command-line version (ctadmn) to control access with user IDs, file passwords, file permissions, and Administrator-defined groups with specified access rights to particular files. Documentation about the graphical tools is available in the book titled Java-Based GUI Tools on the FairCom website. Details about the command-line tools is available on the FairCom website in the book titled Command-Line Tools.

ctpass is used by the Administrator or any other authorized user to change the password associated with their User ID.

ctfile is used by the Administrator or any user to change file security information on any file owned by the user. See Controlling c-treeACE Server Access for details.

4. Maintaining Database Integrity

Schedule and conduct backups or dumps of system generated files for later use in recovering from problems or returning a database to its status at a prior time. See Backups and Database Integrity for details regarding the tools discussed in this section.

Use the utility ctdump to schedule dynamic dumps that can be used at a later time to restore database files or to roll back to a state at a previous point in time.

ctrdmp works with information saved in a dynamic dump to either recover from a catastrophic system failure by restoring specified files to a consistent, well-defined state or to roll back specified files to their state at a specified time.

Use the utility ctfdmp to recover from a catastrophic failure using a previously saved dynamic dump or complete backup, which may be made using any standard backup utility. This allows you to restore backups then ‘roll forward’ to a given time using preserved log files.

(For programmers) Use the ctldmp utility to carry out a transaction log dump, which records partial log-related information, for use in application development.

5. Configuring the c-treeACE Server

Understand how the c-treeACE Server is currently configured and, optionally, change configuration settings (e.g., to set memory allocation limits, to select communication protocols, to activate a particular dump description script).

The c-treeACE Server is started by any user authorized to start ctreesql (or ctsrvr). Routine starting of the c-treeACE Server is not necessarily a major responsibility for the Administrator.

The User ID “ADMIN” (default password is “ADMIN”) and members of the ADMIN group are the only users who can access ctstop, the utility for stopping the c-treeACE Server, so stopping the c-treeACE Server is always a major Administrator responsibility.

6. Customize the c-treeACE Server

No configuration file is required, but if the c-treeACE Server is to be reconfigured to replace any default settings, a file named ctsrvr.cfg must be created for the server to load at startup. See Configuring the c-treeACE Server for details.

Note: Utility names and methods of executing them may vary slightly in different environments, so see the individual sections in this manual for specifics.

The basic topics covered here are for orientation only. Installation and Operating the c-treeACE Server, are considered required reading for c-treeACE Server Administrators. c-treeACE Server Access Configuration, Backups and Database Integrity, Configuration File Format, and Basic Keywords are recommended reading. The rest of c-treeACE Configuration Options is optional and intended for advanced users.

In This Chapter

Server Quick Start

Advanced c-treeACE Server Features

Client/Server Computing