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 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