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

Advanced Operations Guide - Index

---

Symbols

~PVSW~.LOC file 1

Numerics

116 1, 2

12 1

85 1

A

Accelerated

DSN open mode 1

file open mode used by LOAD command 1

Accept Remote Request 1

Active

files, monitoring 1

Active Clients configuration parameter (obsolete) 1

Adding

a new engine

turn off Gateway Durability 1

Address space, common 1

Allocate Resources at Startup configuration parameter 1, 2

Allow Cache Engine Connections configuration parameter 1

Allow Client-stored Credentials configuration parameter 1

All-segment null keys

Btrieve Maintenance utility and 1

description files and 1

Alternate collating sequence

Btrieve Maintenance utility and 1, 2, 3

description files and 1, 2

ANSI

character translation 1

Any-segment null keys

Btrieve Maintenance utility and 1

description files and 1

Applications

configuration scenarios 1

Architecture

Smart Components 1, 2

Archival logging

definition of 1, 2

disk I/O and 1

file backups and 1

referential integrity and 1

transaction logging and 1

Archival Logging Selected Files configuration parameter 1

Array fetch 1

ArrayBufferSize connection string 1

ArrayFetchOn connection string 1

ASCII data file format

Btrieve Maintenance utility and 1

BUTIL and 1

Asynchronous I/O 1

Atomicity, transaction

not guaranteed with multiple engines 1

Attributes

client configuration

win16 1

win32 1

engine configuration 1

file

showing in File Information Editor 1

Authentication 1

Server engine vs. Workgroup 1

Auto Reconnect Timeout configuration parameter 1

Auto-reconnect

defined 1

Available Linked Keys

Btrieve Maintenance utility and 1

B

Back to Minimal State if Inactive configuration parameter 1, 2

Backing up

a database, and BUTIL 1

data files 1

Backup

and restore 1

Binding

Smart Components and 1

Blank truncation

Btrieve Maintenance utility and 1

description files and 1

Bound databases

Btrieve and 1

creating 1

Brebuild.nlm

may hog CPU 1

Brouter Communication Buffer Size configuration parameter 1

Bti.cfg file 1

Btrieve

constraints when used with SRDE access 1

interaction with relational constraints 1

login configuration 1

security

changing policy 1

classic 1

database 1

granting same rights to all users 1

mixed 1

quick start 1

turning on 1

Btrieve Command-Line Maintenance utility. See BUTIL1

Btrieve Interface Module, displaying version 1

Btrieve Maintenance utility

about 1

creating a file 1

extended files and 1

menu options 1

online help 1

starting 1

Buffers

editing key and data 1

Building

external index files, and BUTIL 1

BUTIL 1

about 1

ASCII files 1

backing up databases 1

command files 1

rules 1

commands

CLONE 1

CLROWNER 1

COPY 1

CREATE 1

DROP 1

ENDBU 1, 2

INDEX 1

LOAD 1

overview 1

RECOVER 1

ROLLFWD 1, 2

SAVE 1

SETOWNER 1

SINDEX 1

STARTBU 1, 2

STAT 1

STOP 1

VER 1

creating and modifying data files 1

displaying Btrieve interface module version 1

extended file support 1

importing and exporting data 1, 2

overview 1

owner names 1

recovering changes after system failure 1

redirecting error messages 1

return codes 1

starting and stopping continuous operation 1, 2

syntax 1

unloading the Btrieve engine 1

viewing command syntax 1

Byte offset versus byte position 1

C

Cache

client

memory usage 1

database

data pages and 1

how to calculate ideal size 1

limited to 2 GB on Windows 1, 2

physical memory and 1

Cache allocation size

effect on rebuilding files 1

Cache Allocation Size configuration parameter

virtual memory and 1

Cascade rule 1

Case sensitivity in keys

Btrieve Maintenance utility and 1

description files and 1

Changing

gateway engine across multiple data directories 1

named databases 1, 2

See also How to1

Character

translation

OEM to ANSI 1

Characters

valid in object names 1

Check database function 1

Clearing owner names

and BUTIL 1

Btrieve Maintenance utility and 1

Client

cache

memory usage 1

DSN

options 1

optimizing support for multiple clients 1

CLONE command 1

CLROWNER command 1

Cluster, see Clustering1

Clustering

databases on shared disk 1, 2

failback 1, 2

licensing Pervasive.SQL 1

Microsoft Cluster Service 1

add Pervasive.SQL transactional service 1

configure PCC for 1

test relational connection from Pervasive.SQL client 1

test transactional connection from Pervasive.SQL client 1

verify cluster functioning correctly 1

modes 1

NetWare Cluster Services 1

bti.cfg file 1

configure PCC for 1

dbnames.cfg file 1

load script 1

odbc.ini 1

test relational connection from Pervasive.SQL client 1

test transactional connection from Pervasive.SQL client 1

verify cluster functioning correctly 1

server 1

COLLATE.CFG file 1

Collating sequence 1

Column

definitions

deducing from data file 1

name

limits 1

maximum length 1

valid characters 1

Command files

BUTIL and 1

rules 1

Command line parameters for Rebuild utility 1

Command-line utilities, see BUTIL and SQLUTIL1

Comments

in description files 1

Common address space 1

Communication Buffer Size configuration parameter 1

Communications

auto-reconnect feature 1

monitoring

MicroKernel 1

Communications Threads configuration parameter 1, 2

Monitor and 1

Compacting data files

and Btrieve Maintenance utility 1

and BUTIL 1

Component IDs 1

Components

load order of engine components 1

Components, Smart See Smart Components1

Compress IDS Data configuration parameter 1

Compressing data files

Btrieve Maintenance utility and 1

description files and 1

Configuration

delay in, eliminating 1

local and remote connections 1

named databases 1

optimizing 1

overview 1

settings ordered by default view 1

Configuration file 1

Configuration parameters

all users can access client settings 1

client

Compress IDS Data 1

Connection Timeout 1

Embedded Spaces 1, 2

Enable Auto Reconnect 1, 2

Encryption Level 1

Gateway Durability 1

IDS Password 1

IDS Username 1

Number of Bytes from Data Buffer 1

Number of Bytes from Key Buffer 1

Number of Load Retries 1

Runtime Server Support 1

Select Operations 1

Splash Screen 1

Supported Protocols 1, 2

Target Engine 1

Trace File Location 1

Trace Operation 1

Use Cache Engine 1

Use IDS 1

Use Local MicroKernel Engine 1, 2

Use Remote MicroKernel Engine 1, 2

Monitor and 1

server

Access 1

Active Clients 1

Allocate Resources at Startup 1

Allow Cache Engine Connections 1

Allow Client-stored Credentials 1

Archival Logging Selected Files 1

Authentication 1

Auto Reconnect Timeout 1

Back to Minimal State if Inactive 1

Brouter Communication Buffer Size 1

Cache Allocation Size 1

Communication Buffer Size 1

Communications Threads 1

Create File Version 1

DBNames Configuration Location 1

Enable Auto Reconnect 1

Encryption Level 1

File Growth Factor 1

Index Balancing 1

Initiation Time Limit 1

Largest Compressed Record Size 1

Listen IP Address 1

Load Brouter 1

Log Buffer Size 1

Max MicroKernel Memory Usage 1

Minimal State of Delay 1

MKDE Communication Buffer Size 1

NetBIOS Port 1

Number of Bytes from Data Buffer 1

Number of Bytes from Key Buffer 1

Number of I/O Threads 1

ODBC Connection Manager Supported Protocol 1

Operation Bundle Limit 1

Prompt for Client Credentials 1

Read Buffer Size 1

Receive Packet Size 1

Runtime Server Support 1

Select Operations 1

Sort Buffer Size 1

Supported Protocols 1

System Cache 1

System Data 1

TCP/IP Multihomed 1

TCP/IP Port 1

Trace File Location 1

Trace Operation 1

Transaction Durability 1

Transaction Log Directory 1

Transaction Log Size 1

Transaction Logging 1

Use SAP 1

Wait Lock Timeout 1

Wire Encryption 1

Working Directory 1

Configuration Utility 1

Configuring

application scenarios 1

PCC for clustering, see Clustering1

Connecting

to workgroup, eliminating delay 1

Connection

delay

how to minimize 1

troubleshooting for Workgroup 1

terminating user 1

timeout 1

Connection strings 1

OPENMODE 1

TRANSLATIONDLL 1

Connection Timeout parameter 1

Constraints

mixed access 1

referential integrity 1

Continuous Operations

definition of 1, 2

ending 1

SQLUTIL and 1

starting 1

starting with BUTIL 1

stopping with ENDBU 1

transaction logging and 1

Converting

data files 1

with command-line Rebuild utility 1

with GUI Rebuild utility 1

OEM to ANSI characters 1

COPY command

BUTIL and 1

Copying records between files 1

CPU speed

effect on rebuilding files 1

CREATE command 1

Create File Version 1

Creating

bound databases 1

data files

with BUTIL 1

DDFs for Btrieve files 1

files

Btrieve Maintenance utility and 1

BUTIL and 1

indexes

about 1

additional with BUTIL 1

primary key 1, 2

redirecting Gateway Locator File 1

table definitions for Btrieve files 1

users and groups 1

Credentials, definition of 1

Current database

definition of 1

D

Damaged files, recovering

BUTIL and 1

Data

compression

Btrieve Maintenance utility and 1

description files and 1

copying data from one MicroKernel file to another 1

encryption on disk 1

exporting ASCII data 1

importing ASCII data 1

recovering changes to a data file 1

Data buffer

editing 1

Data files

adding relational access to Btrieve 1

byte offset versus byte position 1

compacting with Btrieve Maintenance utility 1

compacting with BUTIL 1

converting

with command-line Rebuild utility 1

with GUI Rebuild utility 1

copying with BUTIL 1

creating 1

creating with BUTIL 1

decreasing size of with Btrieve Maintenance utility 1

decreasing size of with BUTIL 1

generate statistics report 1

Data integrity

not guaranteed with multiple engines 1

Data pages

cache and 1

Data types

description files and 1

NULL 1

Database

current, definition of 1

default, definition of 1

definition, how to verify 1

maintaining named 1

name

adding 1

deleting 1

limits 1

maximum length 1

modifying 1

valid characters 1

Database cache

data pages and 1

how to calculate ideal size 1

physical memory and 1

Database name

changing 1

deleting 1

where stored 1

Data-only files 1

DBNames Configuration Location 1, 2

Dbnames.cfg file 1, 2

DBQ

connection string 1

Decreasing data file size

with Btrieve Maintenance utility 1

with BUTIL 1

Default database

definition of 1

Delay

connection

how to minimize 1

troubleshooting for Workgroup 1

in Configuration, eliminating 1

Delete

rule 1

Deleting

named databases 1, 2

Delimited identifier

definition of 1

Delta files 1, 2

Descending sort order in keys 1, 2

Description files

adding comments to 1

Btrieve Maintenance utility and 1

BUTIL and 1

format 1

Diagnosing

module load errors 1

Discrete ordering

null value 1

Disk I/O

archival logging and 1

how to minimize 1

transaction logging and 1

Disk speed

effect on rebuilding files 1

DLLs

load order of engine components 1

Double quote

representing within a delimited name 1

required for some identifiers 1

DROP command 1

Dropping

indexes

Btrieve Maintenance utility and 1

BUTIL and 1

DSN

client options 1

open modes 1

Duplicate keys 1, 2

Durability

gateway

eliminating delay upon connection to Workgroup 1

Dynamic binding 1

E

Editor

File Information 1

Elements

of description files 1

Embedded Spaces configuration parameter 1, 2, 3

Enable array fetch 1

Enable Auto Reconnect

configuration parameter 1, 2, 3

Enabling

security 1

Encryption

how to choose level 1

of data files 1

Encryption Level configuration parameter 1

ENDBU command 1

and continuous operation 1, 2

BUTIL and 1

SQLUTIL and 1

Ending Continuous Operations 1

Engine

DSN

open modes 1

options, configuring

overview 1

Pervasive.SQL 1

Error

messages, redirecting with BUTIL 1

Error Code Clarification, about 1

Errors, load 1

Event logging 1

Exclusive

DSN open mode 1

Export files

naming convention 1, 2

size limit 1, 2

Exporting data

and BUTIL 1, 2, 3

ASCII file format 1

Btrieve Maintenance utility and 1

Extended files

Btrieve Maintenance utility and 1

BUTIL and 1

External

index files

Btrieve Maintenance utility and 1

BUTIL and 1

F

Fault tolerance 1

File

ASCII 1

attributes

showing in File Information Editor 1

creating 1

delta 1, 2

description 1, 2

export

naming convention 1, 2

size limit 1, 2

extended

Btrieve Maintenance utility and 1

BUTIL and 1

external index 1, 2

maximum size 1

names, long 1

rebuilding

may hog CPU on NetWare 1

specifications

Btrieve Maintenance utility and 1

description files and 1

File Information Editor 1

Data File Info

Owner Name 1

Total Records 1

Version 1

Elements

Create File 1

Description Comments 1

File Specification 1

Help 1

Load Information 1

Set to Default 1

Show 6.x Attributes 1

File Specification 1

# Pages 1

% Free Space 1

Available Linked Keys 1

Balanced Indexing 1

Blank Truncation 1

Data Compression 1

Include VATs 1

Key-Only 1

Preallocation 1

Record Length 1

Variable Records 1

Key

ACS Information 1

All Segments 1

Any Segment 1

Duplicates 1

Modifiable 1

Null Key 1

Repeating Duplicates 1

Sparse Key 1

Unique Values 1

Key Segment

Case Insensitive 1

Data Types 1

Descending 1

Length 1

Null Value 1

Position 1

Use ACS 1

Tasks

Add comments to a description file 1

Compact a Btrieve file 1

Create a new file 1

Display 6.x-specific controls 1

Load information from an existing file 1

Specify a key's alternate collating sequence 1

Files

backing up 1

deleting temporary 1

optimizing support for multiple 1

securing data files 1

Foreign key

adding to existing table 1

creating in a table 1

definition of 1

Free space threshold

Btrieve Maintenance utility and 1

description files and 1

Function Executor utility

overview 1

performing operations 1

starting 1

starting the 16-bit utility 1

G

Gateway durability 1

configuration parameter 1

turn off when adding a new engine 1

Gateway engine

changing for multiple directories at once 1

see also Workgroup engine1

Gateway Locator File 1

redirecting 1

creating a 1

GRANT

Master user must grant self access if owner name set on file 1

owner names and 1

Group

cannot be a member of another group 1

Groups and users

restrictions 1

H

Handles

monitoring 1

High encryption 1

How

to add or remove network protocol support 1, 2, 3

to allow or prohibit embedded spaces in data file names 1, 2

to calculate ideal size of database cache 1

to change

amount of memory used for database cache 1

amount of memory used for sorting during creation of indexes 1

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

amount of time the engine waits for a lock to release 1

directory where the engine stores temporary files 1

free file space available to Turbo Write Accelerator 1

how long the engine waits before returning to minimal state 1

location of DBNames configuration file 1

location of transaction log 1

NetBIOS port used by the server 1

number of operations required to start a system transaction 1

number of threads available for client requests 1

number of times the client attempts to connect 1

number of worker threads 1

size of the log buffer 1

time limit for starting a system transaction 1

total memory available to engine 1

to choose encryption level 1

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

to determine amount of physical memory needed 1

to ensure

transaction atomicity 1, 2

transaction durability 1

transaction logging 1

to find

performance bottlenecks with Monitor 1

to increase performance on read operations by using index balancing 1

to limit

size of transaction log segments 1

to make the client use a remote database engine 1, 2

to make the client use the local engine 1, 2

to make the engine release resources if inactive 1

to minimize

client/server connection delay 1

disk I/O 1

to prevent

a Server or Workgroup engine from accepting remote requests 1

the Pervasive splash screen from appearing 1

to secure your data files at the OS level 1

to set default file format version for file creation 1

to specify

the TCP/IP port that the ODBC Communications Manager uses 1

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

whether the engine should use the system cache 1

to turn on

Archival Logging 1

to turn on security for Btrieve database 1

to use

client cache engine 1

I

I/O

asynchronous 1

Identifier

definition of 1

delimited 1

limits and restrictions 1

regular 1

uniqueness requirements 1

Identifying

Smart Components 1

IDS Password configuration parameter 1

IDS Username configuration parameter 1

Importing data

and BUTIL 1, 2, 3

ASCII file format 1

Index

balancing

Btrieve Maintenance utility and 1

configuration parameter 1, 2

description files and 1

creating 1

creating and dropping 1

creating with BUTIL 1

dropping 1

viewing in the Btrieve Maintenance utility 1

INDEX command

BUTIL and 1

Index page size

effect on rebuilding files 1

Indexes

primary keys and 1

Initiation Time Limit configuration parameter 1

Integrity

not guaranteed with multiple engines 1

Interactive Btrieve Maintenance utility. See Btrieve Maintenance utility1

K

Key

attributes 1, 2

buffer

editing 1

cannot contain a null column 1

foreign

adding to existing table 1

creating in a table 1

definition of 1

numbers 1

primary

adding to existing table 1

creating in a table 1

definition of 1

segment specifications 1, 2

Key-only files

Btrieve Maintenance utility and 1

description files and 1

L

Large files. See Extended files1

Largest Compressed Record Size configuration parameter 1

Length

max length of names 1

maximum of user password 1

Licensing

for clustering 1

Limitations

users and groups 1

Linked-duplicatable keys. See Duplicate keys 1

Load brouter configuration parameter 1

LOAD command

accelerated file open mode and 1

BUTIL and 1

Load errors, diagnosing 1

Load order of engine DLLs 1

Loading

Smart Components 1

Local configuration setting

see Use Local MicroKernel Engine1, 2

Local connection, configuring 1

Locking

row level 1

Locks, see Locking1

Log Buffer Size

configuration parameter 1, 2

transaction durability and 1

Log file

for Rebuild utility 1

Logging

archival

referential integrity and 1

performance and 1

Pervasive.SQL events 1

transaction 1

transaction logging and archival logging 1

Login

configuration, Btrieve 1

Login credentials, definition of 1

Long file names 1

Low encryption 1

M

Maintain Named Databases 1

Maintenance utility. See Btrieve Maintenance utility, BUTIL, and SQLUTIL1

Master user 1

must grant self access if owner name set on file 1

Max MicroKernel memory usage

effect on rebuilding files 1

MaxCache, definition of 1

Maximum

file size 1

length of column or table names 1

length of database user password 1

Medium encryption 1

Memory

common address space architecture 1

database cache and 1

determining amount needed 1

effect on rebuilding files 1

limit to 2 GB on Windows 1, 2

MicroKernel Database Engine

common address space with SRDE 1

monitoring 1

monitoring resources 1

overview of 1

tracing

performance and 1

MicroKernel Database Engine message log. See Pervasive.SQL event log.1

Microsoft

Cluster Service See Clustering1

Minimal State of Delay configuration parameter 1

Minimizing

disk I/O 1

Mixed access constraints 1

Mixed security policy

Workgroup engines and 1

MKDE Communication Buffer Size configuration parameter 1

Modes

DSN open 1

Modifiable keys 1, 2

Modifying

See also Changing, How to1

data files

with BUTIL 1

Module load errors, diagnosing 1

Monitor

Communications Threads and 1

configuration parameters and 1

finding performance bottlenecks with 1

how to identify performance problems 1

Number of Sessions and 1

overview 1

terminating a user connection 1

Monitor utility

See Monitor1

Monitoring 1

active files 1

handles 1

MicroKernel communications 1

MicroKernel resources 1, 2

SQL interface resources 1

user information 1

Multiple

clients

optimizing support for 1

files

optimizing support for 1

processors

use of 1

N

Named databases

adding 1

deleting 1

modifying 1

where metadata stored 1

Names

case-insensitivity of 1

limits and restrictions for object names 1

maximum length 1

uniqueness requirements 1

valid characters 1

Naming

extended file 1

of Smart Components, convention 1

NetBIOS

not supported by Server engine 1

NetBIOS Port configuration parameter 1

NetWare

brebuild.nlm may hog CPU 1

Cluster Services See Clustering1

Workgroup engine and 1

Network

auto-reconnect feature 1

connection timeout 1

ports used 1, 2

Normal

DSN open mode 1

NULL

data type 1

Null

conversion 1

indicator byte 1

keys 1

not allowed in a key column 1

Null key 1

Null value discrete ordering 1

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 1

Number of Input/Output Threads configuration parameter 1, 2

Number of Load Retries configuration parameter 1

Number of Sessions configuration parameter (obsolete) 1

Monitor and 1

O

ODBC

connection strings 1

security 1

TCP/IP port number 1

tracing

performance and 1

ODBC Connection Mgr Supported Protocol 1

Odbc.ini 1

OEM to ANSI

character translation 1

connection string 1

Open modes 1

OPENMODE connection string 1

Operation Bundle Limit 1

Operations, performing with Function Executor 1

Optimizing

database configuration 1

read-heavy databases 1

Optimizing the rebuild process 1

Options

client DSN 1

configuration, ordered by default view 1

Owner names

BUTIL and 1, 2, 3

clearing with BUTIL 1

GRANT syntax and 1

how to set or clear an owner name 1

Master user must grant self access 1

relational security and 1

REVOKE syntax and 1

setting and clearing 1

setting with BUTIL 1

summary 1

P

Page

preallocation

Btrieve Maintenance utility and 1

description files and 1

sizes

Btrieve Maintenance utility and 1

description files and 1

PAR file 1

PARC See Auto-reconnect1

Password

for Master user 1

maximum length of database user 1

Performance

client cache 1

logging and 1

tuning 1

virtual memory and 1

Pervasive 1

Pervasive Control Center

configure for Microsoft Cluster Service 1

configure for NetWare Cluster Services 1

OEM characters and 1

Pervasive.SQL

engine 1

event log

field descriptions 1

file location 1

overview 1

Planning security scheme 1

Platform codes

in Smart Component naming 1

Policy

security

changing 1

Port number

NetBIOS 1

TCP/IP 1, 2

TCP/IP ODBC 1

Primary key

adding to existing table 1

creating in a table 1

definition of 1

Processors, multiple

see Multiple processors1

Prompt for Client Credentials configuration parameter 1

PVSW.LOG

file 1

PWD connection string 1

R

Read Buffer Size configuration parameter 1

Read-only

DSN open mode 1

Rebuild utility 1

CLI example for Linux 1

CLI example for NetWare 1

CLI example for Windows 1

CLI versions 1

command line parameters 1

deleting temporary files 1

GUI version 1

log file 1

may hog CPU on NetWare 1

optimizing the rebuild process 1

running CLI on Windows 1

running on Linux 1

running on NetWare 1

settings for GUI utility 1

Rebuilding files

amount of memory 1

cache allocation size 1

CPU speed and disk speed 1

GUI Rebuild utility 1

index page size 1

max MicroKernel memory usage 1

may hog CPU on NetWare 1

number of indexes 1

optimizing the rebuild process 1

sort buffer size 1

Receive Packet Size configuration parameter 1

Record

length

Btrieve Maintenance utility and 1

description files and 1

Records

building a table definition 1

byte offset versus byte position 1

copying between data files 1

exporting

Btrieve Maintenance utility and 1

BUTIL and 1

importing

Btrieve Maintenance utility and 1

BUTIL and 1

variable-length

Btrieve Maintenance utility and 1

description files and 1

structure 1

RECOVER command 1

Recovering

changes

and BUTIL 1

damaged files

Btrieve 1

data 1

Redirecting Locator File, See Gateway Locator File1

Referential integrity

archival logging and 1

Btrieve and 1

cascade 1

definition of 1

delete rule 1

foreign key 1

primary key 1

restrict 1

rule, definition of 1

update rule 1

Registry setting

for embedded spaces 1

Regular identifier

definition of 1

Relational architecture

client 1

server 1, 2

Relational security 1

Btrieve and 1

owner names and 1

Remote

connection, configuring 1

Repeating-duplicatable keys

Btrieve Maintenance utility and 1

description files and 1

Requester configuration parameter, See Use Remote MicroKernel Engine1, 2

Resources, monitoring

MicroKernel 1

Restore and backup 1

Restoring

data files 1

Restrict rule 1

Restrictions

users and groups 1

REVOKE

owner names and 1

Rights

granting same to all Btrieve users 1

user permissions overriden by group permissions 1

ROLLFWD command 1

BUTIL and 1

file backups and 1

Row level locking 1

Rules

cascade 1

delete 1

restrict 1

update 1

Runtime Server Support

configuration parameter 1, 2

S

SAR file 1

SAVE command

BUTIL and 1

Scope

of unique object names 1

Search algorithm for Smart Components 1

Security

Btrieve

before you begin 1

changing policy 1

Classic 1

classic 1, 2

database 1, 2

granting same rights to all users 1

mixed 1

quick start 1

turning on 1

enabling and disabling 1

encryption of data files 1

password of Master user 1

policy

planning 1

relational 1

summary 1

transactional vs relational 1

turning on 1

Workgroup engine 1

Segments in keys 1, 2

Select Operations configuration parameter 1, 2

Server

clustering 1

differences from Workgroup 1

Server engine

asynchronous I/O and 1

optimizing performance 1

ServerDSN

connection string 1

ServerName connection string 1

Services

running Workgroup engine as 1

Services DLL in Smart Components 1

SET SECURITY

cannot use in PCC 1

SETOWNER command 1

Setting

Monitor Utility Options 1

owner names

about 1

Btrieve Maintenance utility and 1

BUTIL and 1

Settings

ordered by default view 1

Setup utility. See Configuration1

SFT III 1

SINDEX command 1

Size

limit of export files 1, 2

maximum for data files 1

Smart Components

dynamic binding 1

identifying 1

naming 1

component type codes 1

platform codes 1

search algorithm 1

Services DLL 1

Sort buffer size

effect on rebuilding files 1

Sort Buffer Size configuration parameter 1

Sort order in keys

Btrieve Maintenance utility and 1

description files and 1

Sparse key 1

Splash Screen 1

SPX

connection timeout 1

SQL

security 1

SQL Data Manager

check database function 1

OEM characters and 1

SQL Interface Resources

Monitoring 1

SQL Relational Database Engine

common address space with MicroKernel 1

constraints when used with Btrieve access 1

overview of 1

SQLUTIL

ENDBU command 1

overview 1

starting and stopping continuous operation 1

stopping

continuous operation 1

STARTBU command 1

and BUTIL 1

and continuous operation 1, 2

Starting

CLI Rebuild utility on Windows 1

continuous operation 1

and BUTIL 1

Rebuild utility on Linux 1

Rebuild utility on NetWare 1

STAT command 1

Statistics report 1

creating 1

Status Codes

116 1, 2

12 1

85 1

STOP command 1

Stopping

continuous operation 1, 2

Stored procedures

Btrieve and 1

Strings

connection 1

Support

for long file names 1

Supported Protocols

configuration parameter 1, 2, 3, 4

SYS:ODBC\odbc.ini file 1

SYS:SYSTEM\bti.cfg file 1

SYS:SYSTEM\dbnames.cfg file 1

System

data

including in description files 1

failures, and recovering changes 1

fault tolerance 1

System cache

asychronous I/O and 1

System Cache configuration parameter 1

T

Table

adding foreign key to 1

adding primary key to 1

creating with a foreign key 1

creating with a primary key 1

name

limits 1

maximum length 1

valid characters 1

Target Engine configuration parameter 1

TCP/IP

port number

ODBC 1

ports used 1, 2

TCP/IP Multihomed

configuration parameter 1

TCP/IP Port configuration parameter 1

TCP/IP Timeout for Communication Requester 1

TCPPort connection string 1

Technology overview

relational architecture

client 1

server 1, 2

Temporary files

Rebuild utility

deleting 1

Terminating a user connection 1

thread safety 1

Threads 1

multi-threaded engine 1

Trace File Location configuration parameter 1, 2

Trace Operation configuration parameter 1, 2, 3

Tracing

performance and 1

Transaction

logging and BUTIL 1

Transaction atomicity

not guaranteed with multiple engines 1

Transaction Durability 1

disk I/O and 1

ensuring 1, 2, 3

Log Buffer Size and 1

transaction log size and 1

transaction logging vs. 1

Transaction Log Directory configuration parameter 1, 2

Transaction Log Size

configuration parameter 1, 2

transaction durability and 1

Transaction Logging 1

archival logging and 1

continuous operations and 1

disk I/O and 1

Transactions

logging 1

TRANSLATIONDLL connection string 1, 2

TransportHint connection string 1

Triggers

Btrieve and 1

Troubleshooting

load errors 1

Tuning

performance 1

Type codes in Smart Component naming 1

U

UID connection string 1

UNIQUE

primary keys and 1

Unique Component Naming 1

Unloading

Btrieve engine 1

Update

rule 1

Use IDS configuration parameter 1

Use Local MicroKernel Engine configuration parameter 1, 2, 3

Use Remote MicroKernel Engine configuration parameter 1, 2, 3

Use SAP configuration parameter 1

User

cannot add existing to group 1

cannot be in more than one group 1

Master 1

terminating a connection 1

User credentials, definition of 1

User information, monitoring 1

Users

groups and

restrictions 1

V

Valid characters in names 1

Variable-length records 1

Variable-tail Allocation Tables

control setting 1

in description files 1

VER command

and BUTIL 1

Verifying

a database definition 1

Virtual Memory

Cache Allocation Size and 1

performance and 1

W

W32BTXLT 1

Wait Lock Timeout 1

Windows

memory limit 1, 2

process memory limit 1, 2

system cache 1

Wire Encryption Level configuration parameter 1

Workgroup engine

and Mixed security policy 1

and transaction durability 1

data on NetWare server 1

differences from server 1

eliminating connection delay 1

floating Gateway 1

new Gateway behavior 1

running as a service 1

syncronizing multiple data directories under one Gateway 1

troubleshooting 1

Working Directory configuration parameter 1

Pervasive Software, Inc. http://www.pervasive.com Voice: (512) 231-6000 Fax: (512) 231-6597 Pervasive Sales Support Documentation Feedback Contact Technical Support Pervasive DevTalk Forums Pervasive DeveloperZone