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:
The c-treeACE Server supports high-level database management, including:
The c-treeACE Server Administrator has the following areas of responsibility, each of which could be divided among several people:
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.