Product Documentation

c-treeRTG V3 Update Guide

Previous Topic

Next Topic

Upgrade Steps

Your existing c-treeRTG 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.

Compatibility Note: c-treeRTG features a new, streamlined folder structure. This change results in a new location for the server and other c-treeRTG components such as the utilities. Any existing scripts that rely on these locations will need to be updated. For more, see New c-treeRTG footprint.

Upgrade to the Latest c-treeRTG V3 Database Engine

While FairCom attempts to maintain backward compatibility when at all possible, transaction logs from earlier versions are not always compatible with newer c-treeRTG formats. For example, c-treeRTG V3 is built upon the latest FairCom Server, which introduces changes in the transaction log to accommodate new capabilities. Since backward compatibility is affected with this upgrade, then all of the steps in the following upgrade procedure are required.

Note: Existing data and index files are not affected by this update.

It is easy to install and use c-treeRTG 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 this list of existing transaction logs and associated files (L*.FCS, S*.FCS, D*.FCS, and I*.FCS).
  7. Copy your new FairCom Server executable (faircom.exe) and any companion .dll (.so on Linux / Unix) into the existing server directory. Be careful not to overwrite any of your configuration files (*.cfg and *.conf) and your FAIRCOM.FCS file.

    Note: It is always advisable to use the most recent matching client version and utilities with your c-treeRTG server version. By updating the client as well as the server you will be able to leverage the new capabilities that otherwise would not be available

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

c-treeRTG Component Upgrade

You need to use the new c-treeRTG driver included with this release. For ACCUCOBOL users, this also means compiling a new ctreeacu.c module. Refer to this location if you need a refresher for how to do this. See the setup section for your compiler in the c-treeRTG User's Guide for details.

SQL Driver Upgrades

c-treeRTG 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 uninstall the existing driver, and then run the new Driver Installation program provided by FairCom. If no standalone driver is provided for your driver, then copy in the new libraries provided in this c-treeRTG package.

In This Section

New c-treeRTG Footprint & Upgrade

Ports

V12 Changes

Support Opening More Than 32,767 Files Affects Compatibility

TOCIndex