Advanced Operations Guide - Table of Contents

Pervasive PSQL v9 SP2 (9.5) (code AOG_950, revision 1)  Books in this release

About This Manual

Who Should Read This Manual

Manual Organization

Conventions

Pervasive PSQL Databases

Pervasive PSQL Database Concepts

Named Database

Identifiers and Object Names

The Default Database and the Current Database

File Structure

Access Methods

Client/Server Communications

ODBC DSN Creation Options

ODBC Connection Strings

Using the idshosts File

Database Properties

Directories

General

Relational Constraints

Security

New Database GUI Reference

Pervasive PSQL Database Tasks

Concepts of Database Maintenance

Configurations

Database Security

Data Archival and Restoration

Troubleshooting

Summary of Pervasive PSQL Utilities

Understanding the Pervasive Component Architecture

Pervasive PSQL Database Engine

Common Address Space

Row Level Locking

MicroKernel Database Engine

SQL Relational Database Engine

Relational Architectural Overview

Pervasive PSQL Relational Architecture: Server

Overview of Smart Components

Component Identification

Unique Component Naming

Dynamic Binding

Pervasive PSQL Event Logging

Syntax

Sample Entry

Error Code Clarification

Diagnosing Load Errors

Pervasive Auto-Reconnect

Changing Your Configuration

Configuration Overview

Ensuring Configuration Changes Take Effect

Connecting to Different Machines

Configuration Through PCC

Configuration Through CLI Utility

Setting a Configuration

Command Syntax

Tuning Performance

SMP Support

Spotting Performance Bottlenecks

Before You Modify Configuration Parameters

Minimizing Initial Connection Time

Maximizing Runtime Throughput

Configuration Reference

Configuration Overview

Services Configuration Parameters

Server Configuration Parameters

Access

Communication Buffer Size

Communication Protocols

Compatibility

Data Integrity

Debugging

Directories

Information

Memory Usage

Performance Tuning

NetWare RTSS (NetWare only)

Win32 Client Configuration Parameters

Access

Cache Engine

Cache Engine Debugging

Communication Protocols

Performance Tuning

Security

Application Characteristics

Linux Client Configuration Parameters

Case of Configuration Values

Client Performance Affected by "Local" Setting

File Names with Embedded Spaces

Configuration Reference

Access

Communication Protocols

Application Characteristics

Win16 Client Configuration Parameters

Access

Application Characteristics

Communication Protocols

Security

Setting Up Referential Integrity

Concepts of Referential Integrity

Definitions

Understanding Keys and Rules

Setting up Primary Keys

Creating a Primary Key During Table Creation

Adding a Primary Key to an Existing Table

Setting up Foreign Keys

Creating a Foreign Key During Table Creation

Adding a Foreign Key to an Existing Table

Interactions Between Btrieve and Relational Constraints

Bound Database versus Integrity Enforced

See Also

Pervasive PSQL Security

Database Security

Master User

Users and Groups

Security Models and Concepts

Available Model for the Relational Interface

Available Models for the Transactional Interface

Owner Names

Accessing Data in More Than One Database

Planning Security for the Transactional Interface

Available Options

Choosing Your Policy

Preparing to Set Up Security

Process Overview

Transactional Interface Security Quick Start

Security Tasks

Data Encryption

Configuration Parameters for Wire Encryption

Encryption Notes

Setting Up Encryption

Effects of Encryption

Owner Name Encryption

Logging, Backup, and Restore

Transaction Logging and Durability

Using These Features

Feature Comparison

Which Feature Should I Use?

How Logging Works

See Also

Understanding Archival Logging and Continuous Operations

Difference Between Archival Logging and Transaction Logging

What if a File Restore is Needed

Using Archival Logging

General Procedures

Setting up Archival Logging

Roll Forward Command

Using Continuous Operations

Starting and Ending Continuous Operations

Backing Up a Database with BUTIL

Restoring Data Files when Using Continuous Operations

Server High-Availability Support

Server Clustering

Failure Behavior

Modes

Licensing

Microsoft Cluster Service

How to Proceed

Verify Cluster Service Functioning Correctly

Add a Cluster Group for Pervasive PSQL

Install Pervasive PSQL on the Cluster Nodes

Add Pervasive PSQL Services to Cluster Group

Configure the Engines with PCC

Establish Pervasive PSQL Databases on the Cluster Shared Disk

NetWare Cluster Services

How to Proceed

Upgrade Database Engine

Verify Cluster Services is Functioning Correctly

Modify Load Script

Configure Engines and Ensure Identical Configuration Information

Configuring the Database Engine

Enabling Transaction Durability

Establish Databases on the Cluster Shared Disk

Workgroup Engine in Depth

Networking

NetBIOS

MicroKernel Router Decision Algorithm

Technical Differences Server vs. Workgroup

Troubleshooting Workgroup Issues

Re-directing Locator Files

Accessing Data on NetWare using Workgroup Engine

The Best Choice

Using the Workgroup Engine

Monitoring Database Resources

Monitor Utility Overview

Interface Versions

Graphical User Interface Monitor

Starting the Monitor Utility

Setting Monitor Utility Options

Monitoring MicroKernel Resources

Setting Screen Refresh Options

Viewing Active Files

Viewing User Information

Viewing MicroKernel Resource Usage

Viewing MicroKernel Communications Statistics

Monitoring SQL Interface Resources

Monitoring Active SQL Connection Manager Sessions

Understanding Session Information

Refreshing the Active Session List

Deleting an Active Session

Command Line Interface Monitor

Configuration File

Monitoring Output

Command Syntax

Testing Btrieve Operations

Function Executor Concepts

Overview

What Function Executor Can Do

Features Unique to the Win32 Function Executor

Automatic Mode in 32-bit Function Executor

Where to Learn More

Function Executor GUI Reference

Application Window (32-Bit)

Main Window (32-Bit)

Main Window (16-Bit)

Login GUI Reference

Open File Dialog GUI Reference

Create a File Dialog GUI Reference

Create a File Dialog GUI Reference (Advanced)

Transactions GUI Reference

File Statistics GUI Reference

History GUI Reference

Function Executor Tasks

Starting Function Executor Tasks

Performing Operations Tasks

Opening a File Tasks

Creating a Btrieve File Tasks

Login Tasks

File Statistics Tasks

History Tasks

Manipulating Btrieve Data Files with Maintenance

Maintenance Utilities Overview

Btrieve Interactive Maintenance Utility

Extended File Support

Long File Names and Embedded Spaces Support

The Btrieve Maintenance Utility Interface

File Information Editor

File Information Editor Dialog Elements

Methods for Handling Duplicate Keys

Information Editor Tasks

Owner Names

Owner Names Tasks

Statistics Report

Statistics Report Tasks

Indexes

Index Tasks

Data

Importing and Exporting ASCII File Format

Data Tasks

Btrieve Command-Line Maintenance Utility (BUTIL)

Return Codes

Commands

Viewing Command Usage Syntax

Command Format

Command Files

Description Files

Extended File Support

Owner Names

Redirecting Error Messages

ASCII File Format

Rules for Specifying File Names on Different Platforms

Importing and Exporting Data

COPY

LOAD

RECOVER

SAVE

Creating and Modifying Data Files

CLONE

CLROWNER

CREATE

DROP

INDEX

SETOWNER

SINDEX

Compacting Btrieve Data Files

Viewing Data File Statistics

STAT

Displaying Btrieve Interface Module Version

VER

Unloading the Btrieve Interface and Requester (DOS only)

STOP

Performing Continuous Operations

Converting Data Files

Rebuild Utility Concepts

Platforms Supported

File Formats

Temporary Files

Optimizing the Rebuild Process

Log File

Rebuild Utility GUI Reference

File Options Screen

Rebuild Options Screen

Rebuild Progress Screen

Rebuild Utility Tasks

GUI Tasks

CLI Tasks

Command Line Parameters

Description Files

Rules for Description Files

Description File Examples

Description File Elements