Manual Organization

---

The following list briefly describes each chapter in the manual:

• Chapter 2-Concepts of Database Maintenance

This chapter provides a brief introduction to the basic concepts and procedures involved with the job of maintaining a database.

• Chapter 3-Understanding the Pervasive Component Architecture

This chapter explains in some detail the major components that make up Pervasive.SQL and some of their unique features.

• Chapter 4-Changing Your Configuration

This chapter explains how to use the graphical utility named Configuration and how to tune database engine performance.

• Chapter 5-Configuration Reference

This chapter provides detailed information about all of the available configuration options for engines, 32-bit clients, and 16-bit clients.

• Chapter 1-Pervasive.SQL Databases

This chapter explains internal database names, public Data Source Names, and the limits on identifiers, such as table names, within a database.

• Chapter 6-Setting Up Referential Integrity

This chapter explains how to setup referential integrity rules to enforce the internal consistency of related data.

• Chapter 7-Pervasive.SQL Security

This chapter explains Btrieve security and SQL security and how the two schemes interact.

• Chapter 8-Logging, Backup, and Restore

This chapter describes how to develop a regular backup procedure to ensure your data is protected, and how to restore from backup if necessary.

• Chapter 9-Server High-Availability Support

This chapter describes how Pervasive.SQL works with cluster services and SFT III for NetWare.

• Chapter 10-Workgroup Engine in Depth

This chapter provides technical details and advanced procedures regarding the Workgroup engine.

• Chapter 11-Monitoring Database Resources

This chapter explains how to use the graphical utility named Monitor to view users connected to a database, file usage information, and resource usage information.

• Chapter 12-Testing Btrieve Operations

This chapter explains how to use the utility named Function Executor to perform individual Btrieve operations.

• Chapter 13-Adding Relational Access to Btrieve Files

This chapter explains how to create DDFs for existing Btrieve files so that they can be accessed via ODBC.

• Chapter 14-Manipulating Btrieve Data Files with Maintenance

This chapter covers the graphical utility named Maintenance and the variety of functions it provides.

• Chapter 15-Converting Data Files

This chapter covers the graphical utility named Rebuild and its functions, such as upgrading the file format version of a Btrieve file.

• Appendix A-Description Files

This appendix covers how to use description files to archive information about Btrieve data files you have created.

This manual also includes an index.