2024 December FeatureLog
View the various changes made to the FairCom documentation in the month of December
change log for December 2024
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.
FairCom DB 13.0.1
FairCom Edge 4.2.1
FairCom MQ 4.2.1
FairCom RTG COBOL 4.2.1
FairCom RTG Btrieve 4.2.1
Developers and Administrators
D1510
variant data type
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
FairCom DB 13.0.1
FairCom Edge 4.2.1
FairCom MQ 4.2.1
FairCom RTG COBOL 4.2.1
FairCom RTG Btrieve 4.2.1
Developers Administrators
D1439
Failover risk notification method
In the rare event of data corruption, quickly recover using our new tutorial for rebuilding indexes.
FairCom DB 13.0.1
FairCom Edge 4.2.1
FairCom MQ 4.2.1
FairCom RTG COBOL 4.2.1
FairCom RTG Btrieve 4.2.1
Developers and Administrators
D1131
tutorial to rebuild tables and indexes
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.
FairCom RTG COBOL 5.0.0
FairCom RTG Btrieve 5.0.0
Developers and Administrators.
D1492
Upgrade to RTG 5
 |
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.
FairCom RTG COBOL 5.0.0
FairCom RTG Btrieve 5.0.0
Developers and Administrators
D1472
Hot Alter Table
 |
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.
FairCom RTG COBOL 5.0.0
FairCom RTG Btrieve 5.0.0
Developers and Administrators.
D1547
Partitioned files in RTG
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.
FairCom RTG COBOL 5.0.0
FairCom RTG Btrieve 5.0.0
Developers and Administrators.