Knowledgebase

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

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 WRITETHRU Files Large File Support Memory Files Partitioned Files File Mirroring Summary of FairCom DB Features