 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 FairCom DB API
 User Defined Compression Dynamic Shared Library
 Tuning 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
 Data Caching Best Practices
 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
 Linux Caching Considerations
 Write Barriers
 Commit Delay and Disk Write Cache
 Settings for Best Performance
 Capacity Planning Considerations
 File-Related Limits
 File ID Overflow
 Pending File ID Overflow
 Understanding the "Pending File ID Overflow" Message
 Determining the Current File ID
 Recommended Actions
 Transaction Log Reset
 Serial Number Segments
 Transaction High-Water Marks
 Transaction Log Numbering
 FairCom DB SQL Constraints
 FairCom RTG Constraints
 FairCom 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 Server for Windows
 Operational Environment
 Minimum Hardware Requirements for FairCom DB V11 (and later) for Windows
 Minimum Software Requirements for FairCom DB V11 (and later) 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 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
 Windows 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 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 Server Installation on Linux, Unix, and Mac
 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
 Additional Troubleshooting
 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 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
 TLS/SSL Tutorials
 User's Control of Security Options
 The User's Password
 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
 ctsmon - Server Heartbeat Monitor
 Backups and Data Integrity
 FairCom Server Files
 Copying FairCom 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
 Database Backup Guide
 Scheduling a Database Backup
 ctdump - Schedule Backup Utility
 dyndmp and dyndumpsetopt
 Backup Script Options
 Backup Script File
 !BLOCK_RETURN
 !COMMENT
 !COPY_NONCTREE
 !DATE <mm/dd/yyyy>
 !DAY <day of week>
 !DELAY <seconds>
 !DUMP <dump file>
 !END
 !ENDSEGMENT
 !EXT_SIZE <bytes | NO>
 !FILES
 Wildcard Support for File Names
 Wildcards Exclude and Include Files in Backups
 FairCom DB Files to NOT Include in a Backup
 !FREQ <hours>
 !IMMEDIATE_RESTORE
 !IMMEDIATE_RESTORE_LOGFILE
 !IMMEDIATE_RESTORE_WITH_PROGRESS
 !NONCTREEFILES
 !PROTECT and !PROTECT_LOW
 !RECURSE <YES | NO | MATCH_SUBDIR>
 !SEGMENT
 Dynamic dump !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 for a Successful Backup Strategy
 Defer Backup I/O for Improved Performance
 Backup Defer Interval for Improved Performance
 Back Up Non-ctree Files
 Back Up Files Without Transaction Control
 Automatically Restore Backup for Ready-to-Use Files
 Backup as Multiple Extent Files
 Back Up as Segmented Files
 Mirrored File Backups
 Backup Progress Messages Displayed in Function Monitor
 Mask Routine Backup Messages in CTSTATUS.FCS
 Killing a Running Backup
 FairCom Database Restore Guide
 Running the Recovery Utility
 ctrdmp - Backup Restore or System Rollback
 Restore Script Options
 !CLNIDXX
 !CONVERT_PATHSEP
 !DELETE
 !DIAGNOSTICS TRAN_RECOVERY
 !#FCB <number of files>
 !FORWARD_ROLL
 !PAGE_SIZE <bytes per buffer>
 !RECOVER_DETAILS
 !RECOVER_MEMLOG
 !REDIRECT <old path> <new path>
 !REDIRECT_IFIL
 !SKIP
 Restore To Redirected Destination
 Restoring Transaction Dependent Files
 FairCom Database Rollback Guide
 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)
 FairCom Database Forward Roll Guide
 Forward Roll Path 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 Server Status Monitoring Utility, ctsysm
 Using the ctsysm Utility
 ctsysm Configuration File
 ctsysm Configuration File Sample
 Server System Event Log Keywords
 ctsmon - Server Heartbeat Monitor
 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 Configuration
 AUTO_TRANDEP
 COMMENTS
 COMM_PROTOCOL
 Shared Memory Resource Considerations
 Shared Memory Protocol Change
 Shared Memory Performance Enhancement for all Unix Platforms
 SUBSYSTEM COMM_PROTOCOL Keywords
 CONNECTIONS or USERS
 CPU_AFFINITY
 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
 LOCAL_CONNECTION_ONLY
 LOCAL_DIRECTORY
 MAX_DAT_KEY
 MAX_KEY_SEG
 PAGE_SIZE
 SERVER_NAME
 SERVER_PORT
 Client Communication
 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_MAX_SPIN
 SHMEM_PERMISSIONS
 LDAP
 ADMIN_USER_GROUP
 GUEST_USER_GROUP
 LDAP_APPLICATION_ID
 LDAP_BASE
 LDAP_GROUP_CHECK
 LDAP_ISAM_ALLOWED_GROUP & LDAP_SQL_ALLOWED_GROUP
 LDAP_KEY_STORE
 LDAP_LOCAL_PREFIX
 LDAP_MODULE
 LDAP_PORT
 LDAP_PREFIX
 LDAP_SERVER
 LDAP_SSL
 LDAP_TIMEOUT
 LOGIN_ALLOWED_GROUP
 TLS
 DIAGNOSTICS TRAP_COMM
 SESSION_TIMEOUT
 Startup and Shutdown
 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
 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
 *_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_CACHE_AT_STARTUP
 PRIME_INDEX
 PRIME_CACHE_BY_KEY
 SET_CACHE_OPTIONS
 SORT_MEMORY
 SPECIAL_CACHE_FILE
 SPECIAL_CACHE_PERCENT
 TOT_MEMORY
 USR_MEM_RULE
 USR_MEMORY
 Transaction Processing
 AUTO_PREIMG
 AUTO_RESTORE_POINT (SUBSYSTEM)
 AUTO_TRNLOG
 AUTO_TRNLOG_LIGHT
 AUTOTRAN_ON_CREATE
 CHECKPOINT_FLUSH
 CHECKPOINT_IDLE
 CHECKPOINT_INTERVAL
 CHECKPOINT_PREVIOUS
 CHECK_SYSTEM_FILEID
 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
 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
 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
 Maximum Index Members per File (MAXMEMB)
 MAX_REBUILD_QUEUE
 MAX_VIRTUAL_FILES
 MEMFILE_MAX_BINS
 MEMORY_FILE
 NONMATCHING_SEGMENT
 RECYCLE_BIN
 SPLIT_NBR_OF_FILES
 TMPNAME_PATH
 DIAGNOSTICS PTADMIN
 Locking
 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 Control
 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
 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
 MONITOR_MASK
 PERF_MONITOR
 REQUEST_TIME_MONITOR
 SNAPSHOT_FILENAME
 SNAPSHOT_INTERVAL
 SNAPSHOT_LOCKWAIT_USEC
 SNAPSHOT_LOGFLUSHTIME_USEC
 SNAPSHOT_TRANTIME_USEC
 SNAPSHOT_USERID
 SYSLOG
 SYSLOG SQL_STATEMENTS Configuration Keyword
 SYSVIEW_WHAT
 SYSVIEW_WHEN
 DIAGNOSTICS SNAPSHOT_AUTOMATIC
 DIAGNOSTICS SNAPSHOT_IOTIME
 DIAGNOSTICS SNAPSHOT_SHUTDOWN
 DIAGNOSTICS SNAPSHOT_WORKTIME
 Security
 Setting password requirements
 ADMIN_ENCRYPT
 ADVANCED_ENCRYPTION
 ALLOW_MASTER_KEY_CHANGE
 CHANGE_ENCRYPTION_ON_COMPACT
 COMPATIBILITY NO_COMMAND_LINE
 COMPATIBILITY NO_CONFIG_FILE
 COMPATIBILITY NON_ADMIN_SHUTDOWN
 COMPATIBILITY NONADMIN_FILBLK
 COMPATIBILITY NONADMIN_QUIET
 COMPATIBILITY NONADMIN_TRANSFER_FILE
 COMPATIBILITY SQLIMPORT_ADMIN_PASSWORD
 DEBUG_LOG
 FIPS_ENCRYPTION
 ENABLE_TRANSFER_FILE_API
 EXPIRE_IN_DAYS
 FILEDEF_SECURITY_LEVEL
 KEY_EXCHANGE_PARAMS
 LOG_ENCRYPT
 LOGON_FAIL_LIMIT
 LOGON_FAIL_TIME
 LOGON_MUST_TIME
 MASTER_KEY_FILE
 MASTER_KEY_LIB
 MINIMUM_LENGTH
 NULL_STRING
 OPENSSL_ENCRYPTION
 READONLY_SERVER
 REQUIRED_CLASSES
 SERVER_CERTIFICATE_FILE
 SERVER_ENCRYPTED_STORE_FILE
 SERVER_PRIVATE_KEY_FILE
 SSL_CIPHERS
 SSL_CONNECTIONS_ONLY
 STARTUP_BLOCK_LOGONS
 VERIFY_CLIENT_CERTIFICATE
 X509_AUTHENTICATION
 Database Backup
 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
 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
 ICU_LOCALE
 ICU_OPTION
 LANGUAGE
 UNCSEG_KEYCOMPRESS
 XTDKSEG_SEG_TYPE
 XTDKSEG_SRC_TYPE
 XTDKSEG_SRC_SIZE
 XTDKSEG_FAILED_DEFAULT_OK
 File Mirroring
 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
 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 DISABLE_BACKGROUND_CLEANUP
 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
 CONTEXT_HASH
 CRITICAL_SECTION_SPIN
 DH_THREAD_STACK_SZ_KB
 DIST_COUNT_SEC
 FLEXREC_OPTMIZE
 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
 QUIET_MAX_WAIT
 SERVER_DIRECTORY
 SESSCHG_ENABLE
 SETENV
 SETENV DH_DO_AHEAD
 SKIP_CTADDWORK
 SQL_OPTION AUTO_CHANGEID
 SQL_OPTION DEL_MRT_HOST
 SUBSYSTEM SQL LATTE
 SYNC_DELAY
 TASKER_SLEEP
 UDEFER_64YIELD_USEC
 UDEFER_THRESHOLD_USEC
 VLEN_ERR_RETRY_LIMIT
 Diagnostics
 CHECK_TRNLOG_BUFFER_WRITES
 DIAGNOSTIC_INT
 DIAGNOSTIC_STR
 DIAGNOSTICS LDAP
 DIAGNOSTICS ABEND_ABORT (Deprecated)
 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 CTQUIET
 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 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 TRNLOG_WRITE
 DIAGNOSTICS UNOD_ERR
 DIAGNOSTICS UPDFLG
 DIAGNOSTICS WRITE_ERR_DUMP
 DIAGNOSTICS WRITETHRU
 Custom Server SDK
 JOB_QUEUE_INFO
 DIAGNOSTICS CTUSER_ERROR
 DIAGNOSTICS CTUSER_VERBOSE
 DIAGNOSTICS CUSTOM
 Glossary
 FairCom Typographical Conventions
 Copyright Notice
 Index
|