Installation Overview

This section provides an overview to the components that make up Pervasive PSQL v9 Service Pack 2. Also included in this section is information on the files included in the different types of installation.

Major Components of Pervasive PSQL v9 Service Pack 2

Pervasive PSQL v9 Service Pack 2 consists of the following components:

Pervasive PSQL v9 Service Pack 2 Database Engine

Pervasive PSQL v9 Service Pack 2 consists of two database sub-engines:

MicroKernel Database Engine (MKDE), which provides Btrieve/MicroKernel API support for Pervasive PSQL applications

SQL Relational Database Engine (SRDE), which provides ODBC/SQL API support for Pervasive PSQL applications

Note
The Pervasive PSQL v9 Service Pack 2 stand-alone client install is not included in the Workgroup edition of Pervasive PSQL v9 Service Pack 2. Each installation of Workgroup edition includes all client components, so a separate install is not needed.

Client

Requesters that allow you to access the server-based MicroKernel from a DOS client, a Windows 98/ME client, or a Windows 32-bit client.

The 16-bit requesters used in DOS clients are Btrieve requesters only and have no relational access.

Pervasive PSQL v9 Service Pack 2 Utilities

Pervasive PSQL v9 Service Pack 2 includes a suite of useful utilities for every phase of database management from engine installation and configuration to data maintenance. They include the following:

Pervasive System Analyzer (PSA)

Pervasive PSQL Control Center(PCC)

SQL Editor

Table Editor

Configuration properties for client and engines

Monitor

Function Executor

Maintenance

Rebuild

License Administrator

ODBC Administrator

Gateway Locator

Printed Documentation

Individual manuals, and the complete set, are available for purchase through the Pervasive Web site or through the Pervasive Software Sales Team. To order, contact Pervasive Software online at http://www.pervasive.com/ecommerce/Scripts/default.asp, e-mail salessupport@pervasive.com, or telephone 1-800-287-4383.

Online Documentation

The complete Pervasive PSQL v9 Service Pack 2 documentation set is provided in Javahelp format. This help also serves as the context-sensitive help for the Pervasive PSQL Control Center.

Documentation Titles

The following titles are included in the online library and are available for purchase in hardcopy:

Getting Started with Pervasive PSQL (Server and Workgroup Editions)-helps you to get Pervasive PSQL running with installation, setup, and basic configuration information based on your operating environment.

Pervasive Products and Services-provides an overview of Pervasive Software products and services, including support options and information regarding licensing and registration. This manual also describes the database and product architectures.

Pervasive PSQL User's Guide-gives basic information on the utilities provided with the Pervasive PSQL Control Center, including several interactive wizards designed to help you accomplish basic database tasks. This manual also contains information on the Linux version and the utilities available for that particular platform.

SQL Engine Reference-provides database programmers a complete reference guide to the SQL relational database language supported in Pervasive PSQL v9 Service Pack 2.

Advanced Operations Guide-explains tasks typically performed by Network or System Administrators, using various tools such as the Rebuild, Maintenance, Monitor, and Function Executor utilities.

Status Codes and Messages-lists the error and informational codes and messages that can be received when using Pervasive software.

Installation Options

Pervasive PSQL v9 Service Pack 2 offers Complete and Custom installation options. You can accept default installation parameters by selecting the Complete install, or you can specify certain installation parameters by selecting the Custom install option.The following sections outline the major differences in these two installation options.

Complete Setup Installation

The Complete installation is recommended for most users. This option takes default actions for most operations performed during the installation.

The Complete setup installs the following components:

Pervasive PSQL v9 Service Pack 2 Engine (including ODBC interface)

Pervasive PSQL Control Center and other utilities

Transactional and Relational interfaces

Online documentation in Javahelp format

Custom Setup Installation

Selecting Custom setup type allows you to specify the program folder name and select the components to install.

During a Custom setup, the following components are optional:

Pervasive PSQL Control Center and Javahelp documentation

Other Utilities (except for a minimum set)

The default installation location for Pervasive PSQL v9 Service Pack 2 is C:\PVSW, assuming the Windows system drive is C.

Installing Over a Previous Version

If you install the Pervasive PSQL Workgroup product over a previous version (update the product), be aware of the following:

An upgrade re-creates the system databases TEMPDB and SYSTEMDB, and the sample database DEMODATA. The upgrade removes all dictionary files and data files associated with TEMPDB, SYSTEMDB, and DEMODATA, including ones you may have added.

If the system database DEFAULTDB exists from a previous installation, it is retained as is. An upgrade does not re-create DEFAULTDB if it already exists.