FairCom RTG introduced an extended resource format allowing nearly all FairCom Database features to be applied to RTG tables including 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>