Organization

This book is organized into four complementary parts:

Part I, "Database basics," describes the basic commands for creating and deleting, and starting up and shutting down databases, along with detailing database limits:

Describes how to create and delete OpenEdge databases.

Catalogs limits of the OpenEdge RDBMS, including all aspects of database size, operating system limits, naming conventions, and data types.

Describes the commands required to start up and shut down an OpenEdge database.

Part II, "Protecting your data," describes the procedures a database administrator uses to protect a database in a flexible business environment. Each chapter discusses a particular administrative activity:

Discusses various approaches to backing up your database.

Describes the mechanics of backing up your database with the PROBKUP utility.

Examines recovery strategies and how to use the PROREST utility to restore an OpenEdge database.

Presents after-imaging and how to use it for data recovery. Also, describes how to implement after-imaging with after-image extents.

Describes how to implement database security, including assigning user IDs and designating database administrators.

Introduces auditing. How to enable and disable auditing on your database, and what can be audited is discussed.

Introduces Transparent Data Encryption. Describes how to enable and disable transparent data encryption, create encryption policies, and how to maintain a database enabled for transparent data encryption.

Examines replication schemes and how to implement log-based replication.

Explains how to configure and manage a cluster-enabled database.

Explains distributed transaction processing, and discusses support for two-phase commit and the Java Transaction API (JTA).

Part III, "Maintaining and monitoring your database," describes the procedures and tools a database administrator employs to keep a database functioning efficiently:

Discusses how to monitor tune database performance.

Describes methods to manage the database structure and alter it as necessary to improve storage and performance.

Describes the architecture and features of a multi-tenant database.

Describes the architecture and process of table partitioning.

Describes the architecture and features of a table-partitioned database.

Explains how to dump and load databases, including tables, indexes, and sequences.

Examines the process of logging significant database events.

Part IV, "Reference," describes the OpenEdge RDBMS commands, startup parameters, utilities, and system tables. Refer to the chapters in Part IV when you need to access specific descriptive information, such as the syntax of an administration utility:

Catalogs the OpenEdge RDBMS commands for starting up and shutting down database sessions and processes.

Lists and details the OpenEdge RDBMS startup parameters.

Details the PROMON Utility used for monitoring your database.

Details the PROUTIL Utility used for maintaining your database.

Details the PROSTRCT Utility used for creating and updating the physical structure of your database.

Details the RFUTIL Utility used for managing after imaging.

Details other database utilities including PROBKUP, PROREST, PROCOPY, PRODEL, and PROLOG.

Details the utilities used for maintaining your database for use with SQL.

Describes the Virtual System Tables that allow ABL and SQL applications to examine the status of a database and monitor its performance.