2024
View the various changes made to the FairCom documentation in the year 2024
View the updates and features developed in the year 2024
change log for 2024
change log
update log
new feature log
2024
Description
You can now see explanations of data types supported by FairCom to quickly find the best data type to make your queries predictable and fast.
Documents updated
Initial products and versions
FairCom DB 13.0.0
FairCom MQ 4.2.0
FairCom Edge 4.2.0
FairCom RTG Btrieve 4.2.0
FairCom RTG COBOL 4.2.0
Audience
Developers
Data types
Description
You can now automate the process for making a Docker or Podman image of any FairCom product with v13's new tutorial and utility.
Documents updated
Initial products and versions
FairCom DB 13.0.0
FairCom MQ 4.2.0
FairCom Edge 4.2.0
FairCom RTG Btrieve 4.2.0
FairCom RTG COBOL 4.2.0
Audience
Administrators and Developers
Docker and Podman
Description
MQ Explorer enables users to manage, publish, and subscribe to topics to monitor MQTT broker activities in one central location.
Documents updated
Initial products and versions
FairCom DB 13.0.0
FairCom MQ 4.2.0
FairCom Edge 4.2.0
FairCom RTG Btrieve 4.2.0
FairCom RTG COBOL 4.2.0
Audience
Administrators, Developers, and Engineers
MQ explorer
Description
New tutorials have been included in the v13 release of FairCom DB to help you start using the new JSON DB API quickly and easily.
Documents updated
Java Tutorials
JavaScript Tutorials
Node-RED Tutorials
Python Tutorials
SQL Tutorials
Initial products and versions
FairCom DB 13.0.0
FairCom MQ 4.2.0
FairCom Edge 4.2.0
FairCom RTG Btrieve 4.2.0
FairCom RTG COBOL 4.2.0
Audience
Developers and Administrators
JSON DB API tutorials
Description
Added a tutorial for API Explorer to help you use any programming language to perform all database operations quicker and easier.
Documents updated
Initial products and versions
FairCom DB 13.0.0
FairCom MQ 4.2.0
FairCom Edge 4.2.0
FairCom RTG Btrieve 4.2.0
FairCom RTG COBOL 4.2.0
Audience
Developers and Administrators
Added API explorer tutorials
Description
FairCom now provides an easy to manage, private certificate management solution that creates, renews, and manages CA, server, and client certificates. This enables all private companies to implement certificate management to secure internal servers without the need for a technical understanding of certificates.
Documents updated
Initial products and versions
FairCom DB 13.0.0
FairCom MQ 4.2.0
FairCom Edge 4.2.0
FairCom RTG Btrieve 4.2.0
FairCom RTG COBOL 4.2.0
Audience
Administrators
FairCom now provides an easy to manage, private certificate management solution that creates, renews, and manages CA, server, and client certificates
Description
New tutorials have been included alongside the release of our Certificate management solution to help you start using certificates quickly and easily.
Documents updated
Initial products and versions
FairCom DB 13.0.0
FairCom MQ 4.2.0
FairCom Edge 4.2.0
FairCom RTG Btrieve 4.2.0
FairCom RTG COBOL 4.2.0
Audience
Developers and Administrators
New tutorials have been included alongside the release of our certificate management solution to help you start using certificates quickly and easily
Description
Added API Explorer, an editor for running every JSON Action API available in FairCom products, to FairCom Data Explorer to allow you to use any programming language to perform all database operations.
Documents updated
Initial products and versions
FairCom DB 13.0.0
FairCom MQ 4.2.0
FairCom Edge 4.2.0
FairCom RTG Btrieve 4.2.0
FairCom RTG COBOL 4.2.0
Audience
Developers and Administrators
Added API explorer to run every JSON Action API available
Description
Users are now able to utilize the -rule parameter to define external rules in the ctutil -sqlinfo command.
Documents updated
Rule file APIs
Initial products and versions
FairCom RTG Btrieve 4.2.0
FairCom RTG COBOL 4.2.0
Audience
Developers and Administrators
Source references
D789
Users are now able to utilize the -rule parameter to define external rules in the ctutil -sqlinfo command
Description
FairCom has implemented a new function to the ISAM and CTDB APIs for C, C++, Java, C#, and Python to enable users to check if there are any locks on the table in the current session.
Documents updated
ctdbTableHasLocks() Concepts
Initial products and versions
FairCom DB 13.0.0
FairCom MQ 4.2.0
FairCom Edge 4.2.0
FairCom RTG Btrieve 4.2.0
FairCom RTG COBOL 4.2.0
Audience
Developers
Source references
D714
List table locks
Description
COBOL and Btrieve application running on Linux servers can now be highly available when running FairCom RTG and Pacemaker. FairCom has fully tested and supports Linux Pacemaker failover for all its products.
Documents updated
cluster option Btrieve Concepts
cluster option COBOL Concepts
Initial products and versions
FairCom DB 13.0.0
FairCom MQ 4.2.0
FairCom Edge 4.2.0
FairCom RTG Btrieve 4.2.0
FairCom RTG COBOL 4.2.0
Audience
Administrators
Source references
D830
COBOL and Btrieve application running on Linux (Unix) servers can now be highly available when running RTG and Pacemaker
Description
FairCom Edge now supports collecting data from Allen-Bradley PLCs using the EtherNet/IP protocol so you can transform and deliver PLC data with no code to the cloud, machine learning systems, analytical platforms, data warehouses, MQTT, MES, ERP, SQL, JSON web service, ThingWorx, and so forth.
Documents updated
Allen-Bradley Concepts
Initial products and versions
FairCom Edge 4.2.0
Audience
Users and Engineers
Source references
D851
Allen Bradley connector can transform and deliver PLC data with no code
Description
The CTDB API for C# now supports deferred indexes, indexes with immutable keys, initial background key loads, and index compression. Index compression reduces the size of index entries and index files for fast IO.
Documents updated
CTDB index types APIs
Initial products and versions
FairCom DB 13.0.0
FairCom MQ 4.2.0
FairCom Edge 4.2.0
FairCom RTG Btrieve 4.2.0
FairCom RTG COBOL 4.2.0
Audience
Developers
Source references
D857
The CTDB API for C# now supports deferred indexes, indexes with immutable keys, initial background key loads, and index compression
Description
FairCom Edge now supports collecting data from Siemens PLCs using the Siemens S7 protocol so you can transform and deliver PLC data with no code to the cloud, machine learning systems, analytical platforms, data warehouses, MQTT, MES, ERP, SQL JSON web service, ThingWorx, and so forth.
Documents Updated
Siemens S7 Concepts
Initial products and versions
FairCom Edge 4.2.0
Audience
Users and Engineers
Source references
D844
Siemens S7 protocol can transform and deliver PLC data with no code
Description
Users can automate Replication Manager operations by creating JSON input files and sending them to the replutil
command-line utility. Otherwise, these operations must be individually executed through the Replication Manager UI or through direct calls to the Replication HTTP API.
Documents updated
Initial products and versions
FairCom DB 13.0.0
FairCom Edge 4.0.0
FairCom MQ 4..0.0
FairCom RTG COBOL 4.0.0
FairCom RTG Btrieve 4.0.0
Audience
Users , Developers , and Administrators
Source references
D404
New replication CLI utility
Description
FairCom's ISAM protocol stays connected even when a TCP connection is less stable.
Documents updated
DEAD_CLIENT_INTERVAL explains the API
TCPIP_CHECK_DEAD_CLIENTS explains the API
ctSetCommProtocolOption explains the API
Initial products and versions
FairCom DB 13.0.0
Audience
Developers
Source references
D956
FairCom's ISAM protocol stays connected even when a TCP connection is less stable
Description
FairCom DB allows you to write callbacks in C to modify a record before the server stores it in the database.
In V13, a record update callback can be executed synchronously or asynchronously during one of the following events:
Synchronously before a record in committed.
Synchronously after a record has committed.
Asynchronously after a record has committed.
You also have the option of asynchronously running code that does other tasks instead of updating.
Documents updated
Initial products and versions
FairCom DB 13.0.0
FairCom MQ 4.2.0
FairCom Edge 4.2.0
FairCom RTG Btrieve 4.2.0
FairCom RTG COBOL 4.2.0
Audience
Developers
Asynchronous callbacks
Description
FairCom DB v13 reduces the amount of time needed to process batch records by reusing buffers with the DoBatchXtd keyword.
Documents updated
Initial products and versions
FairCom DB 13.0.0
FairCom MQ 4.2.0
FairCom Edge 4.2.0
FairCom RTG Btrieve 4.2.0
FairCom RTG COBOL 4.2.0
Audience
Developers
Reduced the amount of time needed to process batch records by reusing buffers with the DoBatchXtd keyword
Description
FairCom now enables you to prime the cache when your server starts which increases server speed and improves in-memory cache with predictable, low-latency response times.
Documents updated
Initial products and versions
FairCom DB 13.0.0
FairCom MQ 4.2.0
FairCom Edge 4.2.0
FairCom RTG Btrieve 4.2.0
FairCom RTG COBOL 4.2.0
Audience
Administrators
Cache priming at server startup
Description
All FairCom products support client certificate authentication to authenticate clients using x.509 client certificates in HTTPS, MQTTS, ISAM, and SQL protocols for more secure client-server communication.
Documents updated
Initial products and versions
FairCom DB 13.0.0
FairCom MQ 4.2.0
FairCom Edge 4.2.0
FairCom RTG Btrieve 4.2.0
FairCom RTG COBOL 4.2.0
Audience
Administrators
Client certificate authentication
Description
The DB Standalone service allows the multi-user engine to be embedded directly into the application through linking or compiling.
You can also scale office applications to multiple simultaneous users on any OS while keeping costs low.
Our non-client-server model supports multiple users reading and writing simultaneously to the same set of files.
V13 has added partitioned files to automatically retain data for specific periods of time.
V13 has also added rebuild and compact utilities to safely encrypt your data.
Documents updated
Initial products and versions
FairCom DB 13.0.0
FairCom MQ 4.2.0
FairCom Edge 4.2.0
FairCom RTG Btrieve 4.2.0
FairCom RTG COBOL 4.2.0
Audience
Developers
DB standalone improvement
Description
Applications can now resize the FairCom server's data and index caches on demand without restating the server, reducing the amount of RAM needed to support the simultaneous needs of the server, applications, and OS caches.
Documents updated
Initial products and versions
FairCom DB 13.0.0
FairCom MQ 4.2.0
FairCom Edge 4.2.0
FairCom RTG Btrieve 4.2.0
FairCom RTG COBOL 4.2.0
Audience
Administrators and Developers
Dynamic cache resizing
Description
All FairCom products support the FIPS 140-2 standard which allows you to certify your applications as FIPS compliant.
Documents updated
Initial products and versions
FairCom DB 13.0.0
FairCom MQ 4.2.0
FairCom Edge 4.2.0
FairCom RTG Btrieve 4.2.0
FairCom RTG COBOL 4.2.0
Audience
Administrators
All FairCom products support the FIPS 140-2 standard which allows you to certify your applications as FIPS compliant
Description
Developers and applications can now schedule a timeout window to block file access to allow running transactions time to finish before the file is blocked.
Documents updated
Initial products and versions
FairCom DB 13.0.0
FairCom MQ 4.2.0
FairCom Edge 4.2.0
FairCom RTG Btrieve 4.2.0
FairCom RTG COBOL 4.2.0
Audience
Developers
Developers and applications can now schedule a timeout window to block file access to allow running transactions time to finish before the file is blocked
Description
FairCom has made reading logs faster by reducing each log to a single line. Logs can also hold more entries for you and purge more quickly.
Documents updated
Initial products and versions
FairCom DB 13.0.0
FairCom MQ 4.2.0
FairCom Edge 4.2.0
FairCom RTG Btrieve 4.2.0
FairCom RTG COBOL 4.2.0
Audience
Administrators
FairCom has made reading logs faster by reducing each log to a single line
Description
FairCom provides users with more accurate information using insert-only tables (ctInsertOnly) that prevent records from being deleted or updated.
Documents updated
Initial products and versions
FairCom DB 13.0.0
FairCom MQ 4.2.0
FairCom Edge 4.2.0
FairCom RTG Btrieve 4.2.0
FairCom RTG COBOL 4.2.0
Audience
Developers
FairCom provides users with more accurate information using insert only tables
Description
The new JSON DB API allows you to quickly build web applications and services on any data in the FairCom database regardless of which API manages the data with simple JSON commands, allowing you to utilize any programming language you already know.
Documents updated
JSON DB Concepts
Initial products and versions
FairCom DB 13.0.0
FairCom MQ 4.2.0
FairCom Edge 4.2.0
FairCom RTG Btrieve 4.2.0
FairCom RTG COBOL 4.2.0
Audience
Developers and Administrators
JSON DB API allows you to quickly build web applications and services with JSON commands
Description
In testing the performance of FairCom products, we have found that a page size of 32K provides the fastest performance on modern hardware and have made this the new default. However, you can control the size to match your specific environment.
Documents updated
Initial products and versions
FairCom DB 13.0.0
FairCom MQ 4.2.0
FairCom Edge 4.2.0
FairCom RTG Btrieve 4.2.0
FairCom RTG COBOL 4.2.0
Audience
Administrators
Larger default index page size
Description
You can now compact and rebuild specific indexes and data files without affecting database operations, allowing for faster indexes that consume less storage.
Documents updated
Initial products and versions
FairCom DB 13.0.0
FairCom MQ 4.2.0
FairCom Edge 4.2.0
FairCom RTG Btrieve 4.2.0
FairCom RTG COBOL 4.2.0
Audience
Developers
Compact and rebuild specific indexes and data files without affecting database operations
Description
All FairCom products use OpenSSL 3.0 to provide encryption in transit and at rest to protect communications from malicious attackers.
Documents updated
Initial products and versions
FairCom DB 13.0.0
FairCom MQ 4.2.0
FairCom Edge 4.2.0
FairCom RTG Btrieve 4.2.0
FairCom RTG COBOL 4.2.0
Audience
Developers and Administrators
All FairCom products use OpenSSL 3.0 to provide encryption in transit and at rest to protect communications from malicious attackers
Description
Optimistic locking enables you to update records safely without compromising your application's speed. This increases the speed of development and number of concurrent users while simplifying software development.
Documents updated
Initial products and versions
FairCom DB 13.0.0
FairCom MQ 4.2.0
FairCom Edge 4.2.0
FairCom RTG Btrieve 4.2.0
FairCom RTG COBOL 4.2.0
Audience
Developers
Optimistic locking enables you to update records safely without compromising your application's speed
Description
FairCom DB now supports Linux Pacemaker to help you scale your application while maintaining high quality disaster recovery in high availability, large-scale, multi-tenant solutions.
Documents updated
Initial products and versions
FairCom DB 13.0.0
FairCom MQ 4.2.0
FairCom Edge 4.2.0
FairCom RTG Btrieve 4.2.0
FairCom RTG COBOL 4.2.0
Audience
Administrators and Developers
FairCom DB now supports Linux Pacemaker to help yo scale your application while maintaining high quality disaster recovery
Description
FairCom DB v13 is now capable of starting, stopping, and changing, settings for individual plugins and services while the server is running. You no longer need to restart the server to do this.
Documents updated
Initial products and versions
FairCom DB 13.0.0
FairCom MQ 4.2.0
FairCom Edge 4.2.0
FairCom RTG Btrieve 4.2.0
FairCom RTG COBOL 4.2.0
Audience
Administrators and Developers
Plugin management
Description
FairCom enables you to create multiple read-only servers and use data replication to keep them in sync with a source server to provide a load balancing solution or high availability while also increasing scalability.
Documents updated
Initial products and versions
FairCom DB 13.0.0
FairCom MQ 4.2.0
FairCom Edge 4.2.0
FairCom RTG Btrieve 4.2.0
FairCom RTG COBOL 4.2.0
Audience
Administrators
Read only servers
Description
You can now configure FairCom DB to delete files to a recycle bin instead of deleting them from your disk. This allows you to restore data from the recycle bin rather than from an outdated backup in the case of accidental deletion.
Documents updated
Initial products and versions
FairCom DB 13.0.0
FairCom MQ 4.2.0
FairCom Edge 4.2.0
FairCom RTG Btrieve 4.2.0
FairCom RTG COBOL 4.2.0
Audience
Developers and Administrators
recycle bin
Description
FairCom now allows you to set the initial file extent when you create a file, allowing you to make it small for rarely updated files, and large for frequently updated files.
Tip
You can open up to 1 million files simultaneously.
Documents updated
Initial products and versions
FairCom DB 13.0.0
FairCom MQ 4.2.0
FairCom Edge 4.2.0
FairCom RTG Btrieve 4.2.0
FairCom RTG COBOL 4.2.0
Audience
Developers
Set initial file extent
Description
FairCom DB v13 saves you time by enabling you to add !ALLOW_TRAN to the dynamic dump script to start backups without waiting for outstanding transactions to finish, and by delivering backup status messages without slowing down the backup process.
Documents updated
Initial products and versions
FairCom DB 13.0.0
FairCom MQ 4.2.0
FairCom Edge 4.2.0
FairCom RTG Btrieve 4.2.0
FairCom RTG COBOL 4.2.0
Audience
Administrators
Start backups faster with !ALLOW_TRAN
Description
You can now use SYSLOG_EXCLUDE_SQL_USER to configure the server to turn off SQL logging for specific users to reduce the traffic from unhelpful events.
Documents updated
Initial products and versions
FairCom DB 13.0.0
FairCom MQ 4.2.0
FairCom Edge 4.2.0
FairCom RTG Btrieve 4.2.0
FairCom RTG COBOL 4.2.0
Audience
Administrators
SYS LOG exclude sql user
Description
FairCom has implemented UNICODE server support for UTF-8.
Documents updated
Initial products and versions
FairCom DB 13.0.0
Audience
Developers
Source references
D1026
convert between UTF-8, UTF-16, AND UTF-32
Description
FairCom now provides an in-house system memory calculator that calculates a server's expected memory use. Administrators can use this new feature to help them allocate system memory to maintain high server performance.
Documents updated
Initial products and versions
FairCom DB 13.0.0
FairCom Edge 4.2.0
FairCom MQ 4.2.0
FairCom RTG COBOL 4.2.0
FairCom RTG Btrieve 4.2.0
Audience
Administrators and Developers
Source references
D918
system memory calculator
Description
FairCom Edgeprovides a Modbus emulator that simulates a hardware device communicating over the Modbus protocol. You can run and configure the Modbus emulator from the command line in Windows, Linux (Unix), and MacOS.
Documents updated
Modbus emulator Tutorials
Initial products and versions
FairCom Edge 4.2.1
Audience
Users and Engineers
Source references
D1112
Modbus emulator
Description
The FairCom Edge Modbus connector allows users to specify the format in which their data types will be read or written and returns new exception codes to help you troubleshoot issues more easily.
FairCom has deprecated the property name modbusSlave
and replaced it with the new name of modbusUnitId
.
Documents updated
Initial products and versions
FairCom Edge 4.2.1
Audience
Engineers and Users
Source references
D1115
Modbus connector enhancements
Description
The FairCom server protects against denial of service attacks by limiting the number of connections and JSON DB sessions from a single TCP/IP address and username.
Documents updated
Initial products and versions
FairCom DB 13.0.1
FairCom MQ 4.2.1
FairCom Edge 4.2.1
FairCom RTG Btrieve 4.2.1
FairCom RTG COBOL 4.2.1
Audience
Administrators
Source references
D1156
Prevent denial of service
Description
The cobol_tutorial1 is a simple COBOL application that creates a data table to verify if the file system is properly running.
The Sqlize tutorial demonstrates how to prepare your data for SQL access so you can query COBOL data using SQL, JSON DB, JDBC, etc.
Documents updated
Initial products and versions
FairCom RTG COBOL 4.2.1
Audience
Administrators
Source references
D1125
RTG COBOL tutorials
Description
Code packages allow you to store and manage code in the server with version control. Currently, code packages currently support running JavaScript code in the FairCom server. You can use code package actions to create, modify, clone, list, and view your code packages so that you can ensure the most up to date version of your code is running.
If you are actively developing your code, you can activate and deactivate as well as delete and undelete versions of your code so that you can develop without worrying about breaking code.
Documents updated
Initial products and versions
FairCom DB 13.0.1
FairCom MQ 4.2.1
FairCom Edge 4.2.1
FairCom RTG Btrieve 4.2.1
FairCom RTG COBOL 4.2.1
Audience
Developers
Source references
D871
Code packages
Description
All FairCom products now enable developers to embed and run JavaScript code to transform the data inserted into their integration tables. You can add or remove properties, change property values, completely restructure the JSON, and even run functions to convert data values such as converting Celsius to Fahrenheit.
Documents updated
Initial products and versions
FairCom DB 13.0.1
FairCom MQ 4.2.1
FairCom Edge 4.2.1
FairCom RTG Btrieve 4.2.1
FairCom RTG COBOL 4.2.1
Audience
Developers
Source references
D871
JavaScript transforms for FairCom Edge and MQ
Description
All FairCom products now enable developers to embed and run JavaScript code to transform data returned by the JSON DB "getRecords..."
actions. You can add or remove properties, change property values, completely restructure the JSON, and even run functions to convert data values such as converting Celsius to Fahrenheit.
Documents updated
Initial products and versions
FairCom DB 13.0.1
FairCom MQ 4.2.1
FairCom Edge 4.2.1
FairCom RTG Btrieve 4.2.1
FairCom RTG COBOL 4.2.1
Audience
Developers
Source references
D871
JavaScript transforms for JSON DB getRecords
Description
FairCom has released a new tutorial to show you how to configure client certificates and TLS in Node-RED.
You can now configure Node-RED to authenticate with a FairCom server with client certificates. Client certificates are a more secure way to authenticate than using a username and password.
Documents updated
Initial products and versions
FairCom DB 13.0.1
FairCom MQ 4.2.1
FairCom Edge 4.2.1
FairCom RTG Btrieve 4.2.1
FairCom RTG COBOL 4.2.1
Audience
Administrators and Engineers
Source references
D1329
Node-RED client certificates
Description
FairCom's ADMIN accounts API lets you create accounts and manage account privileges. Using its API actions, you can create or drop accounts, alter an existing accounts, create copies of accounts, assign roles to accounts, and see information about accounts.
Documents updated
Initial products and versions
FairCom DB 13.0.1
FairCom MQ 4.2.1
FairCom Edge 4.2.1
FairCom RTG Btrieve 4.2.1
FairCom RTG COBOL 4.2.1
Audience
Developers
Source references
D1403
ADMIN accounts API manages account creation and permissions
Description
FairCom MQ and FairCom Edge enforce secure MQTT communications with the broker. You control how MQTT clients authenticate when you choose the authentication method to ensure ease of access and the desired level of security.
Documents updated
Initial products and versions
FDB 13.0.1
FE 4.2.1
FMQ 4.2.1
FCBL 4.2.1
FBTR 4.2.1
Audience
Administrators and Developers
Source references
D1166
Configure the MQTT authentication method
Description
FairCom servers can now use TLS with HTTPS, MQTTS, MQTTWSS, WSS, SQL ISAM and CTDB to secure messages. This makes communications with FairCom servers less vulnerable to hackers.
Documents updated
Initial products and versions
FairCom DB 13.0.1
FairCom MQ 4.2.1
FairCom Edge 4.2.1
FairCom RTG Btrieve 4.2.1
FairCom RTG COBOL 4.2.1
Audience
Developers
Source references
D1166
TLS secure communications
Description
View and manage your FairCom databases and visually explore our JSON APIs with the updated Data Explorer user interface .
Documents updated
Initial products and versions
FairCom DB 13.0.1
FairCom MQ 4.2.1
FairCom Edge 4.2.1
FairCom RTG Btrieve 4.2.1
FairCom RTG COBOL 4.2.1
Audience
Users
Source references
D1425
Data explorer UI update to visually manage databases and JSON APIs
Description
You can run certinfo against a PKCS12 (.12) file to show the primary key, the primary certificate, and any additional certificates.
Documents updated
Initial products and versions
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
Audience
Administrators
Source references
D1257
You can run certinfo against a PKCS12 (.12) file to show the primary key, the primary certificate, and any additional certificates
Description
The documentation now includes use cases for using replication for high availability, disaster recovery, and scalability.
Documents updated
Initial products and versions
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
Audience
Developers and Administrators
Source references
D1411
use cases for using replication for high availability, disaster recovery, and scalability
Description
FairCom enables applications to authorize JSON actions without the need for a username/password or client certificate using the permanentSession
property. While it is slightly less secure, it allows many servers to use the same authToken (API key) to simplify session management.
Documents updated
Initial products and versions
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
Audience
Administrators
Source references
D1435 and D1454
persistent sessions permanentSession property
Description
You can now reduce the variability in performance of a client application by setting the maximum number of spin operations that a shared memory connection can use.
Documents updated
Initial products and versions
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
Audience
Administrators
Source references
D1302
use SHMEM_MAX_SPIN and ctSetCommProtocolOption to control the number of spin operations that a shared memory connection can use
Description
The new variantFormat
property allows you to specify the format in which variant fields are returned from JSON DB API "getRecords..."
actions so that you can set the data format returned from a variant, such as hexadecimal, Base64, UTF-8, and the variant JSON object.
Documents updated
Initial products and versions
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
Audience
Developers and Administrators
Source references
D1437
variantFormat property get records actions
Description
Use transaction log histograms to help monitor server performance, watching for trends when performance is being impacted.
Documents updated
Initial products and versions
FairCom DB 13.0.2
Audience
Developers , Administrators
Source references
CTREEACE-12125
Transaction log flush time histograms
Description
The new "authenticationMethods" property allows you to control which methods MQTT clients are allowed to use to authenticate. For example, you can limit client authentication to any combination of client certificate and/or username/password.
Documents updated
Initial products and versions
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
Audience
Developers Administrators
Source references
D1166
Improved MQTT communication security
Description
Faircom now supports FIPS 140.2 through OpenSSL 3.0 to ensure secure communications. FIPS 140.2 is an encryption standard established by the US federal government for verifying the implementation of OpenSSL.
Documents updated
Initial products and versions
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
Audience
Developers Administrators
Source references
D586
FIPS validation for secure communications
Description
This feature migrates previously encrypted files into FIPS-140.2 format for enhanced security, compatibility and functionality.
Documents updated
Initial products and versions
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
Audience
Developers Administrators
Source references
D586
Enable FIPS validation of encrypted files
Description
This feature provides enhanced transaction log diagnostics capability when enabled using the CHECK_TRNLOG_BUFFER_WRITES configuration option. The DIAGNOSTICS TRNLOG_WRITES option writes transaction log entries that report when bytes are being skipped and when the transaction type is invalid.
Documents updated
Initial products and versions
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
Audience
Developers Administrators
Source references
D1433
Improved transaction log diagnostics using new configuration options
Description
Quickly recover from a Pacemaker cluster failure state with our new tutorial on how to recover from cluster failure states with replication.
Documents updated
Initial products and versions
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
Audience
Administrators
Source references
D1456
Tutorial Pacemaker failover when using replication
Description
You can now specify that DB Notify messages contain a whole record buffer instead of individual fields. This allows you to track changes to files that do not have field definitions or table names. Additionally, you can now use a pathname to specify non-SQL files that you want to track.
Documents updated
Initial products and versions
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
Audience
Developers
Source references
D1427 D1464
DB Notify ISAM records without fields and non-SQL data files
Description
You can use JavaScript to transform the output of all JSON DB "getRecords..."
actions. You can add fields, change field values, and calculate aggregate values like min, max, and average.
Documents updated
Initial products and versions
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
Audience
Administrators
Source references
D1500
Transform outputs of "getRecords" actions
Description
This tutorial shows how to import a CA certificate to a Linux (Unix) OS keystore as part of implementing TLS security. With CA certificates stored, applications can be programmed to establish secure connections to websites so Google Chrome does not report that the site is insecure.
Documents updated
Initial products and versions
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
Audience
Developers
Source references
D961
Tutorial to import a CA certificate to Linux (Unix)
Description
You might want to reset the transaction log due to impending transaction limits, database upgrades, or other reasons. Documentation has been added to help when dealing with special situations where you use dynamic dump backups, replication, deferred Indexing, full-text indexing, or record update callbacks.
Documents updated
Initial products and versions
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
Audience
Developers Administrators
Source references
D358
Reset the transaction log
Description
FairCom added new actions to the MQ API to enable you to have MQTT's pub/sub capabilities while using the HTTP protocol. FairCom uniquely allows you to centrally manage sessions for all MQTT clients. The "getMessagesFromMqttTopic"
action allows you to do event streaming in FairCom products similar to how Kafka does it.
Documents updated
Initial products and versions
FairCom Edge 4.2.1
FairCom MQ 4.2.1
Audience
Administrators
Source references
D1509
New message and event streaming actions in the MQ API for pub and sub capabilities similar to Kafka
Description
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.
Documents updated
Initial products and versions
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
Audience
Developers and Administrators
Source references
D1510
variant data type
Description
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
Documents updated
Initial products and versions
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
Audience
Developers Administrators
Source references
D1439
Failover risk notification method
Description
In the rare event of data corruption, quickly recover using our new tutorial for rebuilding indexes.
Documents updated
Initial products and versions
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
Audience
Developers and Administrators
Source references
D1131
tutorial to rebuild tables and indexes
Description
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.
Documents updated
Initial products and versions
FairCom RTG COBOL 5.0.0
FairCom RTG Btrieve 5.0.0
Audience
Developers and Administrators.
Customize format of client application logging in RTG
Description
FairCom RTG is now compatible with new Btrieve operations that were not previously supported. We support the vast majority of applicable Btrieve functionalities.
Documents updated
Initial products and versions
FairCom RTG COBOL 5.0.0
FairCom RTG Btrieve 5.0.0
Audience
Developers and Administrators.
Source references
D1550
Enhanced Btrieve compatibility in RTG
Description
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.
Documents updated
Initial products and versions
FairCom RTG COBOL 5.0.0
FairCom RTG Btrieve 5.0.0
Audience
Developers and Administrators.
Source references
D1492
Upgrade to RTG 5
Description
Caching records in advance (prefetch) with RTG is now innately faster. In addition, you can improve speed even further by using the new RTG configuration option <prefetch allowwriters> to avoid unnecessary lock calls.
Documents updated
Initial products and versions
FairCom RTG COBOL 5.0.0
FairCom RTG Btrieve 5.0.0
Audience
Developers and Administrators.
Faster RTG prefetch
![]() |
Description
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.
Documents updated
Initial products and versions
FairCom RTG COBOL 5.0.0
FairCom RTG Btrieve 5.0.0
Audience
Developers and Administrators
Source references
D1472
Hot Alter Table
Description
Commands for RTG's command line tool (ctutil) have been added or enhanced to improve ease of use and to support new v5 features.
Documents updated
New commands:
-o word: Specifies the password of a file.
-unload: Allows you to read records larger than 64KB by exporting data from a COBOL data file to a sequential or ASCII file.
-info: Displays information about a file.
-applyrules: Applies rules to an XFD or XDD file.
-maxsize: Specifies a maximum size limit for a file.
Enhanced commands:
-conv: Stores or retrieves the numeric storage convention of a file. Enhanced to be able to do this even if the convention ID parameter is omitted.
-ddf2xdd: Transforms Btrieve Data Dictionary Files (DDFs) into c-tree XDD files containing schema information about the data and index structures. Enhanced to be able to do this even when the name in the DDF does not match the file name.
-alter: Changes the record schema of a file. Enhanced to display new record length on success.
-copy: Copies a file. Enhanced not to automatically overwrite existing destination files.
Initial products and versions
FairCom RTG COBOL 5.0.0
FairCom RTG Btrieve 5.0.0
Audience
Developers, Administrators.
New and updated RTG commands in ctutil
Description
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.
Documents updated
Initial products and versions
FairCom RTG COBOL 5.0.0
FairCom RTG Btrieve 5.0.0
Audience
Developers and Administrators.
New RTG substitution specifier for server task ID
![]() |
Description
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.
Documents updated
Initial products and versions
FairCom RTG COBOL 5.0.0
FairCom RTG Btrieve 5.0.0
Audience
Developers and Administrators.
Source references
D1547
Partitioned files in RTG
Description
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").
Documents updated
Initial products and versions
FairCom RTG COBOL 5.0.0
FairCom RTG Btrieve 5.0.0
Audience
Developers and Administrators.
Prevent duplicate file name extensions in RTG
Description
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.
Documents updated
Initial products and versions
FairCom RTG COBOL 5.0.0
FairCom RTG Btrieve 5.0.0
Audience
Developers and Administrators.
Function names in RTG function monitor
Description
In FairCom RTG, you can now set the maximum file size limit for a file using the configuration option <maxsize> or the ctutil command -maxsize. This is helpful in situations where RAM is limited, such as when using memory files.
Documents updated
Initial products and versions
FairCom RTG COBOL 5.0.0
FairCom RTG Btrieve 5.0.0
Audience
Developers and Administrators.
Source references
DOC 1531
RTG maxsize
Description
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.
Documents updated
Initial products and versions
FairCom RTG COBOL 5.0.0
FairCom RTG Btrieve 5.0.0
Audience
Developers and Administrators.
Source references
DOC-1532
Set RTG file's data file format to a previous version
Description
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.
Documents updated
Initial products and versions
FairCom DB 13.0.2
Audience
Developers , Administrators
Source references
DB-44