2024 December FeatureLog

FairCom has increased data flexibility and efficiency by creating a new variant data type. You can now store any type of data in a variant column, including a string, number, date, time, Boolean, image, JSON, XML, or user-defined data type, along with metadata that tells your application precisely what you stored in the column as well as the format and encoding of the data value. The database can also automatically store a value with multiple encodings along with the metadata that tells your application how it is encoded so your application can decode it.

Developers and Administrators

D1510

The FairCom server provides a setting in the setsyncstate script that can be used to configure the method of notifying administrators when replication becomes asynchronous which puts the server at risk of losing data during failover. For details, see Linux Pacemaker

Developers Administrators

D1439

In the rare event of data corruption, quickly recover using our new tutorial for rebuilding indexes.

Developers and Administrators

D1131

Upgrading FairCom RTG tables to the new RTG 5 resource format allows nearly all FairCom DB features to be applied to RTG tables. These features include the JSON DB API, dbNotify, partitioned files, hot alter table, replication, two-phase commit support, and full-text search. All COBOL and BTRV data types are now available in all FairCom products.

Developers and Administrators.

D1492

You can now alter an existing FairCom RTG table by adding columns without requiring file migration. This makes rolling out new application updates faster, easier, and less resource-intensive.

Developers and Administrators

D1472

You can now create tables as (or convert them to) partitioned files in FairCom RTG. This makes deleting large blocks of data very fast and efficient.

Developers and Administrators.

D1547

RTG issues are now easier to diagnose since the Function Monitor (an RTG subsystem that logs API function calls sent to the server process) now shows the names of specific RTG functions.

Developers and Administrators.

Commands for RTG's command line tool (ctutil) have been added or enhanced to improve ease of use and to support new v5 features.

Developers, Administrators.

FairCom RTG is now compatible with new Btrieve operations that were not previously supported. We support the vast majority of applicable Btrieve functionalities.

Developers and Administrators.

D1550

You can now use new RTG substitution specifier "%o" to set applicable configuration options to return the server task ID of an affected instance. This can be helpful for troubleshooting or monitoring activity on a server.

Developers and Administrators.

You can now customize RTG log entries (specifically the portion that prints which client application logged the entry), allowing them to return more detailed information, or change their formats to work more smoothly with monitoring software.

Developers and Administrators.

RTG configuration option <datafilesuffix> can now be configured to disallow duplicating file name extensions using new options <datafilesuffix append> and <datafilesuffix casesensitive>. Previously, this could happen accidentally due to the automatic appending of a file name extension even if there was already one present, causing confusion (for example, accidentally naming something "filename.dat.dat").

Developers and Administrators.

You can now set an RTG file's data file format to a previous version. This allows customers to upgrade to a newer RTG version with the ability to tell RTG to create new files with an older file format. This makes it possible to move files created with newer versions of RTG to previous versions.

Developers and Administrators.

DOC-1532

The ADO.NET SQL and CTDB drivers now support client certificate authentication. This enables replacing the normal password-based authentication with a more secure client certificate method.

Developers , Administrators

DB-44