Product Documentation

FairCom RTG COBOL Edition User's Guide

Previous Topic

Next Topic

Upgrade files to new RTG 5 attribute resource format

FairCom RTG introduced an extended resource format allowing nearly all FairCom Database features to be applied to RTG tables. These features include the JSON DB API, dbNotify, partitioned files and hot alter table. To take full advantage of these new features it is necessary to upgrade existing RTG (V1 or prior) tables to this new schema format.

Once updated to the new format, these files are no longer compatible with RTG V1 or prior versions.

How to do it

You can obtain the current RTG resource version from a table using ctutil -info. Look for “RTG resources” output:

RTG resources : RTGIv1

Be sure to only use the version of ctutil included in your current RTG distribution, or you may get no output.

To upgrade to the latest RTG resource version, use the following command:

ctutil -upgrade <table> -ctattr

To confirm a successful upgrade, examine the ctutil -info output from that table and ensure RTG version 2 information is displayed:

RTG resources : RTGIv2

Upgrade tables with new table attributes

ctutil can also be used to add permanent features such as data compression, encryption, and the hot alter table support (flexrec) mode for future application schema revisions. Any options enabled in ctree.conf are applied during this upgrade:

ctutil -upgrade <table> <newtable>

TOCIndex