Library > Products > Pervasive PSQL > Pervasive PSQL v10 > Advanced Operations Guide > Description Files > Description File Elements

Previous

Advanced Operations Guide (v10)

Advanced Operations Guide - Index

- A - B - C - D - E - F - G - H - I - J - K - L - M - N - O - P - Q - R - S - T - U - V - W - X

~PVSW~.LOC file

file open mode used by LOAD command

Accept Remote Request

configuration settings 1 2

files, monitoring

refreshing the list

Address space, common

All-segment null keys

Btrieve Maintenance utility and

description files and

Allocate Resources at Startup

configuration parameter 1 2 3 4

Allow Cache Engine Connections

configuration parameter

Allow Client-stored Credentials

configuration parameter

Alternate collating sequence

Btrieve Maintenance utility and 1 2 3

description files and 1 2

character translation

Any-segment null keys

Btrieve Maintenance utility and

description files and

Application Characteristics

configuration settings

configuration scenarios

Archival logging

definition of 1 2

file backups and

referential integrity and

transaction logging and

Archival Logging Selected Files

configuration parameter

ArrayBufferSize connection string

ArrayFetchOn connection string

ASCII data file format

Btrieve Maintenance utility and

Asynchronous I/O

Atomicity, transaction

not guaranteed with multiple engines

engine configuration 1 2

Windows client configuration

Server engine vs. Workgroup

Auto Reconnect Timeout

configuration parameter

in Function Executor

Available Linked Keys

Btrieve Maintenance utility and

Back to Minimal State if Inactive

configuration parameter 1 2

a database with BUTIL

data with continuous operations

with continuous operations

configuration utility

java.lang.UnsatisfiedLinkError error on Linux

troubleshooting starting on Linux

unable to connect to database engine error on Linux 1 2

Blank truncation

Btrieve Maintenance utility and

description files and

java.lang.UnsatisfiedLinkError error on Linux

monitoring utility

troubleshooting starting on Linux

Bound databases

constraints when used with SRDE access

interaction with relational constraints

login configuration

before you begin

reasons to choose classic model

reasons to choose database model

reasons to choose mixed model

security models for

Btrieve Command-Line Maintenance utility. See BUTIL

creating with Function Executor

Btrieve Interface Module, displaying version

Btrieve Maintenance utility

creating a file

extended files and

editing key and data

external index files, and BUTIL

backing up databases

command files rules

creating and modifying data files

displaying Btrieve interface module version

extended file support

importing and exporting data 1 2

recovering changes after system failure

redirecting error messages

starting and stopping continuous operation 1 2

unloading the Btrieve engine

viewing command syntax

memory usage 1 2

how to calculate ideal size

limited to 2 GB on Windows 1 2

memory use and XIO driver

physical memory and

Cache allocation size

effect on rebuilding files

Cache Allocation Size

configuration parameter

virtual memory and

configuration settings

Cache Engine Debugging

configuration settings

Cache read bytes

Cache write bytes

Cacheable I/O %

specifying files to exclude

Case sensitivity in keys

Btrieve Maintenance utility and

description files and

configuration parameters

gateway engine across multiple data directories

See also How to

Character translation

valid in regular identifier

Clearing owner names

Btrieve Maintenance utility and

memory usage 1 2

optimizing support for multiple clients

CLROWNER command

Cluster, see Clustering

adding groups for Pervasive PSQL

databases on shared disk

failure behavior

licensing Pervasive PSQL

Microsoft Cluster Service

add Pervasive.SQL relational service

add Pervasive.SQL transactional service

changing startup setting for relational service

configure PCC for

specify DSNs on cluster nodes

test relational connection from Pervasive PSQL client

test transactional connection from Pervasive PSQL client

verify cluster functioning correctly

COLLATE.CFG file

Collating sequence

valid characters

Command line parameters

for Rebuild utility

Command-line interface

bcfg utility for configuration

Command-line utilities, see BUTIL

in description files

Common address space

Communication Protocols

configuration settings 1 2

auto-reconnect feature

Communications Threads

configuration parameter

Compacting data files

and Btrieve Maintenance utility

configuration settings

Compressing data files

Compressing pages

Btrieve Maintenance utility and

Compressing records in data files

Btrieve Maintenance utility and

description files and

Compression ration

parameters for wire encryption

using bcfg utility 1 2

using command-line interface

Configuration file

Configuration parameters

before you modify

Allocate Resources at Startup

Back to Minimal State

Cache Allocation Size

Connection Timeout 1 2

Embedded Spaces 1 2

Enable Auto Reconnect

Encryption Level

Gateway Durability

Max MicroKernel Memory Usage

Minimal State of Delay

Number of Bytes from Data Buffer

Number of Bytes from Key Buffer

Number of Load Retries 1 2

Runtime Server Support 1 2

Select Operations

Supported Protocols 1 2

Trace File Location

Trace Operation

Use Cache Engine

Use Local MicroKernel Engine

Use Remote MicroKernel Engine

Verify Key Length

Wire Encryption

Wire Encryption Level

Embedded Spaces

Enable Autoreconnect

Use Local MicroKernel Engine

Use Remote MicroKernel Engine

Verify Key Length

Wire Encryption

Wire Encryption Leve

Allocate Resources at Startup

Allow Cache Engine Connections

Allow Client-stored Credentials

Archival Logging Selected Files

Auto Reconnect Timeout

Back to Minimal State if Inactive

Cache Allocation Size 1 2

Communications Threads

Create File Version

DBNames Configuration Location

Enable Auto Reconnect

Encryption Level

File Growth Factor

Index Balancing

Initiation Time Limit

Limit Segment Size

Listen IP Address

Log Buffer Size

Max MicroKernel Memory Usage

Minimal State of Delay

Number of Bytes from Data Buffer

Number of Bytes from Key Buffer

Number of I/O Threads

Operation Bundle Limit

Prompt for Client Credentials

Select Operations

Sort Buffer Size

Supported Protocols

TCP/IP Multihomed

Trace File Location

Trace Operation

Transaction Durability

Transaction Log Directory

Transaction Log Size

Transaction Logging

Wait Lock Timeout

Wire Encryption 1 2

Working Directory

Configuration settings

Application Characteristics

Cache Engine Debugging

Communication Protocols 1 2

Performance Tuning 1 2

Configuration Utility

for database engine

application scenarios

PCC for clustering, see Clustering

to local or remote machines

to workgroup, eliminating delay

terminating user

Connection delay

how to minimize

troubleshooting for Workgroup

Connection strings

Connection Timeout parameter

referential integrity

Continuous Operations

backing up data file

definition of 1 2

file locked because of

starting with BUTIL

stopping with ENDBU

transaction logging and

OEM to ANSI characters

Converting data files

with command-line Rebuild utility

with GUI Rebuild utility

with Rebuild utility

Copying records between files

effect on rebuilding files

versus fast disk

Create File Version 1 2

additional with BUTIL

primary key 1 2

redirecting Gateway Locator File

Creating a Btrieve file

in Function Executor

with Function Executor

Creating data files

Btrieve Maintenance utility and

Credentials, definition of

Current database

Damaged files, recovering

continuous operations

copying data from one MicroKernel file to another

encryption on disk

exporting ASCII data

files locked when in continuous operations

importing ASCII data

recovering changes to a data file

viewing as any data type

Data compression

Data encryption

compacting with Btrieve Maintenance utility

compacting with BUTIL

with GUI Rebuild utility

copying with BUTIL

creating with BUTIL

decreasing size of with Btrieve Maintenance utility

decreasing size of with BUTIL

generate statistics report

Data files, converting

with command-line Rebuild utility

configuration settings

not guaranteed with multiple engines

Data restoration

description files and

Data-only files

current, definition of

default, definition of

how to calculate ideal size

physical memory and

Database engine

and status code 116

java.lang.UnsatisfiedLinkError error on Linux 1 2

unable to connect to error on Linux 1 2

valid characters

DBNames Configuration Location 1 2

Dbnames.cfg file

connection string

configuration settings

Decreasing data file size

with Btrieve Maintenance utility

Default database

Delay,connection

how to minimize

troubleshooting for Workgroup

Delimited identifier

length for names

Delimited identifiers

Delta files 1 2

Descending sort order in keys 1 2

Description files

adding comments to

Btrieve Maintenance utility and

Dictionary file

configuration settings

Dirty buffers %

Discrete ordering

archival logging and

how to minimize

transaction logging and 1 2

effect on rebuilding files

versus fast CPU

for Pervasive Engine

Dropping indexes

Btrieve Maintenance utility and

creating with ODBC

Durability, gateway

eliminating delay upon connection to Workgroup

File Information

of description files

Embedded Spaces

configuration parameter 1 2

Embedded Spaces setting for Linux client

Enable array fetch

Enable Auto Reconnect

configuration parameter 1 2

Enable Autoreconnect setting for Linux client

configuration parameter

how to choose level

Encryption Level

configuration parameter

and continuous operation

Ending Continuous Operations

messages, redirecting with BUTIL

Error Code Clarification, about

Event log messages

naming convention 1 2

and BUTIL 1 2 3

ASCII file format

Btrieve Maintenance utility and

Btrieve Maintenance utility and

External index files

Btrieve Maintenance utility and

versus fast disk

versus fast CPU

automation upgrad of version

description 1 2

dividing into segments

naming convention 1 2

Btrieve Maintenance utility and

external index 1 2

formats supported with Rebuild

size comparisons based on page size and records per page

Btrieve Maintenance utility and

description files and

unformatted, see File, export 1 2

version upgrade

File Information Editor

Description Comments

File Specification 1 2

Load Information

File Specification

Available Linked Keys

Balanced Indexing

Blank Truncation

Page Compression

Record Compression

Variable Records

ACS Information

Repeating duplicates

Case Insensitive

Add comments to a description file

Compact a Btrieve file

Create a new file

Load information from an existing file

Specify a key's alternate collating sequence

comparisons based on page size and records per page

File Statistics

Function Executor

File, description

creating a Btrieve file with Function Executor

deleting temporary

opening with Function Executor

optimizing support for multiple

restoring with Continuous Operations

adding to existing table

creating in a table

Free space threshold

Btrieve Maintenance utility and

description files and

Function Executor

creating a Btrieve file

creating Btrieve files

file statistics

Function Executor utility

performing operations

valid characters

Gateway durability

and adding a new engine

configuration parameter

changing for multiple directories at once

see also Workgroup engine

Gateway Locator File

in Function Executor

in Function Executor

owner names and

restrictions for

valid characters

Groups, and users

High encryption

to add or remove network protocol support 1 2

to allow or prohibit embedded spaces in data file names

to calculate ideal size of database cache

amount of memory used for database cache 1 2

amount of memory used for sorting during creation of indexes

amount of time a client and server try to re-connect

amount of time the engine waits for a lock to release

directory where the engine stores temporary files

free file space available to Turbo Write Accelerator

how long the engine waits before returning to minimal state 1 2

location of DBNames configuration file

location of transaction log

NetBIOS port used by the server

number of operations required to start a system transaction

number of threads available for client requests

number of times the client attempts to connect

number of worker threads

size of the log buffer

time limit for starting a system transaction

total memory available to engine 1 2

to choose encryption level

to decrease time required to find a Gateway engine using gateway durability

to determine amount of physical memory needed

transaction atomicity 1 2

transaction durability

transaction logging

performance bottlenecks with Monitor

to increase performance on read operations by using index balancing

size of transaction log segments

to limit data file segment size

to make the client use a remote database engine

to make the client use the local engine

to make the engine release resources if inactive

to make the Linux client use a remote database engine

to make the Linux client use the local engine

client/server connection delay

a Server or Workgroup engine from accepting remote requests

the Pervasive splash screen from appearing

to set default file format version for file creation

the TCP/IP port that the ODBC Communications Manager uses

whether a client and server attempt to reconnect after a network interruption

whether the engine should use the system cache

client cache engine

length for identifier names

when name enclosed by quotes

unique within scope

Identifiers, regular

case-insensitivity of

configuration parameter

and BUTIL 1 2 3

ASCII file format

creating and dropping

creating with BUTIL

valid characters

viewing in the Btrieve Maintenance utility

Index balancing

Btrieve Maintenance utility and

configuration parameter 1 2

description files and

Index page size

effect on rebuilding files

primary keys and

configuration settings

Initiation Time Limit

configuration parameter

not guaranteed with multiple engines

Interactive Btrieve Maintenance utility. See Btrieve Maintenance utility

Java.lang.UnsatisfiedLinkError error on Linux 1 2

cannot contain a null column

adding to existing table

creating in a table

linked duplicate

adding to existing table

creating in a table

repeating duplicate

segment specifications 1 2

valid characters

Btrieve Maintenance utility and

description files and

repeating duplicate

with referential integrity

Large files. See Extended files

maximum for identifier names

Limit Segment Size

configuration parameter

users and groups

Linked duplicate keys 1 2

Linked-duplicate keys. See Linked duplicate keys

errors trying to start

java.lang.UnsatisfiedLinkError engine error

troubleshooting starting

unable to connect to database engine error

errors trying to start

java.lang.UnsatisfiedLinkError engine error

troubleshooting starting

unable to connect to database engine error

configuration parameters

setting properties

accelerated file open mode and

Local configuration setting

see Use Local MicroKernel Engine 1 2

files locked when in continuous operations

Locks, see Locking

Log Buffer Size

configuration parameter 1 2

transaction durability and

referential integrity and

performance and

Pervasive PSQL events

transaction logging and archival logging

configuration, Btrieve

using Function Executor

Login credentials, definition of

using Function Executor

Long file names

Maintenance utility

See Btrieve Maintenance Utility and BUTIL

Max MicroKernel memory usage

effect on rebuilding files

MaxCache, definition of

runtime throughput

length for identifier names

Medium encryption

common address space architecture

database cache and

determining amount needed

effect on rebuilding files

limit to 2 GB on Windows 1 2

use of extended with XIO

use of standard with XIO

configuration settings

event log messages for XIO

Methods, access

MicroKernel Database Engine

common address space with SRDE

monitoring resources

performance and

MicroKernel Database Engine message log. See Pervasive PSQL event log.

MicroKernel Router

decision algorithm

Cluster Service See Clustering

Minimal State of Delay

configuration parameter 1 2

Mixed access constraints

Mixed security policy

Workgroup engines and

Modifiable keys 1 2

configuration parameters

configuration file

configuration parameters and

finding performance bottlenecks with

how to identify performance problems

setting screen refresh options

terminating a user connection

Monitor utility

MicroKernel communications

MicroKernel resources 1 2

SQL interface resources

user information

using bmon utility

optimizing support for

optimizing support for

Named databases

where metadata stored

Names of delimited identifiers

Names of objects

restrictions for

Names of regular identifiers

case-insensitivity of

valid characters

with Workgroup engine

configuration parameter

auto-reconnect feature

connection timeout

with Workgroup engine

not allowed in a key column

Null value discrete ordering

Number of Bytes from Data Buffer

configuration parameter 1 2

Number of Bytes from Key Buffer

configuration parameter 1 2

Number of indexes

effect on rebuilding files

Number of Input/Output Threads

configuration parameter 1 2

Number of Load Retries

configuration parameter

restrictions for

connection strings

TCP/IP port number

performance and

character translation

connection string

Open cached files

in Function Executor

with Function Executor

OPENMODE connection string

Operation Bundle Limit

Operations, performing with Function Executor

database configuration

read-heavy databases

Optimizing the rebuild process

setting for a file

BUTIL and 1 2 3

clearing with BUTIL

GRANT syntax and

how to set or clear an owner name

relational security and

REVOKE syntax and

setting and clearing

setting with BUTIL

Btrieve Maintenance utility and

description files and

Btrieve Maintenance utility and

description files and

Btrieve Maintenance utility and

description files and

Page compression

in File Information Editor

effect on file size

required link to

required link to PAM library

Parameters, configuration

before you modify

PARC See Auto-reconnect

valid characters

client cache 1 2

virtual memory and

Performance Tuning

configuration settings 1 2

Pervasive Control Center

configure for Microsoft Cluster Service

OEM characters and

Pervasive Engine

field descriptions

Pervasive_admin

Physical memory

Planning security scheme

adding to existing table

creating in a table

valid characters

Processors, multiple

see Multiple processors

Prompt for Client Credentials

configuration parameter

setting for Linux client

setting with bcfg utility

setting with command-line utility

used with security

PWD connection string

Rebuild utility

CLI example for Linux

CLI example for Windows

command line parameters

deleting temporary files

optimizing the rebuild process

running on Linux

running on Windows

Rebuilding files

amount of memory

cache allocation size

CPU speed and disk speed

GUI Rebuild utility

index page size

max MicroKernel memory usage

number of indexes

optimizing the rebuild process

sort buffer size

Btrieve Maintenance utility and

description files and

Btrieve Maintenance utility and

description files and

Record compression

in File Information Editor

copying between data files

effects of number of on file size

Btrieve Maintenance utility and

Btrieve Maintenance utility and

variable-length

Btrieve Maintenance utility and

description files and

RECOVER command

Redirecting Locator File, See Gateway Locator File

Referential integrity

archival logging and

rule, definition of

Referential Integrity

active session list

Registry setting

for embedded spaces 1 2

Regular identifier

length for names

Regular identifiers

case-insensitive of

valid characters

Relational architecture

Relational interface

Relational security

owner names and

Repeating duplicate keys

Btrieve Maintenance utility and

Repeating duplicates

Repeating-duplicatable keys

description files and

Repeating-duplicate keys. See Repeating duplicate keys

Requester configuration parameter, See Use Remote MicroKernel Engine 1 2

Resources, monitoring

Restore and backup

files using Continuous Operations

for identifiers