Database Administrator's Guide

 
Introduction to FairCom DB Server Administration
Server Quick Start
Advanced FairCom DB Server Features
Client/Server Computing
Things an Admin Must Know and Do
Basic Connection String Attributes and Defaults
FairCom DB Interactive SQL - ISQL
FairCom DB ODBC Data Sources
ADO.NET Connection String
JDBC URL Connection String
Adding FairCom DB JDBC to a Third-Party JDBC Tool
FairCom DB Python
FairCom DB PHP
Data Compression
Compressed Files
Data Record Compression
Server Configuration
Compressed Files in c-treeDB
User Defined Compression Dynamic Shared Library
Index Page Size
Server Best Practices
Restrict Access to FairCom DB Server Files
Automatic Recovery
External Third-Party Utilities
File Rebuilds
Java Requirements for FairCom DB SQL
FairCom DB Server Configuration Recommendations
SKIP_MISSING_FILES
KEEP_LOGS
FORCE_LOGIDX
The Effects of Caching on Data Recovery
Disk Caching
Data and Index Caching
Data Recovery
The Cache Stack
FairCom Caching and Transaction Control
Transaction Processing
Full Transaction Processing
PreImage Transaction Processing
When to Use PREIMG Files
No Transaction Processing
When to Use Non-Transaction Files
Flushing Log Files to Disk
Properties of Cached Files
WRITETHRU Files
Properties of WRITETHRU Files
When to Use WRITETHRU Files
The Impact of Other Technologies
Uninterruptible Power Supplies
Solid State Drives
The Big Red Button
Replication
Configuration Considerations
Caching Best Practices
Considerations When Planning Your Application
File-Related Limits
File ID Overflow
Pending File ID Overflow
Understanding the Warning Message
Determining the Current File ID
Recommended Actions
Serial Number Segments
Transaction High-Water Marks
Transaction Log Numbering
FairCom DB SQL Constraints
c-treeRTG Constraints
FairCom DB Server Installation
License Authorization File
CPU Counting
CPUs and Threads
Virtualization
Performance
Counting CPUs & Threads
AIX
Linux
Solaris
Mac OS X
Windows
Activation of Servers Prior to V10.0
Installing on Your Operating System
Platform Support
Java Version
FairCom DB Server for Windows
Operational Environment
Minimum Hardware Requirements for FairCom DB V11.* for Windows
Minimum Software Requirements for FairCom DB V11.* for Windows
Using Java 1.7 or Later on Windows
.NET Framework Requirements for FairCom DB GUI tools
.NET Tools for VS2010 - All projects updated to use .NET Framework v4.0
.NET - Removed STRONGSIGN from assemblies
ADO.NET Entity Framework
FairCom DB Server for Windows Installation
Installing as a Windows Service
Configuring the FairCom DB Service
Starting the FairCom DB Service
Displaying the current status of the FairCom DB Service
Stopping the FairCom DB Service
Removing the FairCom DB Service
Service Troubleshooting Tips
Problems starting the FairCom DB Service
Problems connecting to the FairCom DB Service
Problems stopping the FairCom DB Service
Tool Tray Interface
FairCom DB Server for Mac
Operational Environment
Minimum Hardware Requirements for Macintosh
Mac Server Installation
Configuring Mac Systems
FairCom DB Unix & Linux Servers
Supported Platforms
Unix Server Platform Hardware Requirements
Minimum Hardware Requirements
Hewlett Packard HP-UX
IBM AIX
Linux
Solaris - SPARC and Intel
Native Threads
FairCom DB Server Unix Installation
Configuring Unix-based Systems
Shared Memory Client-Server Communication for Unix/Linux
Message logged when shared memory fails to create semaphore or segment
Other Possible Shared Memory Messages
Unix Shared Memory Protocol Not Freeing Shared Memory Segments (different client and server user accounts)
Specify Shared Memory Keys on Unix
Use of Domain Sockets for Faster Unix/Linux Shared Memory Connections
System Group Assignment of Unix/Linux Shared Memory resources
Solaris Considerations
Multiple FairCom DB Servers on One Machine
TCP/IP Broadcast Support
Heterogeneous Server Network Support
FairCom DB Server Basic Operations
Starting FairCom DB the First Time
Starting FairCom DB
Start Up Errors
Errors Ignored When IP Address Return for Host System Fails
Launching FairCom DB Server companion executable
Stopping the FairCom DB Server
Launching Server Companion upon Shutdown
Server Operational Errors
Windows Resource Error (1450) Configurable Retry Logic
I/O Block Sizes with Windows Systems
Communications Errors (127/128)
8770
Server Memory Calculations
Stack Traces in Case of Critical Error
FairCom DB Access Configuration
Users, Files, Groups, and File Permission Masks
Users
User ID and Membership in Groups
User ID and Ownership of Files
User ID and Logon Limits
Files
Groups
Two Kinds of Groups
File Permission Masks
Informing Users of their Security Options
Advanced Data Encryption
Enabling Advanced Encryption Support
Encrypting Files Using Advanced Encryption
Changing the Master Password
Security
Transport Layer Security Secures Data in Transit between Network FairCom DB Clients and Servers
Testing with Default FairCom DB Certificates
ADO.NET Support for TLS
ODBC Support for SSL
JDBC Support for TLS
Allow ISAM Client to Use SSL without Client Having Server Certificate
OpenSSL Headers for Linking FairCom DB Client Applications
OpenSSL Now Provides Default Faster AES Encryption
OpenSSL Support is Now Extended to Linux Platforms
TLS/SSL Tutorials
User's Control of Security Options
The User's Password
Automatically Enforce Password Strength
Password Security Options (Commented Out) in Default Server Configuration File
Support for setting an expiration date for a password on a user account
File Security Controls
Master Encryption Key Management
Command-Line Administration Utilities
ctadmn - Server Administrator Utility
User Operations
Group Definitions
File Security
Monitor Clients
Server Information
Server Configuration
Stop Server
Quiesce Server
Monitor Server Activity
Change Server Settings
ctadmn user listing for rtexecute thread running report launched by RTSCRIPT
ctstop - Server Stop Utility
ctstat - Statistics Utility
Admin-System Report -vas
Tivoli-System Report -vts
Admin-File Report -vaf
Tivoli-File Report -vtf
Admin-User Report -vau
Function Timing Report -func
Text Report -text
I/O Time Statistics -iotime
I/O Statistics per File -file
Connection Information -userinfo and -userinfox
ISAM Statistics -isam
Enable Function Call Times by File -wrktime
Function Call Times by File -funcfile
Memory File Usage -m
Transaction Statistics -vat
File and User Lock -filelocks
List files on Internal Server Lists
Memory Use and Allocation Call Stacks -ml -mt
Memory Allocation (Windows) -mf -ma -mr -ms
sa_admin - Command-line security administration utility
Administrator Options
User Options
Group Options
File Options
ctpass - Password Utility
ctquiet - Quiesce FairCom DB Utility
ctfilblkif - File Block Utility
ctdump - Schedule Backup Utility
ctrdmp - Backup Restore or System Rollback
Rollback to New Restore Points with ctrdmp
ctrdmp options to convert path separators to operating system's native path separator
ctfdmp - Forward Roll Utility
Master Password Verification Options
Advanced encryption master key store encrypted at system level on Windows
ctencrypt - Utility to Change Master Password
ctvfyidx - Index Verify Utility
ctvfyidx - Prior to V10.3.1
ctvfyfil - File Verify Utility
Backups and Data Integrity
FairCom DB Server Files
Copying FairCom DB Server Controlled Files
Server Unique File Detection - NetWork/Remote/UNC file names
Automatic Recovery
Recovery in Alternate Locations with REDIRECT
Options for Faster Auto-Recovery
Hot Backup ("Dynamic Dump")
Scheduling a Dynamic Dump
ctdump - Schedule Backup Utility
dyndmp API Options
Dynamic Dump Options
Dynamic Dump Script File
!BLOCK_RETURN
!COMMENT
!COPY_NONCTREE
!DATE <mm/dd/yyyy>
!DAY <day of week>
!DELAY <seconds>
!DIAGNOSTICS TRAN_RECOVERY
!DUMP <dump file>
!END
!ENDSEGMENT
!EXT_SIZE <bytes | NO>
!FILES
Wildcard Support for File Names
Wildcards Exclude and Include Files in Backups
Files NOT to Include in Your Dynamic Dump Backup
!FREQ <hours>
!IMMEDIATE_RESTORE
!IMMEDIATE_RESTORE_LOGFILE
!IMMEDIATE_RESTORE_WITH_PROGRESS
!NONCTREEFILES
!PROTECT and !PROTECT_LOW
!RECOVER_DETAILS
!RECOVER_MEMLOG
!RECURSE <YES | NO | MATCH_SUBDIR>
!SEGMENT
!REPLICATE
!TIME <hh:mm:ss>
Dynamic Dump callback event notifications during immediate restore
Dynamic Dump status and error messages
Dynamic Dump now stops when client callback function returns an error
FairCom DB Files to Include in a Dynamic Dump
Dynamic Dump Defer to Improve Overall I/O Performance
Dynamic Dump Defer Interval for Improved Backup Performance
Non-ctree Files Included in a Dynamic Dump
Dump Files Without Transaction Control
Automatic Restore of a Dynamic Dump for Files That Are Ready-to-Use
Dump To Multiple Files - No Size Limit
Segmented Dynamic Dump
Mirrored File Backups
Dump Progress Messages Displayed in Function Monitor
Mask Routine Dynamic Dump Messages in CTSTATUS.FCS
Killing a Dynamic Dump
Hot Backup ("Dynamic Dump") Recovery
Running the Recovery Utility
ctrdmp - Backup Restore or System Rollback
Recovery Script Options
!CLNIDXX
!CONVERT_PATHSEP
!DELETE
!#FCB <number of files>
!FORWARD_ROLL
!PAGE_SIZE <bytes per buffer>
!REDIRECT <old path> <new path>
!REDIRECT_IFIL
!SKIP
Define Alternative Restore Destinations
Transaction Dependent Files
System Rollback
Running the Rollback Utility
Script File for Rollback
!COMMENT
!DATE <mm/dd/yyyy> (rollback)
!#FCB <number of files>
!FILES
!ROLLBACK
!SKIP
!TIME <hh:mm:ss> (rollback)
Rolling Forward from Backup
Forward Roll File Redirection
Transaction Log Dump
Options for Transaction Log Dump
Running a Transaction Log Dump
ctldmp option to create transaction start files from checkpoints in transaction log files
Controls for Performance AND Safety of Non-Transaction Updates
Checkpoint Requirements
Hot Backups Stream to STDOUT
Volume Shadow Service (VSS) Support
VSS Configuration
VSS Diagnostic Logging
Dynamic API Interaction
Monitoring FairCom DB
Performance Monitoring Using the ctstat Utility
Performance Monitoring Using Server Keywords
Automatically Logging Performance Snapshots
Automatic Logging to the Server System Event Log
Automatic Logging to SNAPSHOT.FCS
Performance Monitoring Using the SnapShot API
FairCom DB Server Status Monitoring Utility, ctsysm
Using the ctsysm Utility
ctsysm Configuration File
ctsysm Configuration File Sample
Server System Event Log Keywords
Performance Optimization
Options for Advanced Applications
I/O caching
Fastest Platform
Communication Protocol
Flexible I/O Channel Usage
Transaction Control Options
Transaction Options
Transaction Commit Delay
Commit Delay Operational Details
Enabling Transaction Commit Delay
Reduced Flushing of Updated Cache Pages
Transaction Flushing
Checkpoint Flushing
Improved Log Flush Strategy
Checkpoint Efficiency
Increasing the Interval Between Checkpoints
Transaction Log Templates
Log Template Configuration
Efficient Transaction Log Template Copies
Efficient Flushing of Transaction Controlled Files
Extended Transaction Number Support
Extended Transaction Number Support
Configurable Extended Transaction Number Options
Configurable Transaction Number Overflow Warning Limit
Efficient Single Savepoint for Large Transactions
Deferred Flush of Transaction Begin
Detection of Transaction Log Incompatibilities
Millions of Records per Transaction
Configuring FairCom DB
FairCom DB Configuration File
Configuration Flexibility with Environment Variables
FairCom DB Standard Wildcards
Scaling Factors for Configuration Keyword Values
Alternative Configuration Methods
FairCom DB Configuration Options
SUBSYSTEM
Basic Keywords
COMMENTS
COMM_PROTOCOL
Shared Memory Resource Considerations
Shared Memory Protocol Change
Shared Memory Performance Enhancement for all Unix Platforms
CONNECTIONS or USERS
CPU_AFFINITY
DAT_MEMORY
DUMP
FILES
Improved File Descriptor Limit Messages Logged During Server Startup
Server Now Fails to Start if File Descriptor Limit Can't be Increased to Required Value
Message Written to Standard Output When File Descriptor Limit is too Low
New file descriptor limit compatibility keyword
GUEST_LOGON
IDX_MEMORY
LOCAL_CONNECTION_ONLY
LOCAL_DIRECTORY
MAX_DAT_KEY
MAX_KEY_SEG
PAGE_SIZE
SERVER_NAME
SERVER_PORT
Client Communication Keywords
DEAD_CLIENT_INTERVAL
MAX_CONCURRENT_USER_ACCOUNTS
MAX_CONNECTIONS_PER_USER_ACCOUNT
MAX_ISAM_CONNECTIONS
MAX_SQL_CONNECTIONS
TCP/IP
BROADCAST_DATA
BROADCAST_INTERVAL
BROADCAST_PORT
SESSION_TIMEOUT
Shared Memory
SEMAPHORE_BLK
SHMEM_DIRECTORY
SHMEM_GROUP
SHMEM_PERMISSIONS
LDAP
ADMIN_USER_GROUP
GUEST_USER_GROUP
LOGIN_ALLOWED_GROUP
LDAP_SERVER
LDAP_PORT
LDAP_TIMEOUT
LDAP_SSL
LDAP_PREFIX
LDAP_BASE
LDAP_APPLICATION_ID
LDAP_KEY_STORE
LDAP_ISAM_ALLOWED_GROUP & LDAP_SQL_ALLOWED_GROUP
LDAP_GROUP_CHECK
LDAP_LOCAL_PREFIX
DIAGNOSTICS TRAP_COMM
SESSION_TIMEOUT
Startup and Shutdown Keywords
APP_NAME_LIST
CACHE_LINE
CHECK_CONFIG
COMPATIBILITY NO_EXTERNAL_SHUTDOWN
CONSOLE CTRL_C_ENABLE
CONSOLE NO_MESSAGEBOX
CONSOLE NO_PWRDWNPASSWORD
CONSOLE NO_SHUTDOWN_PROMPT
CONSOLE TOOL_TRAY
CONSOLE W9X_SERVICE
CTSRVR_CFG
DNODEQ_SHUTDOWN_LIMIT
NO_SHUTDOWN_FLUSH
PLUGIN_CALLBACK
PROCESS_PRIORITY
PROCESS_EXIT_COMMAND
SIGNAL_DOWN
SIGNAL_READY
STACK_DUMP
USER_SIGNAL_DOWN
USER_SIGNAL_READY
WAIT_ON_SHUTDOWN_SEC
DIAGNOSTICS SHUTDOWN_COMM
Cache and Memory Keywords
*_FLUSH_SEC background flush rate reduces contention
BUFBLK_RATIO
BUFFER_RUNLENGTH
BUFR_MEMORY
CACHE_STAT_ARRAY_SIZE
COMPATIBILITY LARGE_CACHE
COMPATIBILITY MINIMUM_INDEX_BUFFERS
DAT_MEMORY
DATA_LRU_LISTS
GUEST_MEMORY
IDX_MEMORY
INDEX_LRU_LISTS
LIST_MEMORY
LMT_MEMORY
MEMORY_HASH
MPAGE_CACHE
NO_CACHE
NONTRAN_FILESYS_FLUSH_OFF
PRIME_CACHE
PRIME_INDEX
PRIME_CACHE_BY_KEY
SORT_MEMORY
SPECIAL_CACHE_FILE
SPECIAL_CACHE_PERCENT
TOT_MEMORY
USR_MEM_RULE
USR_MEMORY
Transaction Processing Keywords
AUTO_PREIMG
AUTO_TRNLOG
AUTO_TRNLOG_LIGHT
AUTOTRAN_ON_CREATE
CHECKPOINT_FLUSH
CHECKPOINT_IDLE
CHECKPOINT_INTERVAL
CHECKPOINT_PREVIOUS
CHKPDFC_LOG_LIMIT
CLEANUP_ABLIST_ON_ABORT
COMMIT_DELAY
COMMIT_DELAY_BASE
COMMIT_DELAY_MINIMUM
COMMIT_DELAY_SCALE
COMMIT_DELAY_USEC
COMMIT_LOCK_DEFER_MS
COMPATIBILITY LOG_WRITETHRU
COMPATIBILITY TDATA_WRITETHRU
COMPATIBILITY TINDEX_WRITETHRU
COMPATIBILITY LOCK_EXCL_TRAN
DELAYED_DURABILITY
DELSTK_COMMIT_SEC
FIXED_LOG_SIZE
FORCE_LOGIDX
KEEP_LOGS
KEEP_RESTORE_POINTS
LEAF_NODE_READ_LOCK
LOG_COMPRESSION_FACTOR
LOG_COMPRESSION_THRESHOLD
LOG_EVEN
LOG_ODD
LOG_PAGE_SIZE
LOG_SPACE
LOG_TEMPLATE
LOG_TEMPLATE_COPY_SLEEP_PCT
LOG_TEMPLATE_COPY_SLEEP_TIME
LONG_TRANSACTION_MS
MAX_DFRIDX_LOGS
Transaction log limit for replication and deferred indexing
MAX_PREIMAGE_DATA
MAX_PREIMAGE_SWAP
MAX_REPL_LOGS
MAX_USER_LOG_ENTRY_BYTES
MAX_USER_LOGS
PREIMAGE_FILE
START_EVEN
START_ODD
SUPPRESS_LOG_FLUSH
SUPPRESS_LOG_SYNC
TRAN_HIGH_MARK
TRAN_OVERFLOW_THRESHOLD
TRAN_TIMEOUT
TRANSACTION_FLUSH
UNBUFFERED_LOG_IO
Recovery Keywords
RECOVER_DETAILS
RECOVER_FILES
RECOVER_MEMLOG
RECOVER_TO_RESTORE_POINT
RECOVER_SKIPCLEAN
REDIRECT
REDIRECT_IFIL
SKIP_INACCESSIBLE_FILES
SKIP_MISSING_FILES
TRANIDX_LOPN_ERR_CONTINUE
File Management Keywords
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_LIST
LEAF_NODE_READ_LOCK
MATCHING_SEGMENT
MAX_FILES_PER_USER
Maximum Index Members per File (MAXMEMB)
MAX_REBUILD_QUEUE
MAX_VIRTUAL_FILES
MEMFILE_MAX_BINS
MEMORY_FILE
NONMATCHING_SEGMENT
SPLIT_NBR_OF_FILES
TMPNAME_PATH
DIAGNOSTICS PTADMIN
Lock Keywords
AUTO_LOCK_RETRY
AUTO_LOCK_RETRY_SLEEP
BLOCKING_LOCK_TIMEOUT_SEC
CHECKLOCK_FILE
COMPATIBILITY LKISAM_MODES
ITIM_RETRY_DEFER
ITIM_RETRY_LIMIT
DIAGNOSTICS DLOK_ERR
DIAGNOSTICS LOCK_DUMP
I/O Keywords
COMPATIBILITY DIRECT_IO
COMPATIBILITY FDATASYNC
COMPATIBILITY FORCE_WRITETHRU
COMPATIBILITY PREV610A_FLUSH
COMPATIBILITY WTHRU_UPDFLG
DEFAULT_CHANNELS
IDLE_NONTRANFLUSH and IDLE_TRANFLUSH
IO_BLOCK_SIZE
IO_ERROR_BLOCK_RETRY
IO_ERROR_BLOCK_SIZE
IO_ERROR_BLOCK_SLEEP
NONTRAN_DATA_FLUSH_SEC
NONTRAN_INDEX_FLUSH_SEC
OPEN_FILES_ALERT_THRESHOLD
OPTIMIZE_FILE_OPEN
OPTIMIZE_FILE_CLOSE
PENDING_FILE_OPEN_RETRY_LIMIT
SET_FILE_CHANNELS
SYSTEM_FILE_ID_LIST
DIAGNOSTICS SYSTEM_FILE_ID_LIST
TRAN_DATA_FLUSH_SEC
TRAN_INDEX_FLUSH_SEC
UNBUFFERED_IO
DIAGNOSTICS DIRECT_IO
DIAGNOSTICS LOWL_FILE_IO
Logging and Monitoring Keywords
CHECKPOINT_MONITOR
CTSTATUS_MASK
CTSTATUS_SIZE
DBENGINE_CHECK
DEADLOCK_MONITOR
DISK_FULL_ACTION (Original)
DISK_FULL_ACTION (SUBSYSTEM)
DISK_FULL_LIMIT
DISK_FULL_VOLUME
FUNCTION_MONITOR
HEAP_DEBUG_LEVEL
LOCK_MONITOR
MEMORY_MONITOR
MEMORY_TRACK
MONITOR_MASK
PERF_MONITOR
REQUEST_TIME_MONITOR
SNAPSHOT_FILENAME
SNAPSHOT_INTERVAL
SNAPSHOT_LOCKWAIT_USEC
SNAPSHOT_TRANTIME_USEC
SNAPSHOT_USERID
SYSLOG
SYSVIEW_WHAT
SYSVIEW_WHEN
DIAGNOSTICS SNAPSHOT_AUTOMATIC
DIAGNOSTICS SNAPSHOT_IOTIME
DIAGNOSTICS SNAPSHOT_SHUTDOWN
DIAGNOSTICS SNAPSHOT_WORKTIME
Security Keywords
ADMIN_ENCRYPT
ADVANCED_ENCRYPTION
ALLOW_MASTER_KEY_CHANGE
CHANGE_ENCRYPTION_ON_COMPACT
COMPATIBILITY NO_COMMAND_LINE
COMPATIBILITY NO_CONFIG_FILE
COMPATIBILITY NONADMIN_FILBLK
COMPATIBILITY NONADMIN_QUIET
COMPATIBILITY NONADMIN_TRANSFER_FILE
COMPATIBILITY NON_ADMIN_SHUTDOWN
ENABLE_TRANSFER_FILE_API
FILEDEF_SECURITY_LEVEL
LOG_ENCRYPT
LOGON_FAIL_LIMIT
LOGON_FAIL_TIME
LOGON_MUST_TIME
MASTER_KEY_FILE
MASTER_KEY_LIB
NULL_STRING
OPENSSL_ENCRYPTION
READONLY_SERVER
STARTUP_BLOCK_LOGONS
COMPATIBILITY SQLIMPORT_ADMIN_PASSWORD
Backup Keywords
DYNAMIC_DUMP_DEFER
DYNAMIC_DUMP_DEFER_INTERVAL
DYNAMIC_DUMP_SYNC_INTERVAL
PERMIT_NONTRAN_DUMP
PREIMAGE_DUMP
VSS_WRITER
VSS_WRITER_QUIESCE_TIMEOUT
DIAGNOSTICS DYNDUMP_LOG
DIAGNOSTICS VSS_WRITER
Replication Keywords
Auto-Numbering Replication Defaults Changed
MAX_REPL_LOGS
REPLICATE
REPL_IDENTITY_USE_MASTER
REPL_IDENTITY_USE_SOURCE
REPL_MAPPINGS
REPL_NODEID
REPL_READ_BUFFER_SIZE
REPL_SRLSEG_ALLOW_UNQKEY
REPL_SRLSEG_USE_MASTER
REPL_SRLSEG_USE_SOURCE
DIAGNOSTICS REPLICATE
Unicode Keywords
ICU_LOCALE
ICU_OPTION
LANGUAGE
UNCSEG_KEYCOMPRESS
XTDKSEG_SEG_TYPE
XTDKSEG_SRC_TYPE
XTDKSEG_SRC_SIZE
XTDKSEG_FAILED_DEFAULT_OK
Mirroring Keywords
ADMIN_MIRROR
LOG_EVEN_MIRROR
LOG_ODD_MIRROR
MIRROR_DIRECTORY
MIRRORS
SKIP_MISSING_LOG_MIRRORS
SKIP_MISSING_MIRRORS
START_EVEN_MIRROR
START_ODD_MIRROR
Backward Compatibility Keywords
COMPATIBILITY 6BTRAN_NOT_DEFAULT
COMPATIBILITY ABORT_ON_CLOSE
COMPATIBILITY BATCH_SIGNAL
COMPATIBILITY BATCH_UTRFMKEY
COMPATIBILITY BLOCK_DDSFM_CREATE and BLOCK_DDSFM_DELETE
COMPATIBILITY CHAR_SCHSEG
COMPATIBILITY CHECKPOINT_OVERLAP
COMPATIBILITY CHKPNT_FLUSHALL
COMPATIBILITY CHKPNT_MUTEX_REL
COMPATIBILITY CLSFIL_ISAM
COMPATIBILITY CLSFIL_UNBLOCK
COMPATIBILITY COMMPORT5000
COMPATIBILITY COPY_FILE_OPEN_SHARED
COMPATIBILITY CTREE_RWLOCK
COMPATIBILITY DIR_BUF_RQS
COMPATIBILITY DUPL_ERR_FATAL
COMPATIBILITY ENCRYPT128
COMPATIBILITY ESTIMATE_SCALE
COMPATIBILITY EXACT_FILE_NAMES
COMPATIBILITY EXTENDED_TRAN_ONLY
COMPATIBILITY FAILED_TRAN_IO
COMPATIBILITY FILE_CREATE_CHECKPOINT
COMPATIBILITY FILE_DESCRIPTOR_LIMIT
COMPATIBILITY FILELIST_GROWTH
COMPATIBILITY KEEP_EMPTY_NODE_ON_READ delete queue when read from disk
COMPATIBILITY LFL_WAIT
COMPATIBILITY LFW_ADAPTIVE
COMPATIBILITY LOCK_CACHE
COMPATIBILITY LOCK_HEADER
COMPATIBILITY LOG_ENCRYPT128
COMPATIBILITY PUTHDR_COMMIT
COMPATIBILITY MEMORY_FILE_SKIP_FREE
COMPATIBILITY MEMORY_LIMITS
COMPATIBILITY MINIMUM_INDEX_BUFFERS
COMPATIBILITY MULTI_PROCESSOR
COMPATIBILITY MULTIOPN_*
COMPATIBILITY NLM_DEFER_THREADSWITCH
COMPATIBILITY NLM_LONG_FILE_NAMES
COMPATIBILITY NO_ADREXP_CHECK
COMPATIBILITY NO_ATODEP
COMPATIBILITY NO_AUTO_SKIP
COMPATIBILITY NO_BAT_FXDCMP
COMPATIBILITY NO_BLOCK_KILL
COMPATIBILITY NO_CHECKFIX
COMPATIBILITY NO_CHKMBRNAMLEN
COMPATIBILITY NO_CLSTRAN_OPEN
COMPATIBILITY NO_COMMIT_READ_LOCK
COMPATIBILITY NO_CONFIG_PERSISTENCE
COMPATIBILITY NO_DATAMAP_CHECK
COMPATIBILITY NO_DELNOD_QUEUE
COMPATIBILITY NO_FIXED_OFFSET_CHECK
COMPATIBILITY NO_FLUSH_DIR
COMPATIBILITY NO_IDFIELD_OVERFLOW_CONVERSION
COMPATIBILITY NO_IDFIELD_OVERFLOW_DETECTION
COMPATIBILITY NO_IDXBUFBLK
COMPATIBILITY NO_INIT_VSPACE
COMPATIBILITY NO_KEEP_OUT_TRNSEQ
COMPATIBILITY NO_MYMARKS
COMPATIBILITY NO_NXTMARKS
COMPATIBILITY NO_RCVHDRUPD_NUMENT
COMPATIBILITY NO_RELBUF_CHECK
COMPATIBILITY NO_REPL_DEFER_TRAN
COMPATIBILITY NO_SHUTDOWN_DELAY
COMPATIBILITY NO_SIGNAL_HANDLER
COMPATIBILITY NO_SMART_SAVE
COMPATIBILITY NO_SPCMGT_QUEUE
COMPATIBILITY NO_SYS_FLUSH_ON_CLOSE
COMPATIBILITY NO_TEST_LOCAL
COMPATIBILITY NO_TRAN_DISCONNECT
COMPATIBILITY NO_TRANDEP_SCAN
COMPATIBILITY NO_UNIQFILE
COMPATIBILITY NO_UPDMARKS
COMPATIBILITY NO_VAR_PEOF
COMPATIBILITY NO_VARLEN_TRAN_UNUSED
COMPATIBILITY NO_VFLG_ERR
COMPATIBILITY NONE
COMPATIBILITY OPEN_SHARE_RW
COMPATIBILITY OPEN_RANDOM_ACCESS
COMPATIBILITY PUTHDR_COMMIT
COMPATIBILITY RANGE_NO_NXTKEY
COMPATIBILITY REPLICATION_TRAN_LIST
COMPATIBILITY REVERT_TO_V6HDR
COMPATIBILITY REWRITE_KEY_ERROR
COMPATIBILITY SETEXCABT
COMPATIBILITY SPCMGT_INDEX
COMPATIBILITY SQLIMPORT_ADMIN_PASSWORD
COMPATIBILITY STREAM_FILES
COMPATIBILITY SYNC_LOG
COMPATIBILITY TCPIP_CHECK_DEAD_CLIENTS
COMPATIBILITY TEMP_INDEX_ERROR
Temporary Index RVHD_ERR (123)
COMPATIBILITY TERMINATE_ON_SIGNAL
COMPATIBILITY USE_CHARUPPER
COMPATIBILITY V24LOGON
COMPATIBILITY VDLFLG
Advanced Configuration Keywords
CONTEXT_HASH
CRITICAL_SECTION_SPIN
DH_THREAD_STACK_SZ_KB
DIST_COUNT_SEC
LATCH_SLEEP
LATCH_SPIN
LOCK_HASH
LOCK_HASH_MAX
LOCK_HASH_LOADFAC
LOCK_HASH_REHASHFAC
MAX_FILE_WAIT_SECS
MAX_HANDLES
MAX_K_TO_USE
MAX_SQL_ISOLATION_LEVEL
MAX_STORE
NODE_DELAY
NODEQ_SEARCH
PARTITION_ESTIMATE_LIMIT
PREIMAGE_HASH
PREIMAGE_HASH_REHASHFAC
PRESYNC_THRESHOLD
SERVER_DIRECTORY
SESSCHG_ENABLE
SETENV
SETENV DH_DO_AHEAD
SKIP_CTADDWORK
SQL_OPTION DEL_MRT_HOST
SUBSYSTEM SQL LATTE
SYNC_DELAY
TASKER_SLEEP
UDEFER_64YIELD_USEC
UDEFER_THRESHOLD_USEC
VLEN_ERR_RETRY_LIMIT
Diagnostics Keywords
DIAGNOSTIC_INT
DIAGNOSTIC_STR
DIAGNOSTICS ABEND_ABORT
DIAGNOSTICS ABORT_NODE_LIST
DIAGNOSTICS AUTO_PREIMG_CHECKLOCK / AUTO_PREIMG_CHECKREAD
DIAGNOSTICS AUTO_TRNLOG_CHECKLOCK / AUTO_TRNLOG_CHECKREAD
DIAGNOSTICS CHECK_KEY_MARKS
DIAGNOSTICS CHECK_UDEFER
DIAGNOSTICS COMM_LEVEL_X
DIAGNOSTICS DADV_ERR
DIAGNOSTICS DBGSEMTIM
DIAGNOSTICS DEBUG
DIAGNOSTICS EXTENDED_TRAN_NO
DIAGNOSTICS FALG_ERR
DIAGNOSTICS FILE_CLOSE_FLUSH
DIAGNOSTICS FILE_LOGON
DIAGNOSTICS FLUSH_BLM
DIAGNOSTICS FORCEI_SHADOWUPD
DIAGNOSTICS FULL_DUMP
DIAGNOSTICS KEY_COMPARE
DIAGNOSTICS KLLX
DIAGNOSTICS L59
DIAGNOSTICS LDAP
DIAGNOSTICS LOCK_LOGON
DIAGNOSTICS LOGON_COMM
DIAGNOSTICS LOWL_CRC_ON
DIAGNOSTICS MEMORY_LEAK
DIAGNOSTICS MEMTRACK
DIAGNOSTICS NO_EXCEPTION_HANDLER
DIAGNOSTICS NO_LOG_EXTENSION
DIAGNOSTICS NODE_REQUEST_TIME
DIAGNOSTICS NODEQ_MESSAGE
DIAGNOSTICS NONE
DIAGNOSTICS PCRP_ERR
DIAGNOSTICS POPN_ERR
DIAGNOSTICS PROCESS_EXIT
DIAGNOSTICS QUEUE_LOGON
DIAGNOSTICS READ_ERR
DIAGNOSTICS REMAINING_THREADS
DIAGNOSTICS REPL_READ_BUFFER
DIAGNOSTICS SUBALLOCATOR_OFF
DIAGNOSTICS THREAD_DUMP
DIAGNOSTICS TR_TRAN_ERR
DIAGNOSTICS TRACK_LOGON
DIAGNOSTICS TRAN_RECOVERY
DIAGNOSTICS TREE_WALK
DIAGNOSTICS UNOD_ERR
DIAGNOSTICS UPDFLG
DIAGNOSTICS WRITE_ERR_DUMP
DIAGNOSTICS WRITETHRU
Custom Server SDK Keywords
JOB_QUEUE_INFO
DIAGNOSTICS CTUSER_ERROR
DIAGNOSTICS CTUSER_VERBOSE
DIAGNOSTICS CUSTOM
Glossary
FairCom Typographical Conventions
Copyright Notice
Index