Product Documentation


Previous Topic

Next Topic

Best Practices

This chapter compiles best practices from throughout the FairCom documentation so you have it in a convenient location. Learn the best ways to achieve your goals of performance and data integrity.

In This Chapter

Selecting FairCom DB Features Used in the System

FairCom DB Files to Include for a Successful Backup Strategy

Automatic Recovery

Restrict Access to FairCom DB Server Files

External Third-Party Utilities

Safely Copying FairCom DB Controlled Files

File Rebuilds

Java Requirements for FairCom DB SQL

Better Performance with NXTVREC() vs GTVREC()

8 Steps to a Fast Data Load

Calculating Memory Usage

Controlling Server Memory

Calculating File Storage Space

Calculating Index Sizes

Migrating Data Between Platforms and Operational Models

Migrating Your Application Between Operational Models

SQL Data Load Tips

Previous Topic

Next Topic

Selecting FairCom DB Features Used in the System

FairCom DB supports many options that affect the availability of the server’s data over time and the state of the data in the event of a catastrophic failure. Many of the features discussed in this section can be configured on a file-by-file basis. The system architects and application designers can determine the appropriate features to use for each data and index file based on the role the files play in the system and by understanding the effect of these features on availability and recovery of the data.

In This Section

Data and Index Caching Options

Transaction-Controlled Files

Non-Transaction Files


Large File Support

Memory Files

Partitioned Files

File Mirroring

Summary of FairCom DB Features