2024 June FeatureLog
View the various changes made to the FairCom documentation in the month of June
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.
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
Administrators
Start backups faster with !ALLOW_TRAN
 |
FairCom DB v13 reduces the amount of time needed to process batch records by reusing buffers with the DoBatchXtd keyword.
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
Developers
Reduced the amount of time needed to process batch records by reusing buffers with the DoBatchXtd keyword
 |
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.
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
Administrators
Cache priming at server startup
 |
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.
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
Administrators
Client certificate authentication
|
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.
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
Administrators and Developers
Dynamic cache resizing
 |
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.
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
Developers
DB standalone improvement
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.
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
Developers
Asynchronous callbacks
 |
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.
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
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
 |
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.
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
Developers
Set initial file extent
 |
All FairCom products support the FIPS 140-2 standard which allows you to certify your applications as FIPS compliant.
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
Administrators
All FairCom products support the FIPS 140-2 standard which allows you to certify your applications as FIPS compliant
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.
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
Administrators
FairCom has made reading logs faster by reducing each log to a single line
FairCom provides users with more accurate information using insert-only tables (ctInsertOnly) that prevent records from being deleted or updated.
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
Developers
FairCom provides users with more accurate information using insert only tables
 |
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.
JSON DB Concepts
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
Developers and Administrators
JSON DB API allows you to quickly build web applications and services with JSON commands
 |
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.
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
Administrators
Larger default index page size
 |
You can now compact and rebuild specific indexes and data files without affecting database operations, allowing for faster indexes that consume less storage.
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
Developers
Compact and rebuild specific indexes and data files without affecting database operations
 |
All FairCom products use OpenSSL 3.0 to provide encryption in transit and at rest to protect communications from malicious attackers.
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
Developers and Administrators
All FairCom products use OpenSSL 3.0 to provide encryption in transit and at rest to protect communications from malicious attackers
|
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.
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
Developers
Optimistic locking enables you to update records safely without compromising your application's speed
 |
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.
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
Administrators and Developers
FairCom DB now supports Linux Pacemaker to help yo scale your application while maintaining high quality disaster recovery
 |
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.
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
Administrators and Developers
Plugin management
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.
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
Administrators
Read only servers
 |
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.
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
Developers and Administrators
recycle bin
 |
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.
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
Administrators
SYS LOG exclude sql user
FairCom has implemented UNICODE server support for UTF-8.
FairCom DB 13.0.0
Developers
D1026