Skip to main content

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

data typesqueriesfast queries03 January 2024FeatureLog
docker-blue-logo.svg
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

DockerPodmanv1303 January 2024FeatureLog
FC-Icons_MQ_Explorer.svg
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

MQ explorersubscribe to topicsmonitor MQTT broker activities03 January 2024FeatureLog
JSON_DB-wRTG.svg
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
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

JSON DB APItutorialsAPI tutorials03 January 2024FeatureLog
FC-Icons_Data-Explorer.svg
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

API explorertutorialsAPI tutorials11 January 2024FeatureLog
DB_Lock-Isometric-Circle.svg
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

Certificate managerserver certificatesCA certificatesclient certificates03 February 2024FeatureLog
DB_Lock-Isometric-Circle.svg
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

Certificate tutorialscertificate managementnew tutorials03 February 2024FeatureLog
FC-Icons_Data-Explorer.svg
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

API explorerJsonActiondata explorer01 March 2024FeatureLog
Description

Users are now able to utilize the -rule parameter to define external rules in the ctutil -sqlinfo command.

Documents updated
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

ctutil -ruleexternal rules-sqlinfo command01 March 2024FeatureLog
DB_Lock_Isometric_Icon.svg
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
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

ISAM and CTDB APIS for C, C++, Java, C#, and Pythonlist table lockscheck locks05 March 2024FeatureLog
20240111-Brand-Illiustration-development-01.svg
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
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

Pacemaker for RTGCOBOL and Btrieve applicationLinux (Unix)07 March 2024FeatureLog
2024-Show_Demo_Graphics_Allen_Bradley.svg
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
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

Allen Bradley connectorPLC datatransform data01 April 2024FeatureLog
FC-Icons_Real-Time-Access.svg
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
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

deferred indexesimmutable keysindex compression01 April 2024FeatureLog
FC-Icons_FC-Protocol-Icons-Siemens-s7.svg
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
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

Siemens S7PLCSiemens PLC01 April 2024FeatureLog
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

replicationCLIutility
FC-Icons_High-Performance.svg
Description

FairCom's ISAM protocol stays connected even when a TCP connection is less stable.

Documents updated
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

No drop TCP/IP connectionsISAM protocol connectionsTCP connection17 May 2024FeatureLog
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:

  1. Synchronously before a record in committed.

  2. Synchronously after a record has committed.

  3. 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

callbacks in cv13asynchronous callback03 June 2024FeatureLog
FC-Icons_Hot-Backups-Web-RTG.svg
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

DoBatchXtdbatch recordsreusing batch buffers03 June 2024FeatureLog
DB_Data_and_Index_Caching.svg
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

cache primingserver startupincreased server speed03 June 2024FeatureLog
DB_Lock-Isometric-Circle.svg
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

certificate authenticationx.509 client certificatesclient authentication03 June 2024FeatureLog
FC-Icons_Lower-TCO-Web-DB.svg
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

embedded multi user enginev13standalone update03 June 2024FeatureLog
DB_Data_and_Index_Caching.svg
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

dynamic cache resizingresize server dataresize index caches03 June 2024FeatureLog
DB_FIPS_Ready.svg
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

FIPS compliantFIPS 140-2 standardsecurity03 June 2024FeatureLog
FC-Icons_Folder.svg
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

schedule timeoutfriendly file blockingschedule blockout03 June 2024FeatureLog
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

reading logssingle line logspurge logs03 June 2024FeatureLog
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

ctInsertOnlyinsert only tablestables03 June 2024FeatureLog
JSON_DB-wRTG.svg
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
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

JSON DB APIJSON commandsany programming language03 June 2024FeatureLog
DB_Scalability.svg
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

larger default index page sizecustomizable index page sizefast performance03 June 2024FeatureLog
DB_Data-Compression-Icon-1.svg
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

Online index optimizationcompact indexrebuild index03 June 2024FeatureLog
DB_Lock_Isometric_Icon.svg
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

OpenSSL 3.0encryption in transitprotect communications03 June 2024FeatureLog
DB_Lock-Isometric-Circle.svg
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

optimistic lockingupdate recordsincrease development speed03 June 2024FeatureLog
DB_Data_Replication.svg
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

Linux Pacemakerdisaster recoveryv1303 June 2024FeatureLog
DB_DB_Performance-Server-ADD.svg
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

plugin managementv13 updateadjust plugins while the server is running03 June 2024FeatureLog
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

read only serversdata replicationload balancing03 June 2024high availabilityFeatureLog
DB_Recycle-Bin.svg
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

FairCom DBrecycle binrestore data03 June 2024FeatureLog
FC-Icons_Scalability-Edge.svg
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

file extentset initial extentfile size03 June 2024FeatureLog
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

!ALLOW_TRANbackupsfaster backups03 June 2024FeatureLog
FC-Icons_SQL-Web.svg
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

SYS LOGexclude sql user03 June 2024FeatureLog
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

convert data typesUTF-8UTF-16UTF-3228 June 2024FeatureLog
FC-Icons_Memory_Calculator.svg
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

system memorymemory calculator01 July 2024FeatureLog
FC-Icons_FC-Protocol-Icons-Modbus.svg
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
Initial products and versions
  • FairCom Edge 4.2.1

Audience

Users and Engineers

Source references

D1112

Modbus emulator

modbusemulator03 July 2024FeatureLog
FC-Icons_FC-Protocol-Icons-Modbus.svg
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

Modbusconnector16 July 2024FeatureLog
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

prevent denial of servicecreateSession19 July 2024FeatureLog
Cobol_and_RTG.svg
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

RTG COBOLtutorials19 July 2024FeatureLog
FC-Icons_Code-Package.svg
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

code packagesFeatureLogtransform datastore and manage code in the serverJavaScript
FC-Icons_Code-Package.svg
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

transformsJavaScriptintegration tablesFeatureLogAug 2024
FC-Icons_Code-Package.svg
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

transformsJavaScriptJSON DBgetRecordsFeatureLogAug 2024
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

Node-REDclient certificates29 August 2024FeatureLog
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

ADMIN accountsaccount permissionscreate accountalter account12 September 2024JSON ADMIN APIFeatureLog
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

MQTT authenticationconfigureMQTTauthenticationauthentication method
DB_Lock-Isometric-Circle.svg
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

Configure TLS for a server

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

MQTTSHTTPSMQTTWSSWSSSQL ISAMCTDBTLSFeatureLogSep 2024
FC-Icons_Data-Explorer.svg
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

Data explorerUIdata explorer uiJSON APIsvisually manage databases
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

certinfocertinfo.pyPKCS12primary keyprimary certificate
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

replicationuse caseshigh availabilitydisaster recoveryscalability
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

persistent sessionpermanent sessionpermanentSessionsession and services
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

SHMEM_MAX_SPINctSetCommProtocolOptionmemoryspin operation
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

variantFormatgetRecordsvariant formatvariant fieldshexadecimalBase64UTF-8
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

TransactionLogflush timecstatsnapshotmonitor performance
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

MQTTsecuritycommunicationMQTT communicationsMQTT security
DB_FIPS_Ready.svg
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

FIPSFIPS supportOpenSSLFIPS validationsecure communications
DB_FIPS_Ready.svg
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

FIPSFIPS migrationOpenSSL
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

configuration optionstransaction logdiagnostics
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

TutorialPacemakerfailoverreplicationrecoveryrecover from a pacemaker cluster failure state
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

non-SQLISAMDB Notifybuffers
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

Transformcode packagegetRecordsjavascriptoutputJSON DBJSON Action
FC-Icons_SSL-TLS_Secure_1.svg
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)

Linux (Unix)CA certificateimportTLSSecure
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

transaction logreset
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

MQ API actionsmessage actionsevent streaming actionsKafkapubsub
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

variantvariant typedata typeJSON DB
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

failover risknotificationnotify
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

Tutorialrebuild tablesrebuild 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

RTGlog entrycustomize
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

RTGBTRVBtrievecompatibility
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

UpgradeRTGv5JSON DB APIdbNotifypartitioned fileshot alter table
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

rtgprefetchspeedperformanceallowwriters
Hot_alter_table.png
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

Hot alter tableSQL alter tableAdd columnApplication update
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

RTGctutilcommand line toolfile passwordunloadinfoapply rulesfile size maximumstorage conventionddfrecord schemacopy
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

RTGsubstitution specifierserver task id
partitioned_files.png
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

partitionfilesrtgtable
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

RTGfile nameextensionduplicate
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

RTG function monitorFunction monitorLog
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

RTGmaximumfile sizeConfiguration elementctutil<maxsize>-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

versionpreviousprioroldrtgupgrade
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

Client certificates in ADO.NET

TLSX509client certificateADO.NETauthentication