Advanced Operations Guide - Table of Contents

Pervasive PSQL v10 (show all books in this release)

About This Manual

Who Should Read This Manual

Manual Organization

Conventions

Pervasive PSQL Databases

Pervasive PSQL Database Concepts

Named Database

Metadata

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

Concepts of Database Maintenance

Configurations

Database Security

Data Archival and Restoration

Troubleshooting

Helpful 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

Pervasive PSQL Event Logging

Syntax

Sample Entry

Error Code Clarification

Pervasive Auto-Reconnect

Configuration Reference

Configuration Overview

Ensuring Configuration Changes Take Effect

Connecting to Different Machines

Configuration Through PCC

Configuration Through CLI Utility

Setting a Configuration

Command Syntax

Configuration Settings Parameters

Services Configuration Parameters

Server Configuration Parameters

Access

Communication Protocols

Compatibility

Data Integrity

Debugging

Directories

Information

Memory Usage

Performance Tuning

Windows 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

Performance

Tuning Performance

SMP Support

Spotting Performance Bottlenecks

Before You Modify Configuration Parameters

Minimizing Initial Connection Time

Maximizing Runtime Throughput

Xtreme I/O Driver

Considerations

System Requirements

XIO Memory Cache

Frequently Asked Questions

Utilities

Exclusions File

Event Log Messages

Troubleshooting XIO

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

Failover Cluster 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

Set Up Pervasive PSQL 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

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

Function Executor Features

Automatic Mode in Function Executor

Where to Learn More

Function Executor GUI Reference

Application Window

Main Window

Login and Logout

Open File Dialog

Create a Btrieve File

Create a File Dialog GUI Reference (Advanced)

Transactions

File Statistics

History

Function Executor Tasks

Starting Function Executor Tasks

Performing Operations Tasks

Opening a File Tasks

Creating a Btrieve File 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

Record and Page Compression

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

Performing Archival Logging

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