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
Alter
setting permissions for
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 1 2
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
Backing up
a database, and BUTIL
data files
Backup
and restore
bcfg
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
unable to connect to database engine error 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
security
changing policy
classic
database
mixed
quick start
turning on
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
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
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.SQL
Microsoft Cluster Service
add Pervasive.SQL transactional service
configure PCC for
test relational connection from Pervasive.SQL client
test transactional connection from Pervasive.SQL 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.SQL client
test transactional connection from Pervasive.SQL 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 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
Components, Smart See Smart Components
Compressing data files
Btrieve Maintenance utility and
description files and
Configuration
optimizing
properties for database
using bcfg
Configuration file
Configuration parameters
client
Connection Timeout
Embedded Spaces
Enable Auto Reconnect
Encryption Level
Gateway Durability
Number of Bytes from Data Buffer
Number of Bytes from Key Buffer
Number of Load Retries
Runtime Server Support
Select Operations
Splash Screen
Supported Protocols 1 2
Trace File Location
Trace Operation
Use Cache Engine
Use IDS
Use Local MicroKernel Engine 1 2
Use Remote MicroKernel Engine 1 2
Monitor and
server
Access
Allocate Resources at Startup 1 2
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 3
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
Load Brouter
Log Buffer Size
Max MicroKernel Memory Usage 1 2
Minimal State of Delay 1 2
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
Working Directory
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
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 stored procedure
setting permissions for
Create table
setting permissions for
Create view
setting permissions for
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
copying data from one MicroKernel file to another
encryption on disk
exporting ASCII data
importing ASCII data
location of files for database
recovering changes to a data file
Data buffer
editing
Data directories for database
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
integrity enforced
name
maximum length
valid characters
setting permissions for
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.cfg file 1 2
DBQ
connection string
DDF location for database
Decreasing data file size
with Btrieve Maintenance utility
with BUTIL
Default database
definition of
Delay
connection
how to minimize
troubleshooting for Workgroup
Delete
rule
setting permissions for
Delimited identifers
Delimited identifier
definition of
length for names
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
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
Enable array fetch
Enable Auto Reconnect
configuration parameter 1 2
Enabling transaction durability for NetWare
Encoding
properties for database
Encryption
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.SQL
Entigrity enforced
properties for database
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
creating
delta 1 2
description 1 2
export
naming convention 1 2
size limit 1 2
extended
Btrieve Maintenance utility and
BUTIL and
external index 1 2
maximum size
names, long
rebuilding
may hog CPU on NetWare
specifications
Btrieve Maintenance utility and
description files and
unformatted, see File, export 1 2
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
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
Master user must grant self access if owner name set on file
owner names and
Group
cannot be a member of another group
name
maximum length
valid characters
Groups and users
restrictions
H
Handles
monitoring
High encryption
How
to add or remove network protocol support 1 2 3
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 1 2
to make the client use the local engine 1 2
to make the engine release resources if inactive
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 turn on security for Btrieve database
to use
client cache engine
I
I/O
asynchronous
Identifier
definition of
length for identifier names
scope of
when name enclosed by quotes
Identifiers
regular
case-insensitivity of
Identifying
Smart Components
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
Insert
setting permissions for
Integrity
not guaranteed with multiple engines
Interactive Btrieve Maintenance utility. See Btrieve Maintenance utility
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
maximum of user password
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
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
Locking
row level
Locks, see Locking
Log Buffer Size
configuration parameter 1 2
transaction durability and
Logging
archival
referential integrity and
performance and
Pervasive.SQL events
transaction
transaction logging and archival logging
Login
configuration, Btrieve
Login credentials, definition of
Long file names
Low encryption
M
Master user
must grant self access if owner name set on file
Max MicroKernel memory usage
effect on rebuilding files
MaxCache, definition of
Maximum
file size
length for identifier names
length of database user password
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.SQL event log.
Microsoft
Cluster Service See Clustering
Minimal State of Delay configuration parameter 1 2
Minimizing
disk I/O
Mixed access constraints
Mixed security policy
Workgroup engines and
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 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
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 names
BUTIL and 1 2 3
clearing with BUTIL
GRANT syntax and
how to set or clear an owner name
Master user must grant self access
relational security and
REVOKE syntax and
setting
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
PAR file
PARC See Auto-reconnect
Password
maximum length of database user
name
maximum length
valid characters
Performance
client cache 1 2
logging and
tuning
virtual memory and
Permissions
setting for alter
setting for create stored procedure
setting for create table
setting for create view
setting for database
setting for delete
setting for insert
setting for reference
setting for select
setting for table
setting for update 1 2
Pervasive Control Center
configure for Microsoft Cluster Service
configure for NetWare Cluster Services
OEM characters and
Pervasive.SQL
engine
event log
field descriptions
file location
overview
Planning security scheme
Platform codes
in Smart Component naming
Policy
security
changing
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
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
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 identifers
case-insensitive of
Regular identifier
definition of
length for names
Regular identifiers
valid characters
Relational architecture
client
server 1 2
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
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 1 2
S
SAR file
SAVE command
BUTIL and
Scope
of identifiers
of named objects
Search algorithm for Smart Components
Security
Btrieve
before you begin
changing policy
classic 1 2
Classic
database 1 2
mixed
quick start
turning on
encryption of data files
policy
planning
summary
transactional vs relational
Workgroup engine
Segmentation
for data file
Segments in keys 1 2
Select
setting permissions for
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
SINDEX command
Size
limit of export files 1 2
maximum for data files
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
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
overview of
STARTBU command
and BUTIL
and continuous operation
Starting
CLI Rebuild utility on Windows
continuous operation
and BUTIL
Rebuild utility on Linux
Rebuild utility on NetWare
STAT command
Statistics report
creating
Status Codes
116 1 2
12
85
STOP command
Stopping
continuous operation
Stored procedure
name
maximum length
valid characters
setting permissions for create
Stored procedures
Btrieve and
Strings
connection
Support
for long file names
Supported Protocols
configuration parameter 1 2 3
SYS:ODBC\odbc.ini file
SYS:SYSTEM\dbnames.cfg file
SYS:SYSTEM\psrgstry.cfg file
System
data
including in description files
failures, and recovering changes
System cache
asynchronous I/O and
System Cache configuration parameter
T
Table
adding foreign key to
adding primary key to
creating with a foreign key
creating with a primary key
name
maximum length 1 2
valid characters 1 2
setting permissions for
setting permissions for create
TCP/IP
port number
ODBC
ports used 1 2
TCP/IP Multihomed
configuration parameter
TCP/IP Port configuration parameter
TCP/IP Timeout for Communication Requester
configuration parameter
TCPPort connection string
Technology overview
relational architecture
client
server 1 2
Temporary files
Rebuild utility
deleting
Terminating a user connection
thread safety
Threads
multi-threaded engine
Trace File Location configuration parameter 1 2
Trace Operation configuration parameter 1 2
Tracing
performance and
Transaction
logging and BUTIL
Transaction atomicity
not guaranteed with multiple engines
Transaction Durability
disk I/O and
enabling for NetWare
ensuring 1 2 3
Log Buffer Size and
transaction log size and
transaction logging vs.
Transaction Log Directory configuration parameter 1 2
Transaction Log Size
configuration par
