Keeping Master Files Open on the FOCUS Database Server

How to:

Reference:

The SET SUWEDGE command provides a mechanism for keeping Master Files in memory on a FOCUS Database Server even though no users are accessing the files. This enhances performance by eliminating repeated parsing of Master Files on FOCUS Database Servers that have a large number of users running multiple applications using different files on the server.

You can specify that a number of files be wedged open, that specific named files be wedged open, or a combination of both. The maximum number of files that will be wedged open is 256, regardless of how many you specify.


Top of page

x
Syntax: How to Wedge Master Files Open on a FOCUS Database Server

Place one or more of the following commands in the server profile (PROFILE HLI):

SET SUWEDGE = {n|ddname} [,ddname ...]

where:

n

Is a number of Master Files to be wedged open. You can specify any number, but once 256 files are wedged open, additional files will not be wedged. The default is zero.

ddname

Is the ddname of a specific file to be wedged open in addition to the n files specified by number (if any).

Note: To set both a number of files to be wedged and one or more specific ddnames to be wedged, you can issue the SET SUWEDGE command multiple times or specify multiple options in one SET SUWEDGE command. Specific ddnames are not counted in the number of files specified (as long as the total does not exceed the maximum number of wedged files allowed). If you specify a number multiple times, the last one specified is the one used.


Top of page

x
Reference: Usage Notes for SET SUWEDGE


Example: Wedging Files Open on a FOCUS Database Server

The following commands wedge open any three FOCUS data sources plus the EMPLOYEE and CAR data sources:

SET SUWEDGE = 3
SET SUWEDGE = EMPLOYEE
SET SUWEDGE = CAR

or

SET SUWEDGE = 3
SET SUWEDGE = EMPLOYEE, CAR

or

SET SUWEDGE = EMPLOYEE, CAR
SET SUWEDGE = 3

or

SET SUWEDGE = 3, EMPLOYEE, CAR


Information Builders