c-treeRTG V3 Update Guide

Introduction New c-treeRTG Features Expect Faster Application Throughput from Automatic Transaction Optimization Improved Delete Record Performance Find Stuff Faster with Full-Text Search ROWID Record Header Required for Full Text Search Open up to One Million Concurrent Files in c-treeRTG Faster Bulk Additions Speed Data Loads Faster Bulk Addition Index Rebuild from Cached Data Faster OPEN OUTPUT File Reuse Improved Detection of Logically Equivalent Filenames during Automatic Recovery Standalone Operational Model Support <localinstance> More APIs, SDKs, and Drivers for Extended Development Options Go Bigger Millions of Records per Transaction Millions of Open Files 128 TB SQL Temp Tables 4GB Transaction Log Space 64K SQL CHAR Fields 2500 Columns per Table Go Faster - By Simply Upgrading Your Server Up to 3x Faster Overall Performance Up to 4X Faster Indexes with Smaller Indexes Using Variable-Length Compressed Key Storage ISAM API Compression Key Compression with c-treeRTG Utilities to Confirm Index Compression Modes Faster Indexing from Locking, Node Pruning, and Sorting Optimizations Up to 15 Percent Faster with Increased Default Index Page Size Faster File Open and Close under High Concurrency Faster Return for Files Not Found on Open Improved Performance Reassigning Transaction-Controlled File's ID Windows File System Compression Support Faster Connections and App Communication More Concurrency with Less Lock Contention OpenSSL Now Provides Default Faster AES Encryption SQL Run a SQL Query across Multiple Databases Parameter Marks Now Available in Scalar Functions and CASE Statements Assign Values to Auto-Increment Fields in INSERT Insert Multiple Value Sets Insert Statements with Scalar Values and Subqueries Now Supported Use Row Value Constructors with Comparisons in Query Easier Full-Text Search (FTS) MATCH Operator Syntax Diagnostic Logging Now in Enhanced JSON Format Extensive SQL Statement Logging for Auditing SYSLOG SQL_STATEMENTS Configuration Keyword LVARCHAR Fields Allowed in Stored Procedure Code Throw Custom Error Message on Stored Procedure or UDF Exception Dynamically Disable Triggers Dynamically "SQLize" ISAM and COBOL Files Backup and Restore Back Up Direct to STDOUT and Gain OS Compression and Encryption Support (ctdump) Restore Backups Direct from STDIN (ctrdmp) Wildcards Exclude and Include Files in Backups Dynamic Dump Script !DELAY Option Allows Abandoning Dump Faster Restores from Large Backups Data Replication Replication High Availability Configuration New ctsrvr.cfg Location and Default Additions c-treeRTG TLS (SSL) for Encrypted Network Communications Support <instance endiancheck> Keyword to Relax Server's Endianness Check <instance ctshmemdir> to Set Shared Memory Directory under Unix <redirinstance> Support to Fallback to Default File System <forcedelete> Configuration Option to Force Deletion of Orphan Files <rowid> and <rowid size> Attributes <filepool> Size and <inpool> Options <keycompress> Option to Create Files with Key Compression <scancache> Scanning Caching Strategy Option <memoryfile persist> Attribute to Specify if Memory File Is Removed at Disconnection <prefetch ttl> Attribute to Define How Long a Set of Prefetched Records Remains Valid <localinstance> <startonread> Option to Improve Performance of START and READ NEXT/PREVIOUS Operations New <log> <debug> Attributes New <log> <error> Attributes FairCom DB Configuration Options Core SQL COMPATIBILITY DIAGNOSTIC c-treeRTG Security Secure SSL Communication c-treeRTG Now Supports c-tree File Ownership Attributes c-treeRTG File Permissions Support cmdset Support Added to c-treeRTG OpenSSL Now Provides Default Faster AES Encryption Master Key Storage Integration with Amazon AWS Secrets Manager Support for Using AWS Secrets Manager as External Encryption key Store DLL for FairCom Server to Access AWS Secrets Manager Visual Prompt Utility for AWS Credentials Encrypted Data Master Key Library Automatically Enforce Password Strength SYSLOG Recording of SQL User Logon and Logoff Events Read-Only Server - Perfect for Reporting and Several HA (High Availability) and DR (Disaster Recovery) Scenarios Advanced SSL Certificate Options Perform LDAP_GROUP_CHECK in Context of LDAP Application ID if Specified LDAP Authentication Diagnostic Logging V12 Changes Goal: Zero Administration Automatically Alert on Low Disk Space Automatic Sizing and Purging of Log Files Track I/O Statistics per Connection File Operations Counters Debug Heap Options for Detection of Memory Corruption Utilities ctutil ctutil Changes ctutil -load Option '-n' to Empty Destination File Before Loading Records ctutil -tron Updated -sqlrefresh -test Obsolete Commands Removed Web-Based GUI Tools ctclosefile - Close Open Memory and ctKEEPOPEN files startserver and stopserver Scripts ctinfo is Now Included in c-treeRTG ctfixdupscan - Detect and Fix Files that Suffer from File Definition Errors ctcmpcif - IFIL-based Compact Utility Included ctfdump Utility Extended with !RECOVER_DETAILS Option for Progress Notifications ctldmp Utility Enhanced to Display File ID Values ctfileid - Assign a New Unique ID to a Data or Index File ctstat - Display Log Save Time Delta Values Data Replication Backup and Restore Data and Index File Management Caching Security Logging and Recovery SQL Import Diagnostic Session Recording Plug-ins and Callbacks Use Plug-ins and Run Anything Server-Side c-tree Server Can Load Plug-In On-Demand after Server Has Started Web Plug-In - Default linked_ace_server Callbacks for Custom Behaviors Upgrade Steps New c-treeRTG Footprint & Upgrade Ports V12 Changes Support Opening More Than 32,767 Files Affects Compatibility Compatibility Notes Server Configuration Defaults - PAGE_SIZE 32768 and LOG_SPACE 1 GB Max Key Segments Increased Max Replication and Deferred Index Logs Raised FairComConfig Utility Moved Increased Log Space Requirements Upgrade and New Default Folder Layout ctsrvr.cfg Moved to New config Folder <config> Attribute <config prev12filematch> for File Matching Rules Improved IFIL Path Handling Shared Memory Performance Enhancement for all Unix Platforms Deprecated FairCom DB Configurations Sort Module Error Code Changes SQL Stored Procedures - Close cursors that were left open Better Error Reporting when Exceeding the Maximum Length of VARCHAR Fields Disk Full Monitoring Keywords Added to Default ctsrvr.cfg SQL Statement Diagnostic Logging Keyword Added to Default Server Config Updated ctMAX_KEY_SEG Default from 16 to 32 MAX_REPL_LOGS and MAX_DFRIDX_LOGS Default Values Increased to 100 Windows Drive-Relative Paths Deprecated c-treeRTG - Migrating and SQLizing Data Millisecond Time Support Added Automatic sqlize Logic Allows an XFD and/or XDD to Be Specified Preserve Imported Data Files upon SQL DROP COBOL Date Baseline Can Be Set to Julian Starting Date of Dec 31, 1600 xddgen - New Configuration Option max-fixed-record-len xddgen - New Record Size Checks and Warnings New Standalone Support for ctmigra <localinstance> bufs, dbufs, sect Value Check c-treeRTG - Conversion Sample Updated New Platforms c-treeRTG - BTRV Edition c-treeRTG BTRV Edition Login/Logout Operation BTRV Extended Index Types Support for Exclusive Transactions in c-treeRTG BTRV Edition Support for BTRV Create Index Operation More FairCom Products FairCom Edge V3 FairCom Database Copyright Notice Index