Product Documentation

FairCom RTG V2 Update Guide

Previous Topic

Next Topic

FairCom RTG V2 Quick Guide to Upgrade Procedures

Your FairCom RTG system can be upgraded to the latest version with very few changes. It is important to follow the procedures in this section to upgrade in a safe manner.

Upgrade to the latest FairCom RTG V2 Database Engine

While FairCom attempts to maintain backward compatibility when at all possible, transaction logs from earlier versions are not always compatible with newer FairCom RTG formats. For example, FairCom RTG V2 is built upon the latest FairCom Server (V11), which introduced changes in the transaction log to accommodate new capabilities. When backward compatibility is affected, then all of the steps in the following upgrade procedure are required. In cases where no backward compatibility exists, then steps 3 through 6 can be considered optional.

Note: Unless otherwise mentioned in the version-specific Update Guides, existing data and index files are usually not affected by transaction log changes.

It is easy to install and use FairCom RTG with your existing files by removing prior transaction logs in a safe manner. Follow these easy steps, which are appropriate any time you are upgrading a c-tree installation:

  1. Have all clients cleanly exit from the existing the c-tree Server.
  2. Perform a controlled shutdown of the c-tree Server with your normal shutdown sequence. Verify the c-tree Server shutdown was successful by looking for the following "Server shutdown completed" in CTSTATUS.FCS:

    - User# 00023 Server shutdown completed

  3. Block the ability of any clients to attach to the c-tree Server.
  4. Restart your existing c-tree Server with no clients attached and allow a successful automatic recovery to take place. This ensures all files are brought to a consistent state in the event there is any data remaining in the transaction logs.
  5. Perform another normal controlled shutdown of your existing c-tree Server.
  6. Remove existing transaction logs and associated files (L*.FCS, S*.FCS, D*.FCS, and I*.FCS).
  7. Copy your new FairCom Server executable (ctsrvr.exe or ctreesql.exe) into the existing c-tree Server directory.

    Note: Client compatibility can prevent connections to the new FairCom RTG database engine. It is always advised to use the most recent matching client version with your FairCom RTG server version. Version 11 of the FairCom Server introduced backward compatibility changes that affect FairCom RTG.

  8. Unblock the ability of any clients to attach.
  9. Start c-treeACE in your usual manner and begin accessing your existing data.
  10. Optional - for SQL users: Sqlize your tables using the sqlize utility or ctutil -link. The V2/V11 version of c-treeACE SQL Explorer provides new features, such as highlighting sqlized tables in different colors, checking for bad records, and adding SQL indexes (see c-treeACE SQL Explorer). If you want to use these features, you will need to sqlize after upgrading to FairCom RTG V2 even if you have sqlized in an earlier version of FairCom RTG.

For more information, see the Knowledgebase in the online documentation.

FairCom RTG Component Upgrade

You may need to recompile existing runtimes. Although recompiling it is not strictly necessary, it is recommended. See the setup section for your compiler in the FairCom RTG User's Guide for details.

SQL Driver Upgrades

FairCom RTG includes a collection of SQL drivers to allow relational access through a variety of interfaces:

  • JDBC drivers
  • ODBC drivers
  • PHP modules
  • ADO.NET drivers
  • Stored Procedure frameworks

To upgrade the drivers, simply run the FairCom RTG installation program again. You do not need to uninstall the existing drivers before upgrading.

TOCIndex