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