Product Documentation

Database Administrator's Guide

Previous Topic

Next Topic

File Management

 
AUTO_CLNIDXX

Permits automatic CLNIDXX() during file open when a transaction high water mark, hghtrn, is found at file open to exceed the current transaction number.

 
AUTO_MKDIR

When creating a c-tree data or index file, causes FairCom DB to automatically create directories for the filename that do not exist.

CHECK_FILENAME_VALIDITY (CHECK_FILENAME_VALIDITY, CHECK_FILENAME_VALIDITY)

Restore Driver-Relative path handling as prior to V12.


COALESCE_TRNLOG

Attempt to combine deleted space with adjacent deleted space in ctTRNLOG files that do not have a RECBYT index.

 
FILE_CREATE_MODE

Specifies the desired file permission mode assigned to files on Unix systems.

 
FILE_HANDLES

On Unix, changes the number of file handles (at O/S level) that the O/S allows to be used by the FairCom Server.

 
FILE_PERMISSIONS

Permits default file permissions to be assigned to one or more groups including two special groups: WORLD and OWNER.

 
INHERIT_FILE_PERMISSIONS

Enables or disables inheriting file permissions from world to group to owner.

 
KEEPOPEN_CLOSE_RETRY_LIMIT

Determines the number of times to retry the close operation before failing.

 
KEEPOPEN_LIST

Upon file creation or physical open, attaches the KEEPOPEN attribute to the data file (and its indexes) if the file is a data file that matches a <file spec> and the file creation/open is part of an ISAM creation or open.

 
MAX_DFRIDX_LOGS (MAX_DFRIDX_LOGS, MAX_DFRIDX_LOGS)

Changes the limit FairCom Server sets for the number of active transaction logs that are kept for deferred indexing.

 
MAX_FILES_PER_USER

Limits number of files per user when auto resizing comes into effect (e.g., a file operation uses a file number beyond the existing client file range or a new file number is assigned automatically).

 
MAX_VIRTUAL_FILES

Specifies the maximum number of virtual files that may be opened at one time.

 
MEMFILE_MAX_BINS

Sets the maximum number of hash bins allowed for a memory file at run time.

 
MEMORY_FILE

Enables creating memory files if the file matches the specified file name.

 
SPLIT_NBR_OF_FILES

Sets the number of files when using the partitioning file rule.

 
TMPNAME_PATH

Sets the default directory for temporary files.

 
Compression

 
CMPREC_TYPE

Specifies the type of data compression type for files.

 
COMPRESS_FILE

Forces FairCom DB to create data files whose names match the specified name with data compression enabled.

 
FILESYS_COMPRESS_FILE

Enables Windows file system compression on specified data and index files.

 
Segmented Files

 
HUGE_TO_SEG_MB

Force any huge file to be created as a segmented file.

 
MATCHING_SEGMENT

Specifies behavior when an attempt to create a new file segment encounters an existing segment with the same name and the file ID matches the host file’s ID and other attributes.

 
NONMATCHING_SEGMENT

Specifies behavior when an attempt to create a new file segment encounters an existing segment with the same name and the file ID does not match the host file’s ID and other attributes.

 
Diagnostics

Diagnostics keywords are intended to be used to help collect data to be analyzed for troubleshooting. The use of these keywords should be avoided in normal operation as they may cause additional overhead (e.g., logging).

 
DIAGNOSTICS PTADMIN

Enables the filename and list of open instances of that file to be logged to CTSTATUS.FCS when a partition member purge fails with error 718.

In This Section

AUTO_CLNIDXX

AUTO_MKDIR

CHECK_FILENAME_VALIDITY

CMPREC_TYPE

COALESCE_TRNLOG

COMPRESS_FILE

FILE_CREATE_MODE

FILE_HANDLES

FILE_PERMISSIONS

FILESYS_COMPRESS_FILE

HUGE_TO_SEG_MB

INHERIT_FILE_PERMISSIONS

KEEPOPEN_CLOSE_RETRY_LIMIT

KEEPOPEN_FLUSH

KEEPOPEN_LIST

LEAF_NODE_READ_LOCK

MATCHING_SEGMENT

MAX_FILES_PER_USER

MAX_REBUILD_QUEUE

MAX_VIRTUAL_FILES

MEMFILE_MAX_BINS

MEMORY_FILE

NONMATCHING_SEGMENT

SPLIT_NBR_OF_FILES

TMPNAME_PATH

DIAGNOSTICS PTADMIN

TOCIndex