Advanced Operations Guide - Index
Numerics -
-
A -
B -
C -
D -
E -
F -
G -
H -
I -
J -
K -
L -
M -
N -
O -
P -
Q -
R -
S -
T -
U -
V -
W
Numerics
116 1 2
12
85
~PVSW~.LOC file
A
Accelerated
DSN open mode
file open mode used by LOAD command
Accept Remote Request
Active
files, monitoring
Adding
a new engine
turn off Gateway Durability
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
ANSI
character translation
Any-segment null keys
Btrieve Maintenance utility and
description files and
Applications
configuration scenarios
Architecture
smart components
Smart Components
Archival logging
definition of 1 2
disk I/O and
file backups and
referential integrity and
transaction logging and
Archival Logging Selected Files configuration parameter
Array fetch
ArrayBufferSize connection string
ArrayFetchOn connection string
ASCII data file format
Btrieve Maintenance utility and
BUTIL and
Asynchronous I/O
Atomicity, transaction
not guaranteed with multiple engines
Attributes
client configuration
win16
win32
engine configuration 1 2
file
showing in File Information Editor
Authentication
Server engine vs. Workgroup
Auto Reconnect Timeout configuration parameter
Auto-reconnect
defined
Available Linked Keys
Btrieve Maintenance utility and
B
Back to Minimal State if Inactive configuration parameter 1 2
Back up
continuous operations
Backing up
a database, and BUTIL
data files
Backing up data
continuous operations
Backup
and restore
bcfg
unable to connect to database engine error on Linux
Bcfg utility
command syntax
configuration
configuration utility
java.lang.UnsatisfiedLinkError error on Linux
troubleshooting starting on Linux
unable to connect to database engine error on Linux
Binding
Smart Components and
Blank truncation
Btrieve Maintenance utility and
description files and
bmon
java.lang.UnsatisfiedLinkError error on Linux
monitoring utility
troubleshooting starting on Linux
Bound database
properties for database
Bound databases
Btrieve and
Brebuild.nlm
may hog CPU
Btrieve
constraints when used with SRDE access
interaction with relational constraints
login configuration
owner name
security
before you begin
quick start
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
Btrieve Interface Module, displaying version
Btrieve Maintenance utility
about
creating a file
extended files and
menu options
online help
starting
Buffers
editing key and data
Building
external index files, and BUTIL
BUTIL
about
ASCII files
backing up databases
command files
rules
commands
CLONE
CLROWNER
COPY
CREATE
DROP
ENDBU 1 2
INDEX
LOAD
overview
RECOVER
ROLLFWD 1 2
SAVE
SETOWNER
SINDEX
STARTBU 1 2
STAT
STOP
VER
creating and modifying data files
displaying Btrieve interface module version
extended file support
importing and exporting data 1 2
overview
owner names
recovering changes after system failure
redirecting error messages
return codes
starting and stopping continuous operation 1 2
syntax
unloading the Btrieve engine
viewing command syntax
C
Cache
client
memory usage 1 2
database
data pages and
how to calculate ideal size
limited to 2 GB on Windows 1 2
physical memory and
Cache allocation size
effect on rebuilding files
Cache Allocation Size configuration parameter
virtual memory and
Cache engine
Cascade rule
Case sensitivity in keys
Btrieve Maintenance utility and
description files and
Changing
gateway engine across multiple data directories
See also How to
Character
translation
OEM to ANSI
Characters
valid in regular identifier
Classic
security model
Clearing owner names
and BUTIL
Btrieve Maintenance utility and
Client
cache
memory usage 1 2
DSN
options
optimizing support for multiple clients
CLONE command
CLROWNER command
Cluster, see Clustering
Clustering
databases on shared disk 1 2
failback 1 2
licensing Pervasive PSQL
Microsoft Cluster Service
add Pervasive.SQL transactional service
configure PCC for
test relational connection from Pervasive PSQL client
test transactional connection from Pervasive PSQL client
verify cluster functioning correctly
modes
NetWare Cluster Services
configure PCC for
dbnames.cfg file
load script
odbc.ini
psrgstry.cfg file
test relational connection from Pervasive PSQL client
test transactional connection from Pervasive PSQL client
verify cluster functioning correctly
server
COLLATE.CFG file
Collating sequence
Column
name
maximum length
valid characters
Command files
BUTIL and
rules
Command line parameters for Rebuild utility
Command-line interface
bcfg utility for configuration
Command-line utilities, see BUTIL
Comments
in description files
Common address space
Communications
auto-reconnect feature
monitoring
MicroKernel
Communications Threads configuration parameter
Compacting data files
and Btrieve Maintenance utility
and BUTIL
Component IDs
Components
load order of engine components
smart
Components, Smart See Smart Components
Compressing data files
Btrieve Maintenance utility and
description files and
Configuration
optimizing
properties for database
using bcfg utility 1 2
using command-line interface
Configuration file
Configuration parameters
client
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
Splash Screen
Supported Protocols 1 2
Trace File Location
Trace Operation
Use Cache Engine
Use IDS
Use Local MicroKernel Engine
Use Remote MicroKernel Engine
Verify Key Length
Wire Encryption
Wire Encryption Level
Linux client
Embedded Spaces
Enable Autoreconnect
Supported Protocols
Use IDS
Use Local MicroKernel Engine
Use Remote MicroKernel Engine
Verify Key Length
Wire Encryption
Wire Encryption Leve
Monitor and
server
Access
Allocate Resources at Startup
Allow Cache Engine Connections
Allow Client-stored Credentials
Archival Logging Selected Files
Authentication
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
Encoding
Encryption Level
File Growth Factor
Index Balancing
Initiation Time Limit
Limit Segment Size
Listen IP Address
Load Brouter
Log Buffer Size
Max MicroKernel Memory Usage
Minimal State of Delay
NetBIOS Port
Number of Bytes from Data Buffer
Number of Bytes from Key Buffer
Number of I/O Threads
Operation Bundle Limit
Prompt for Client Credentials
Receive Packet Size
Runtime Server Support
Select Operations
Sort Buffer Size
Supported Protocols
System Cache
System Data
TCP/IP Multihomed
TCP/IP Port
Trace File Location
Trace Operation
Transaction Durability
Transaction Log Directory
Transaction Log Size
Transaction Logging
Use SAP
Wait Lock Timeout
Wire Encryption 1 2
Working Directory
Win-16 client
Runtime Server Support
Splash Screen
Supported Protocols
TCP/IP Timeout
Use Local MicroKernel Engine
Use Remote MicroKernel Engine
Use Thunk
Verify Key Length
Configuration Utility
Configuring
application scenarios
PCC for clustering, see Clustering
Connecting
to workgroup, eliminating delay
Connection
delay
how to minimize
troubleshooting for Workgroup
terminating user
timeout
Connection strings
OPENMODE
TRANSLATIONDLL
Connection Timeout parameter
Constraints
mixed access
referential integrity
Continuous operations
backing up data file
file locked because of
Continuous Operations
definition of 1 2
ending
starting
starting with BUTIL
stopping with ENDBU
transaction logging and
Converting
data files
with command-line Rebuild utility
with GUI Rebuild utility
OEM to ANSI characters
COPY command
BUTIL and
Copying records between files
CPU speed
effect on rebuilding files
CREATE command
Create file version
Create File Version
Creating
data files
with BUTIL
files
Btrieve Maintenance utility and
BUTIL and
indexes
about
additional with BUTIL
primary key 1 2
redirecting Gateway Locator File
Credentials, definition of
Current database
definition of
D
Damaged files, recovering
BUTIL and
Data
compression
Btrieve Maintenance utility and
description files and
continuous operations
copying data from one MicroKernel file to another
encryption
encryption on disk
exporting ASCII data
files locked when in continuous operations
importing ASCII data
location of files for database
recovering changes to a data file
Data buffer
editing
Data directories for database
Data encryption
Data file
structure
Data file segments
Data files
compacting with Btrieve Maintenance utility
compacting with BUTIL
converting
with command-line Rebuild utility
with GUI Rebuild utility
copying with BUTIL
creating
creating with BUTIL
decreasing size of with Btrieve Maintenance utility
decreasing size of with BUTIL
generate statistics report
Data integrity
not guaranteed with multiple engines
Data pages
cache and
Data types
description files and
NULL
Data-only files
Database
bound
current, definition of
data directories
default, definition of
dictionary location
encoding
error 7039 when creating
integrity enforced
name
maximum length
valid characters
security model
setting properties for
Database cache
data pages and
how to calculate ideal size
physical memory and
Database engine
java.lang.UnsatisfiedLinkError error on Linux 1 2
unable to connect to error on Linux 1 2
Database name
where stored
DBNames Configuration Location 1 2
Dbnames file
Dbnames.cfg file 1 2
DBQ
connection string
DDF
file structure
DDF location for database
Decreasing data file size
with Btrieve Maintenance utility
with BUTIL
Default database
definition of
DefaultDB
Delay
connection
how to minimize
troubleshooting for Workgroup
Delete
rule
Delimited identifier
definition of
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
BUTIL and
format
Diagnosing
module load errors
Dictionary
location of files for database
Dictionary file
structure
Dictionary path
error 7039 when creating a database
Discrete ordering
null value
Disk I/O
archival logging and
how to minimize
transaction logging and 1 2
Disk speed
effect on rebuilding files
DLLs
load order of engine components
DROP command
Dropping
indexes
Btrieve Maintenance utility and
BUTIL and
DSN
client options
open modes
Duplicate keys
Durability
gateway
eliminating delay upon connection to Workgroup
Dynamic binding
E
Editor
File Information
Elements
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
Enabling transaction durability for NetWare
Encoding
properties for database
Encoding configuration parameter
Encryption
data
how to choose level
of data files
Encryption Level configuration parameter
ENDBU command
and continuous operation
BUTIL and
Ending Continuous Operations
Engine
DSN
open modes
Pervasive PSQL
Error
messages, redirecting with BUTIL
Error Code Clarification, about
Errors, load
Event logging
Exclusive
DSN open mode
Export files
naming convention 1 2
size limit 1 2
Exporting data
and BUTIL 1 2 3
ASCII file format
Btrieve Maintenance utility and
Extended files
Btrieve Maintenance utility and
BUTIL and
External
index files
Btrieve Maintenance utility and
BUTIL and
F
File
ASCII
attributes
showing in File Information Editor
automation upgrad of version
creating
delta 1 2
description 1 2
dividing into segments
export
naming convention 1 2
size limit 1 2
extended
Btrieve Maintenance utility and
BUTIL and
external index 1 2
maximum size
names, long
owner name
rebuilding
may hog CPU on NetWare
segmentation
size comparisons based on page size and records per page
specifications
Btrieve Maintenance utility and
description files and
structure
unformatted, see File, export 1 2
version
creation of
version upgrade
File Information Editor
Data File Info
Owner Name
Total Records
Version
Elements
Create File
Description Comments
File Specification 1 2
Help
Load Information
Set to Default
Show 6.x Attributes
File Specification
# Pages
% Free Space
Available Linked Keys
Balanced Indexing
Blank Truncation
Data Compression
Include VATs
Key-Only
Preallocation
Record Length
Variable Records
Key
ACS Information
All Segments
Any Segment
duplicates
Modifiable
Null Key
Repeating duplicates
Sparse Key
Unique Values
Key Segment
Case Insensitive
Data Types
Descending
Length
Null Value
Position
Use ACS
Tasks
Add comments to a description file
Compact a Btrieve file
Create a new file
Display 6.x-specific controls
Load information from an existing file
Specify a key's alternate collating sequence
File segments
File size
comparisons based on page size and records per page
Files
backing up
deleting temporary
optimizing support for multiple
Foreign key
adding to existing table
creating in a table
definition of
Free space threshold
Btrieve Maintenance utility and
description files and
Function
name
maximum length
valid characters
Function Executor utility
overview
performing operations
starting
starting the 16-bit utility
G
Gateway durability
configuration parameter
turn off when adding a new engine
Gateway engine
changing for multiple directories at once
see also Workgroup engine
Gateway Locator File
redirecting
creating a
GRANT
owner names and
Group
name
maximum length
valid characters
restrictions for
Groups
restrictions for
H
Handles
monitoring
High encryption
How
to add or remove network protocol support 1 2
to add or remove network protocol support for Linux client
to allow or prohibit embedded spaces in data file names
to calculate ideal size of database cache
to change
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
to ensure
transaction atomicity 1 2
transaction durability
transaction logging
to find
performance bottlenecks with Monitor
to increase performance on read operations by using index balancing
to limit
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
to minimize
client/server connection delay
disk I/O
to prevent
a Server or Workgroup engine from accepting remote requests
the Pervasive splash screen from appearing
to set default file format version for file creation
to specify
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
to turn on
Archival Logging
to use
client cache engine
I
I/O
asynchronous
Identifier
definition of
length for identifier names
restrictions
scope of
when name enclosed by quotes
Identifiers
regular
case-insensitivity of
Identifying
Smart Components
IDS
configuration parameter
Importing data
and BUTIL 1 2 3
ASCII file format
Index
balancing
Btrieve Maintenance utility and
configuration parameter 1 2
description files and
creating
creating and dropping
creating with BUTIL
dropping
name
maximum length
valid characters
viewing in the Btrieve Maintenance utility
INDEX command
BUTIL and
Index page size
effect on rebuilding files
Indexes
primary keys and
Initiation Time Limit configuration parameter
Integrity
not guaranteed with multiple engines
Interactive Btrieve Maintenance utility. See Btrieve Maintenance utility
Intigrity enforced
properties for database
J
Java.lang.UnsatisfiedLinkError error on Linux 1 2
K
Key
attributes 1 2
buffer
editing
cannot contain a null column
foreign
adding to existing table
creating in a table
definition of
linked duplicate
name
maximum length
valid characters
numbers
primary
adding to existing table
creating in a table
definition of
repeating duplicate
segment specifications 1 2
Key-only files
Btrieve Maintenance utility and
description files and
Keys
repeating duplicate
L
Large files. See Extended files
Length
maximum for identifier names
Licensing
for clustering
Limit Segment Size
configuration parameter
Limitations
users and groups
Linked duplicate keys
Linked-duplicate keys. See Linked duplicate keys
Linux
bcfg
errors trying to start
java.lang.UnsatisfiedLinkError engine error
troubleshooting starting
unable to connect to database engine error
bmon
errors trying to start
java.lang.UnsatisfiedLinkError engine error
troubleshooting starting
unable to connect to database engine error
directory owner required to create a database
Linux client
configuration parameters
setting properties
Load brouter configuration parameter
LOAD command
accelerated file open mode and
BUTIL and
Load errors, diagnosing
Load order of engine DLLs
Loading
Smart Components
Local configuration setting
see Use Local MicroKernel Engine 1 2
Lock
files locked when in continuous operations
Locking
row level
Locks, see Locking
Log Buffer Size
configuration parameter 1 2
transaction durability and
Logging
archival
referential integrity and
performance and
Pervasive PSQL events
transaction
transaction logging and archival logging
Login
configuration, Btrieve
Login credentials, definition of
Long file names
Low encryption
M
Max MicroKernel memory usage
effect on rebuilding files
MaxCache, definition of
Maximum
file size
length for identifier names
Medium encryption
Memory
common address space architecture
database cache and
determining amount needed
effect on rebuilding files
limit to 2 GB on Windows 1 2
MicroKernel Database Engine
common address space with SRDE
monitoring
monitoring resources
overview of
tracing
performance and
MicroKernel Database Engine message log. See Pervasive PSQL event log.
Microsoft
Cluster Service See Clustering
Minimal State of Delay configuration parameter 1 2
Minimizing
disk I/O
Mixed
security model
Mixed access constraints
Mixed security policy
Workgroup engines and
Models
security
Modes
DSN open
Modifiable keys 1 2
Modifying
data files
with BUTIL
Module load errors, diagnosing
Monitor
configuration parameters and
finding performance bottlenecks with
how to identify performance problems
overview
terminating a user connection
Monitor utility
See Monitor
Monitoring
active files
handles
MicroKernel communications
MicroKernel resources 1 2
SQL interface resources
user information
using bmon utility
utilities for
Multiple
clients
optimizing support for
files
optimizing support for
processors
use of
N
Named databases
where metadata stored
Named objects
scope of
Names of delimited identifiers
Names of objects
restrictions for
Names of regular identifiers
case-insensitivity of
valid characters
Naming
extended file
of Smart Components, convention
NetBIOS
not supported by Server engine
NetBIOS Port configuration parameter
NetWare
brebuild.nlm may hog CPU
Cluster Services See Clustering
enabling transaction durability
Workgroup engine and
Network
auto-reconnect feature
connection timeout
ports used 1 2
Normal
DSN open mode
Null
keys
not allowed in a key column
NULL
data type
Null key
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
O
Object names
restrictions for
ODBC
connection strings
TCP/IP port number
tracing
performance and
Odbc.ini
OEM to ANSI
character translation
connection string
Open modes
OPENMODE connection string
Operation Bundle Limit
Operations, performing with Function Executor
Optimizing
database configuration
read-heavy databases
Optimizing the rebuild process
Options
client DSN
Owner name
setting for a file
Owner names
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
summary
P
Page
preallocation
Btrieve Maintenance utility and
description files and
sizes
Btrieve Maintenance utility and
description files and
Page size
effect on file size
PAM
authentication
library
required link to
required link to PAM library
PAR file
PARC See Auto-reconnect
Password
name
maximum length
valid characters
Performance
client cache 1 2
logging and
tuning
virtual memory and
Pervasive Control Center
configure for Microsoft Cluster Service
configure for NetWare Cluster Services
OEM characters and
Pervasive PSQL
engine
event log
field descriptions
file location
overview
Pervasive_admin
security group
Planning security scheme
Platform codes
in Smart Component naming
Port number
NetBIOS
TCP/IP 1 2
TCP/IP ODBC
Primary key
adding to existing table
creating in a table
definition of
Procedure
name
maximum length
valid characters
Processors, multiple
see Multiple processors
Prompt for Client Credentials configuration parameter
Properties
bound database
data directories location for database
dictionary location for database
encoding for database
integrity enforced for database
setting for database
setting for Linux client
setting with bcfg utility
setting with command-line utility
Protocols
supported
Psrgstry.cfg file
PVSW.LOG
file
PVWAITVOL NLM
PWD connection string
Q
Quoted names
R
Read-only
DSN open mode
Rebuild utility
CLI example for Linux
CLI example for NetWare
CLI example for Windows
CLI versions
command line parameters
deleting temporary files
GUI version
may hog CPU on NetWare
optimizing the rebuild process
running CLI on Windows
running on Linux
running on NetWare
settings for GUI utility
Rebuilding files
amount of memory
cache allocation size
CPU speed and disk speed
GUI Rebuild utility
index page size
max MicroKernel memory usage
may hog CPU on NetWare
number of indexes
optimizing the rebuild process
sort buffer size
Receive Packet Size configuration parameter
Record
length
Btrieve Maintenance utility and
description files and
Records
copying between data files
effects of number of on file size
exporting
Btrieve Maintenance utility and
BUTIL and
importing
Btrieve Maintenance utility and
BUTIL and
variable-length
Btrieve Maintenance utility and
description files and
RECOVER command
Recovering
changes
and BUTIL
damaged files
Btrieve
data
Redirecting Locator File, See Gateway Locator File
Referential constraints
listing
Referential integrity
archival logging and
Btrieve and
cascade
definition of
delete rule
foreign key
primary key
restrict
rule, definition of
update rule
Registry setting
for embedded spaces 1 2
Regular identifier
definition of
length for names
Regular identifiers
case-insensitive of
valid characters
Relational architecture
client
server 1 2
Relational interface
security for
Relational security
Btrieve and
owner names and
Repeating duplicate keys
Btrieve Maintenance utility and
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
MicroKernel
Restore and backup
Restoring
data files
Restrict rule
Restrictions
for identifiers
for users and groups
REVOKE
owner names and
ROLLFWD command
BUTIL and
file backups and
Row level locking
Rules
cascade
delete
restrict
update
Runtime Server Support
configuration parameter
Runtime Server Support configuration parameter
Runtime Server Support setting for Win-16 client
S
SAR file
SAVE command
BUTIL and
Scope
of identifiers
of named objects
Search algorithm for Smart Components
Security
Btrieve
before you begin
classic model
reasons to choose
database model
reasons to choose
encryption of data files
for relational interface
mixed model
reasons to choose
models for transactional interface
owner name
policy
planning
quick start for transactional interface
summary
transactional vs relational
Workgroup engine
Segment
file
Segmentation
for data file
of files
Segmented
files
Segments in keys 1 2
Select Operations configuration parameter 1 2
Server
clustering
differences from Workgroup
Server engine
asynchronous I/O and
optimizing performance
ServerDSN
connection string
ServerName connection string
Services
running Workgroup engine as
Services DLL in Smart Components
SETOWNER command
Setting
Monitor Utility Options
owner names
about
Btrieve Maintenance utility and
BUTIL and
Settings
for Linux client
specifying with bcfg utility
specifying with command-line utility
SINDEX command
Size
limit of export files 1 2
maximum for data files
Size of files
comparisons based on page size and records per page
Smart components
Smart Components
dynamic binding
identifying
naming
component type codes
platform codes
search algorithm
Services DLL
Sort buffer size
effect on rebuilding files
Sort Buffer Size configuration parameter
Sort order in keys
Btrieve Maintenance utility and
description files and
Sparse key
Splash screen
prevent from appearing
Splash Screen
Splash Screen setting for Win-16 client
SPX
connection timeout
SQL Data Manager
OEM characters and
SQL Interface Resources
Monitoring
SQL Relational Database Engine
common address space with MicroKernel
constraints when used with Btrieve access
overvie
