Pervasive logo

Prev Advanced Operations Guide Next

Special Notes on the Configuration Utility


This section contains information to help you understand the Configuration utility, which is described in the following sections:

When you start the Configuration utility, it is ready to configure client requesters and the engine on the local machine if one is present.

Ensuring Configuration Changes Take Effect

Most engine Configuration parameters require the database engine to be reloaded after they have been changed. You can re-load the engine in one of two ways:

In addition, changing client parameters often requires the client to be restarted. To re-load the client, simply exit all applications that depend on Pervasive.SQL and restart them.

Connecting to Different Machines

The Configuration utility can configure both local and remote engines as well as local client components; however, each engine must be configured separately. To configure a particular Pervasive.SQL engine:

  1. Open the Pervasive Control Center and double-click Pervasive.SQL Engines.

    If you wish to configure a machine that is not in your engines list, it must first added:

    1. Right click on Pervasive.SQL Engines and select Register New Engine from the pop-up menu.
    2. Type in the server name or use the browse button to search for the desired server. Click OK.
  2. Expand the desired engine and expand the Configuration section beneath that engine.

    If you are not logged into the server, you are prompted to enter your user name and password at this time. You must have full local administrator-level rights on the machine where the database engine is running, or be a member of the Pervasive_Admin group on the machine where the database engine is running, to view or change the engine configuration options.

  3. Expand all available options beneath Configuration. The options available will vary depending on the platform of the engine you are trying to configure.

When you are connected to a remote machine, you can view and change only engine components. Client components (such as on workgroup and workstation engines and client machines) can only be configured locally on each machine.


Note
If you have engines registered that are not running, you may encounter delays in PCC as it periodically attempts to contact these engines. To eliminate the delay, unregister the "dead" engines. You can minimize the delay by performing the following procedure:

In PCC, right-click Pervasive.SQL Engines and choose Properties. Set Poll interval (seconds) to 999. Click OK. You can also disable polling completely by clearing Enable service state polling on the same panel.

Interpreting Parameter Settings

Under each option, there are a number of parameters, which are displayed in the following table:

 
Table 4-1 Parameter Settings

Name
The name of the parameter.
Type
Defines the value type. The different types are:
  • Numeric
  • Bool(ean)
  • String
  • Multisel(ect) - choose several values from a given list
  • SelectOne - must choose one value from a given list
Value
Shows the current setting.
Units
If the value is numeric, this field explains any specific units of measure, such as KB or seconds, if required.


Note
If you cannot find information about a particular Configuration setting, click on the Find Setting icon on the tool bar. Enter the name of the desired setting and a list of case matches is displayed. You can display the setting information by clicking on the desired setting.

The following table outlines the functionality of the Configuration utility:

 
Table 4-2 Pervasive.SQL Win16, and Win32 Configuration Utilities



Configuration utility

Components that it configures
Transactional
Access: Where Changed
Relational
Access: Where Changed
Win32 Configuration utility

(Runs on Windows 98/NT/2000/XP client or Workgroup platforms or Windows NT/2000 server platforms.)
Local Win32 components
Windows Registry on local machine
Windows Registry on local machine
Local Win16 components
BTI.INI on local machine
ODBC.INI on local machine
Windows NT/2000 Server components (local or remote machines)
Windows Registry on Windows server
Windows Registry on Windows server
NetWare Server components
(remote machines only)
BTI.CFG on NetWare server
ODBC.INI on NetWare server
Linux Server components
(remote machines only)
bti.ini on Linux server
odbc.ini on Linux server
Win16 Configuration utility

(Runs on Windows 3.11, Windows 9x/NT/2000 (using Thunking) - Transactional access only)
Local Win16 components
BTI.INI on local machine
No 16-bit relational access
Windows NT/2000 Server components
(remote machine only)
Windows Registry on Windows NT server
No 16-bit relational access
NetWare Server components
(remote machines only)
BTI.CFG on NetWare server
No 16-bit relational access
Unix Server components
(remote machines only)
bti.ini on the Unix server
No 16-bit relational access

For each parameter appearing in Configuration, you can double-click the parameter to see a window showing the minimum, maximum, default, and current value of the parameter.

Access to Client Configuration Settings

All operating system users have permissions to modify the client configuration parameters.


Prev
Configuration Utility Overview
Contents
Up
Check for Revisions
Next
Configuration Utility Tips