527 lines
20 KiB
Plaintext
Executable File
527 lines
20 KiB
Plaintext
Executable File
###########################################
|
|
#
|
|
# UniVerse tunable parameters
|
|
#
|
|
# Version I Date H
|
|
#
|
|
# (c) Copyright 1998 Ardent Software Inc.
|
|
# - All Rights Reserved
|
|
# This is unpublished proprietary source
|
|
# code of Ardent Software Inc.
|
|
# The copyright notice above does not
|
|
# evidence any actual or intended
|
|
# publication of such source code.
|
|
#
|
|
###########################################
|
|
|
|
# MFILES - specifies the size of the
|
|
# UniVerse rotating file pool. The
|
|
# value of MFILES should be set to a
|
|
# value no greater than the kernels
|
|
# per process open file limit less the
|
|
# sum of the maximum number of named
|
|
# pipes opened by a user application
|
|
# and the 8 files reserved for internal
|
|
# UniVerse use.
|
|
MFILES 300
|
|
|
|
# T30FILE - specifies the number of
|
|
# dynamic files that may be opened.
|
|
# Used to allocate shared memory
|
|
# concurrency control headers.
|
|
T30FILE 3000
|
|
|
|
# OPENCHK - the modifies the behavior of
|
|
# operations upon files open via the BASIC
|
|
# OPEN statement. When set to zero, I/O
|
|
# to files open with the BASIC OPEN statement
|
|
# ignore integrity constraints. If non-zero
|
|
# those files will observe the constraints.
|
|
# This tunable does not affect files opened
|
|
# via the OPENCHECK statement.
|
|
OPENCHK 1
|
|
|
|
# WIDE0 - is the mask used internally to
|
|
# decide when the difference between two
|
|
# numeric values is close enough to zero
|
|
# to be called zero. For information
|
|
# please request Technical Bulletin 74-0051
|
|
WIDE0 3dc00000
|
|
|
|
# UVTEMP - is the name of the directory
|
|
# where UniVerse will put select lists
|
|
# and other internal temporary work
|
|
# files. This should be a fully
|
|
# qualified name of no more than 112
|
|
# characters. E.g. C:\TEMP
|
|
UVTEMP C:\UVTEMP
|
|
|
|
# SCRMIN - specifies the minimum size of
|
|
# UniVerse scratch buffer pool. This
|
|
# value must be at least 1 and must be
|
|
# specified before SCRMAX.
|
|
SCRMIN 3
|
|
|
|
# SCRMAX - specifies the maximum size of
|
|
# UniVerse scratch buffer pool. This
|
|
# value must be no smaller than SCRMIN
|
|
# and must be specified after SCRMIN.
|
|
SCRMAX 5
|
|
|
|
# SCRSIZE - specifies the size of newly
|
|
# allocated internal scratch buffers. This
|
|
# value must not be smaller than 512 and
|
|
# values greater than 2048 are not advised.
|
|
SCRSIZE 512
|
|
|
|
# QDEPTH - is the maximum number of additional
|
|
# levels of indirection (beyond the first)
|
|
# allowed in Q-pointer references before
|
|
# the chain is determined to be too long.
|
|
# The minimum valid value is 0.
|
|
QDEPTH 16
|
|
|
|
# HISTSTK - is the maximum number of elements
|
|
# in a users command history stack.
|
|
HISTSTK 99
|
|
|
|
# QSRUNSZ - sets the size of each initial
|
|
# sorting run used by the query languages
|
|
# sorting algorithm. Great care should be
|
|
# exercised when changing this parameter.
|
|
# The efficiency of the sort processor is
|
|
# very sensitive to this value. Minimum
|
|
# accepted for this value is 2.
|
|
QSRUNSZ 2000
|
|
|
|
# QSBRNCH - sets the number of runs which
|
|
# cause a sub-merge to be performed. This
|
|
# is sometimes refered to as the branching
|
|
# factor of the sort. Great care should be
|
|
# exercised when changing this parameter.
|
|
# The efficiency of the sort processor is
|
|
# very sensitive to this value. Minimum
|
|
# accepted for this value is 2.
|
|
QSBRNCH 4
|
|
|
|
# QSDEPTH - is the maximum depth of the sort
|
|
# tree. Great care should be exercised
|
|
# when changing this parameter.
|
|
# The efficiency of the sort processor is
|
|
# very sensitive to this value.
|
|
QSDEPTH 8
|
|
|
|
# QSMXKEY - is the maximum number of sort
|
|
# key components.
|
|
QSMXKEY 32
|
|
|
|
# TXMODE - This sets the transaction mode
|
|
# observed by the system. A value of zero allows
|
|
# transactions to execute but not be logged and
|
|
# will prevent the log daemon from being activated.
|
|
# A value of 1 allows the log daemon to be
|
|
# activated and will require that the log daemon
|
|
# be running before a transaction executes.
|
|
TXMODE 0
|
|
|
|
# LOGBLSZ - should be the same as the block size of
|
|
# the file system where the log directory is mounted.
|
|
# Along with the LOGBLNUM tunable, it determines
|
|
# the size of the Transaction logging buffer.
|
|
LOGBLSZ 512
|
|
|
|
# LOGBLNUM - is the number of blocks that make
|
|
# up the Transaction logging buffer. Along with
|
|
# the LOGBLSZ tunable, it determines the size of
|
|
# the Transaction logging buffer.
|
|
LOGBLNUM 8
|
|
|
|
# LOGSYCNT - is the maximum number of transaction
|
|
# commits between calls to synchronize the current
|
|
# log file. A value of 0 will be used if the
|
|
# specified value is less than 2.
|
|
LOGSYCNT 0
|
|
|
|
# LOGSYINT - is the maximum time interval between calls
|
|
# to synchronize the current log file. Any non-zero
|
|
# value less than 5 is changed to 5. If LOGSYINT is 0
|
|
# and LOGSYCNT is non-zero then LOGSYINT is set to
|
|
# 120. If LOGSYCNT and LOGSYINT are zero then the
|
|
# current log file is opened with the O_SYNC flag.
|
|
LOGSYINT 0
|
|
|
|
# TXMEM - This is the amount of memory allocated
|
|
# for the private transaction cache. It is
|
|
# specified in 1K units (1024 bytes).
|
|
TXMEM 32
|
|
|
|
# OPTMEM - This is the amount of memory allocated
|
|
# for the query optimizer's workspace. It is
|
|
# specified in 1K units (1024 bytes).
|
|
OPTMEM 64
|
|
|
|
# SELBUF - This is the size of the in-memory
|
|
# select list buffer. It is the amount of locally
|
|
# cache select data which can be stored before
|
|
# the select list starts using disk storage. It
|
|
# is specified in 1K units (1024 bytes).
|
|
SELBUF 4
|
|
|
|
# FSEMNUM - sets the number of file lock semaphore
|
|
# sets used for concurrency control. Great care
|
|
# should be exercised when changing this parameter.
|
|
# The performance of the disk i/o subsystem may
|
|
# be profoundly affected.
|
|
FSEMNUM 23
|
|
|
|
# GSEMNUM - sets the number of group lock semaphore
|
|
# sets used for concurrency control. Great care
|
|
# should be exercised when changing this parameter.
|
|
# The performance of the disk i/o subsystem may
|
|
# be profoundly affected.
|
|
GSEMNUM 97
|
|
|
|
# PSEMNUM - sets the number of BASIC user process
|
|
# control locks.
|
|
PSEMNUM 64
|
|
|
|
# FLTABSZ - sets the number of file lock entries
|
|
# in a file lock semaphore set. Great care
|
|
# should be exercised when changing this parameter.
|
|
# The performance of the disk i/o subsystem may
|
|
# be profoundly affected.
|
|
FLTABSZ 11
|
|
|
|
# GLTABSZ - sets the number of group lock entries
|
|
# in a group lock semaphore set. Great care
|
|
# should be exercised when changing this parameter.
|
|
# The performance of the disk i/o subsystem may
|
|
# be profoundly affected.
|
|
GLTABSZ 75
|
|
|
|
# RLTABSZ - sets the number of read lock entries
|
|
# (both exclusive, READU, and shared, READL) in a
|
|
# group lock semaphore set. Great care should be
|
|
# exercised when changing this parameter. The
|
|
# performance of the disk i/o subsystem may be
|
|
# profoundly affected.
|
|
RLTABSZ 75
|
|
|
|
# RLOWNER - sets the number of lock owner entries
|
|
# are maintained for shared (READL) locks in a
|
|
# group lock semaphore set. Great care should be
|
|
# exercised when changing this parameter. The
|
|
# performance of the disk i/o subsystem may be
|
|
# profoundly affected.
|
|
RLOWNER 300
|
|
|
|
# PAKTIME - sets the number of seconds query is to
|
|
# wait at the Press Any Key to continue message
|
|
# before releasing a pending group lock.
|
|
PAKTIME 15
|
|
|
|
# NETTIME - sets the timeout value for UVNET.
|
|
# This timer is expressed in minutes.
|
|
NETTIME 5
|
|
|
|
# QBREAK - This boolean when selects the function of
|
|
# Q/ctrl-X at the press any key to continue message.
|
|
# A value of zero means the Q/ctrl will be ignored
|
|
# while in BREAK OFF mode. A non-zero value will
|
|
# allow the Q/ctrl-X key to quit at the press any
|
|
# key to continue message even in BREAK OFF mode.
|
|
# There are security implication to selecting the
|
|
# latter mode of operation.
|
|
QBREAK 1
|
|
|
|
# VDIVDEF - This selects the default action of
|
|
# the vector divide operator when the divisor
|
|
# values are exhausted prematurely. A value of
|
|
# zero causes a zero to be returned; a non-zero
|
|
# values causes the dividend to be returned.
|
|
VDIVDEF 1
|
|
|
|
# UVSYNC - This boolean if set will change the
|
|
# behavior of UniVerse calling the UNIX sync()
|
|
# call on exit the environment. A non-zero value
|
|
# will mean UniVerse will do a UNIX sync() if a job
|
|
# leading UniVerse process exits. This value should
|
|
# only be modified if you know exactly what you are
|
|
# doing. Data loss may occur if UNIX sync is not
|
|
# executed frequently enough.
|
|
UVSYNC 1
|
|
|
|
# BLKMAX - sets the maximum block size for uvbackup
|
|
# and uvrestore. It must be a minimum of 512 and
|
|
# must also be a multiple of 512.
|
|
BLKMAX 8192
|
|
|
|
# PICKNULL - This sets the masked decimal conversion
|
|
# for empty data. A value of 1 turns on pick style
|
|
# conversions, where empty data will convert to an
|
|
# empty string. A value of 0 indicates UniVerse style
|
|
# conversions where empty data will be converted
|
|
# to 0.00 .
|
|
PICKNULL 1
|
|
|
|
# SYNCALOC - When set, the UniVerse database manager
|
|
# forces any I/O operations which allocate new file
|
|
# space to be done synchronously. This helps improve
|
|
# the robustness of the file system in the event of a
|
|
# system failure. The expected performance impact
|
|
# is minor for most applications. The recommended
|
|
# default for this parameter is ON (1).
|
|
SYNCALOC 1
|
|
|
|
# MAXRLOCK - This defines the number of record locks which
|
|
# may be obtained against one file in an SQL transaction
|
|
# before the lock manager escalates the locking strategy
|
|
# to obtain a file lock
|
|
MAXRLOCK 100
|
|
|
|
# ISOMODE - When set, a UniVerse transaction running at
|
|
# an isolation level of 0 will fail writes of records
|
|
# if no update lock is held
|
|
ISOMODE 1
|
|
|
|
# PKRJUST - When set, this will allow RetrieVe reports where
|
|
# the data length in a right justified column exceeds the
|
|
# column length, to overwrite previous columns
|
|
PKRJUST 0
|
|
|
|
# PROCACMD - Defines the action for the PROC A command using
|
|
# the optional syntax A(n,m) or A(,m). A zero value will
|
|
# terminate when m number of characters are moved, or either
|
|
# a field mark or the end of the input buffer is encountered.
|
|
# A positive non-zero value will terminate when m number of
|
|
# characters are moved or the end of the input buffer is encountered.
|
|
# This affects only PQ defined PROCS.
|
|
PROCACMD 0
|
|
|
|
# PROCRCMD - Determines the behavior of the PROC RI# command.
|
|
# If zero, an RI# command will clear the input buffer from location
|
|
# # and remove the preceding attribute mark. If non-zero,
|
|
# the preceding attribute mark will not be removed. A non-zero
|
|
# approximates the behavior of true R83 Pick.
|
|
PROCRCMD 1
|
|
|
|
# PROCPRMT - Determines the effect of the UniVerse PROMPT command
|
|
# on the PROC prompt. If zero, the PROC prompt is changed by
|
|
# by the PROMPT command. If non-zero, the PROC prompt remains
|
|
# the default and can only be changed by the IPc command in PROC.
|
|
#
|
|
PROCPRMT 0
|
|
|
|
# ALLOWNFS - Specifies whether UniVerse files stored on NFS or RFS mounted
|
|
# file systems are allowed to be opened without uVnet.
|
|
# A zero value is the default and means that the uVnet package
|
|
# is required to access remote files. A non-zero value will permit the
|
|
# remote files to be opened, but locks will not be maintained on
|
|
# the remote system. This parameter should only be turned on in the case
|
|
# where UniVerse is not running on the remote system since file integrity
|
|
# is compromised when locks are not maintained on the remote system.
|
|
ALLOWNFS 1
|
|
|
|
# CSHDISPATCH - Defines the full path for the csh shell command.
|
|
# Allows alternative C-shells to be used. For platforms that do not
|
|
# support csh set this to 'NOT_SUPPORTED'. A typical value for UNIX
|
|
# platforms is '/usr/bin/csh'. The default to Windows NT is that this
|
|
# command is unsupported. If you have a C-Shell replacement on your
|
|
# system specify the full pathname of the executable here.
|
|
CSHDISPATCH NOT_SUPPORTED
|
|
|
|
# SHDISPATCH - Defines the full path for the sh shell command.
|
|
# Allows alternative Bourne shells to be used. For platforms that do not
|
|
# support sh set this to 'NOT_SUPPORTED'. A typical value for UNIX
|
|
# platforms is '/usr/bin/sh'. The default to Windows NT is that this
|
|
# command is unsupported. If you have a Bourne Shell replacement on your
|
|
# system specify the full pathname of the executable here.
|
|
SHDISPATCH NOT_SUPPORTED
|
|
|
|
# DOSDISPATCH - Defines the full path for the DOS Batch command interpreter.
|
|
# Allows alternative interpreters to be used. For platforms that do not
|
|
# support DOS batch commands set this to 'NOT_SUPPORTED'. This is the default
|
|
# value for all UNIX platforms. The default for Windows NT is 'CMD.EXE'. This
|
|
# Assumes that the standard command interpreter is located in the Windows NT
|
|
# System32 directory. A full pathname of the command interpreter can be
|
|
# specified to ensure that a similar executable is not found in the PATH
|
|
DOSDISPATCH CMD.EXE
|
|
|
|
# LAYERSEL - Determines whether a select list will remain active
|
|
# upon returning from a higher execute layer. A zero
|
|
# value will effect traditional UniVerse behavior whereby the select
|
|
# list will still be active when returning to another layer which
|
|
# is not topmost. A non-zero value will clear any select lists
|
|
# before returning to the previous layer, unless K mode is active.
|
|
LAYERSEL 0
|
|
|
|
# OCVDATE - Specifies whether UniVerse accepts partially 'bad' internal date
|
|
# data. A zero value is the default and means that any value which
|
|
# is not wholly numeric and which is supplied as an internal date
|
|
# value to the command OCONV(<data>,'D') will be rejected as bad
|
|
# and not converted. A non-zero value for this parameter will allow
|
|
# data which is a number followed by other data, e.g. 9199-f, to be
|
|
# partially converted; the numbers up to the non-numeric character
|
|
# will be interpreted as the internal date, and the STATUS() function
|
|
# will be set to 3, indicating successful conversion of a possibly
|
|
# invalid date.
|
|
OCVDATE 0
|
|
|
|
# MODFPTRS - Specifies whether file pointers in the VOC file
|
|
# can be modified by the COPY, DELETE, and EDIT commands.
|
|
# A value of 0 disallows modifications of VOC File pointers.
|
|
# The default setting for this parameter is 1.
|
|
MODFPTRS 1
|
|
|
|
# THDR512 - Specifies whether DC type tapes will be written with
|
|
# 512 byte labels. The default setting is 0.
|
|
THDR512 0
|
|
|
|
# UDRMODE - Specifies the data replication mode observed
|
|
# by the system. A value of 1 enables data replication.
|
|
# A value of 0 disables data replication.
|
|
UDRMODE 0
|
|
|
|
# UDRBLKS - Specifies the number of 4096 byte blocks used for
|
|
# buffering by data replication. The default value is 10.
|
|
# A value less than 10 will be defaulted to a value of 10.
|
|
UDRBLKS 10
|
|
|
|
# MAXERRLOGENT - Specifies the number of logged entries in
|
|
# the errlog file. The default setting is 100.
|
|
MAXERRLOGENT 100
|
|
|
|
# JOINBUF - Specifies the size of the cache used by
|
|
# the optimizer for JOINs with explicit ids or indexes.
|
|
# The default setting is 4095, maximum is 32363.
|
|
JOINBUF 4095
|
|
|
|
# 64BIT_FILES - This sets the default mode used to
|
|
# create static hashed and dynamic files.
|
|
# A value of 0 results in the creation of 32-bit
|
|
# files. 32-bit files have a maximum file size of
|
|
# 2 gigabytes. A value of 1 results in the creation
|
|
# of 64-bit files (ONLY valid on 64-bit capable platforms).
|
|
# The maximum file size for 64-bit
|
|
# files is system dependent. The default behavior
|
|
# may be overridden by keywords on certain commands.
|
|
64BIT_FILES 0
|
|
|
|
# TSTIMEOUT - This sets the amount of time the UniVerse
|
|
# device licensing shell (uvdls) will wait for a
|
|
# connection from a telnet client (wIntegrate or SB
|
|
# client). Any value less than 1 will default to 60.
|
|
TSTIMEOUT 60
|
|
|
|
# PIOPENDEFAULT - This changes the default behavior of
|
|
# PIOPEN flavor accounts. When set to a zero value,
|
|
# current functionality is maintained. When set to a
|
|
# nonzero value, the following defaults take effect.
|
|
# $OPTIONS INFO.CONVERT is set on when BASIC programs are recompiled.
|
|
# $OPTIONS PIOPEN.EXECUTE is set on when BASIC programs are recompiled.
|
|
PIOPENDEFAULT 0
|
|
|
|
# NLSMODE - Set to 1 if NLS mode is ON for the
|
|
# system as a whole. 0 means that NLS mode is OFF.
|
|
NLSMODE 0
|
|
|
|
# NLSREADELSE - Set to 1 if READs that fail to map
|
|
# all characters in a record are to take the ELSE
|
|
# clause. 0 means that unmappable characters are
|
|
# returned as the Unicode "replacement" character,
|
|
# 0xFFFD.
|
|
NLSREADELSE 1
|
|
|
|
# NLSWRITEELSE - Set to 1 if WRITEs that fail to map
|
|
# all characters in a record are to abort (or take
|
|
# the ON ERROR clause if present). 0 means that
|
|
# unmappable characters are converted to the file
|
|
# map's "unknown" character (for example "?") before
|
|
# writing the record, and information may therefore
|
|
# be lost.
|
|
NLSWRITEELSE 1
|
|
|
|
# NLSDEFFILEMAP - Name of the map to be associated
|
|
# with hashed files that do not specify a map in
|
|
# their file header (that is, were created on a
|
|
# non-NLS system and have not had a SET.FILE.MAP
|
|
# done on them).
|
|
NLSDEFFILEMAP ISO8859-1+MARKS
|
|
|
|
# NLSDEFDIRMAP - Name of the map to be associated
|
|
# with type 1 and 19 files that do not specify a map
|
|
# in their directory (that is, were created on a
|
|
# non-NLS system and have not had a SET.FILE.MAP
|
|
# done on them).
|
|
NLSDEFDIRMAP ISO8859-1+MARKS
|
|
|
|
# NLSNEWFILEMAP - Name of the map to be associated
|
|
# with hashed files created when NLS mode is ON. A
|
|
# value of NONE means that the data is to be held in
|
|
# the native uniVerse/NLS character set, based on
|
|
# UNICODE.
|
|
NLSNEWFILEMAP NONE
|
|
|
|
# NLSNEWDIRMAP - Name of the map to be associated
|
|
# with type 1 and 19 files created when NLS mode is
|
|
# ON.
|
|
NLSNEWDIRMAP ISO8859-1+MARKS
|
|
|
|
# NLSDEFPTRMAP - Name of the map to be associated
|
|
# with printer output when a print device does not
|
|
# specify a map in &DEVICE&.
|
|
NLSDEFPTRMAP ISO8859-1+MARKS
|
|
|
|
# NLSDEFTERMMAP - Name of the map to be associated
|
|
# with terminal input/output when a terminal does
|
|
# not specify a map in its terminfo definition. Can
|
|
# be overridden by a SET.TERM.TYPE MAP command.
|
|
NLSDEFTERMMAP ISO8859-1+MARKS
|
|
|
|
# NLSDEFDEVMAP - Name of the map to be associated
|
|
# with input/output when a device other than a
|
|
# printer does not specify a map in &DEVICE&. Can be
|
|
# overridden by an ASSIGN MAP command.
|
|
NLSDEFDEVMAP ISO8859-1+MARKS
|
|
|
|
# NLSDEFGCIMAP - Name of the map to be used when
|
|
# passing string arguments to/from GCI routines, if
|
|
# a routine has not explicitly defined a map.
|
|
NLSDEFGCIMAP ISO8859-1+MARKS
|
|
|
|
# NLSDEFSRVMAP - Name of the map to be used when
|
|
# passing string arguments to/from client routines,
|
|
# if the server has not been given an explicit map.
|
|
NLSDEFSRVMAP ISO8859-1+MARKS
|
|
|
|
# NLSDEFSEQMAP - Name of the map to be associated
|
|
# with sequential file input/output to a file or
|
|
# device that has no explicit map associated with
|
|
# it. Can be overridden by a SET.SEQ.MAP command.
|
|
NLSDEFSEQMAP ISO8859-1+MARKS
|
|
|
|
# NLSOSMAP - Name of the map to use for file names
|
|
# or record IDs that are visible to the Operating
|
|
# System. This chiefly affects CREATE.FILE and
|
|
# records being written to type 1 or 19 files.
|
|
NLSOSMAP ISO8859-1
|
|
|
|
# NLSLCMODE - Set to 1 if NLS locale support is ON
|
|
# for the system as a whole. 0 means that NLS locale
|
|
# support is OFF. NLSMODE must also be set to 1
|
|
# before NLSLCMODE is actioned. If NLSLCMODE is set
|
|
# to 1, individual users can still turn locale
|
|
# support off by or all locale catgories to OFF.
|
|
NLSLCMODE 0
|
|
|
|
# NLSDEFUSERLC - Name of the initial locale to be
|
|
# set by default for a user who has not yet
|
|
# specified a locale.
|
|
NLSDEFUSERLC OFF
|
|
|
|
# NLSDEFSRVLC - Name of the locale to be used when
|
|
# communicating with client routines, if the server
|
|
# has not been given an explicit locale name.
|
|
NLSDEFSRVLC OFF
|
|
|