This section lists the enhancements and other changes to the FairCom command-line utilities. If you are already familiar with these utilities, be sure to read this section to stay up-to-date with the latest improvements.
ctadmn c-treeACE Server Administration Utility
When reporting the server memory usage, ctadmn now considers the memory dedicated to the cache in the calculation.
For SQL connections, the client activity monitoring option now reports the elapsed time of each request and whether the server is processing a request for that particular client, as well as the function being executed.
ctcmdset Create Encrypted Password File
The ctcmdset utility is used to create an encrypted password file from a text file. An issue was discovered when enabling sequence number support in standalone mode. This issue has now been corrected.
ctcmpcif IFIL-based Compact Utility
Two new command-line options were added to this tool: -redosrl Reassign serial numbers instead of copying the values from the original file.
-x8 Use extended create blocks read from data and index files, which creates new compact index files using the same extended create block settings as the original file. Note that, even without this option, some of the extended create block settings are always applied to the new files (e.g., huge file, extended header, and 6-byte transaction number).
In addition to the new parameters listed above, the utility was enhanced so that segmented files can be compacted.
ctcv67 Extended File Conversion Utility
New command-line options were added to encrypt the file during the conversion, set the large file extension size, and set the temporary directory. In addition, a correction was made to address an issue in which the tool would return “succeed” in certain circumstances when the file was not fully converted.
ctencrypt Utility to Change Master Password
The new ctencrypt utility is used to change the master password. c-treeACE’s advanced encryption
feature uses a master password to encrypt the file-specific advanced encryption key in c-treeACE data, index, and transaction log files. This tool is a standalone utility that can be used to change the master password for specified c-treeACE data, index, and transaction log files.
ctfchk Checksum Utility
The new ctfchk Checksum utility is a standalone c-treeACE utility that reads active records from a fixed-length c-treeACE data file in physical order and outputs a checksum and active record count. It uses the CRC-32 algorithm to compute the checksum. This utility can be used to compare the record contents of two fixed length data files. However, two c-treeACE data files that contain the same active record images in the same order will generate identical checksums. Two c-treeACE data files whose active record contents differ will generate different checksums (subject to the limitations of the CRC-32 algorithm).
ctidmp Examine Dump Files Utility
The ctidmp Examine Dump Files utility was not displaying the contents for files over 4GB. This has been corrected.
ctinfo Incremental ISAM Utility
The ctinfo utility has been updated to display the correct superfile member number. This utility also displays the extended file mode attributes, applicable to partitioned files.
ctitop Utility Creates OTP and Parameter File
A new tool, ctitop, was added to convert a file with embedded IFIL and DODA resources to an OTP file and related parameter file.
ctixmg Updated to Support ctCAMO Encryption
The ctixmg example program now supports the ctCAMO strategy for encryption by default. The former default encryption, AES32, is still supported by use of an additional keyword in the server configuration file (ctsrvr.cfg): ADVANCED_ENCRYPTION. To use the default option for encryption, the keyword is not required.
ctmtap Multi-threaded API Sample
Improvements were made to the ctmtap test program, including a new command-line option. The new option, -X, times calls made to the CTUSERX() function. For example, the command-line option -X(i,o) causes the program to run the CTUSERX() test with input buffer size i and output buffer size o
(in bytes).
ctotoi Utility Adds IFIL and DODA Resources
The new ctotoi utility adds IFIL and DODA resources to a c-treeACE data file based on an OTP file.
ctpathmigr Utility to Change Database Path Separators
The new ctpathmigr utility changes database and IFIL resource path separators when migrating databases between Unix and Windows platforms.
ctquiet Quiesce c-treeACE Utility
The new ctquiet utility was added for quiescing the server through a script file.
ctrbldif IFIL-based Rebuild Utility
The following changes were applied to the ctrbldif utility: Added two new command line options:
-sortmem=<N> Sets sort memory to N KB in standalone builds. Using this option can increase the rebuild speed for large files.
-x8 Use extended create blocks read from data and index files, which is useful for creating rebuilt index files using the same extended create block settings as the original file. Note that, even without this option, some of the extended create block settings are always applied to the new files (e.g., huge file, extended header, and 6-byte transaction number).
Changed default sector size from 16 (page size 2048) to 64 (page size 8192) which is the default setting for c-treeACE Server.
Changed temppath from NULL (which uses the system temp file path) to the current directory. Corrected a situation which, under certain circumstances, could cause the utility to return successful and not rebuild one index.
ctredirect Utility to Change IFIL Filename Information
The new ctredirect utility updates IFIL filenames for redirection to alternate locations. The Redirect feature allows a file originating in one directory structure to be repositioned into another directory location following automatic recovery, dynamic dump restore, or replication. When copying c-treeACE files from one directory location to another (on the same system or on a different system) and
accessing them in their new location, it is necessary to update any filename paths in a c-treeACE data file’s IFIL resource.
ctscmp Superfile Compact Utility
The superfile compact utility, ctscmp, now creates indices with the same distinct key count attribute as the original indices. In addition, this utility has been updated to correctly open files when the resources and the ikeydup attribute in the IFIL resource do not match the keydup field in the index file’s header.
ctsqlimp Utility
The ctsqlimp utility, which allows you to import existing c-tree Plus files into a c-treeACE SQL database, now includes a command line option (-q <prefix>) so you can append a prefix to the name of the table being imported.
ctsqlimp has also been updated to take advantage of the ability to import multiple files with the same physical name into an SQL database. Simply use the -n (symbolic) name option on import to uniquely identify each table in c-treeACE SQL
ctstat Statistics Utility
A new command-line option (-mu) has been added to the cstat utility. This option allows you to unload the module debug symbols using ctstat.
ctstress Perform Record Operations on Files
This sample program performs various database operations for use as a test program. The source has been moved to the ..\sdk\Xtras\ctree.samples\special\utils folder.
cttctx Performance Test Utility
The cttctx utility now supports timing options on x86/x64 Solaris systems.
A new command line option was added to monitor only the elapsed time, and not include the individual call times.
Fixed a problem with the directory creation when running in a heterogeneous environment (Windows/Unix).
Fixed a problem with the command-line option that determines which operations (add, read, delete) it performs. In some cases, the result presented was 0 due to an internal reading error.
cttrap Communications Trap Playback Utility
A correction addressed an issue in which the utility was hanging when it used the Shared Memory Protocol and an error LMTC_ERR (530) happened.
A new option was added for faster reply: -x skip serialization.
cttrnmod Change Transaction Mode Utility
This version of cttrnmod includes an important improvement: If one data file without its indices is required to change the transaction mode, the utility now does the change, and when the file is rebuilt later, the indices will reflect the transaction mode change.
A new command line option was added: -n <sect> This option allows you to specify the sector size (sect) in the standalone mode.
ctunf1 File Format Conversion Utility
It was found that the ctunf1 file conversion utility failed to reverse the bytes of some of the fields in the extended header of a c-treeACE file. The definitions of recently added fields were not added to the conversion map structures used by the ctunf1 utility. These missing fields have been added to ensure a complete conversion.
ctupdpad Pad Resource Utility
The ctupdpad utility, which allows you to change the padding and delimiter characters in the c-treeDB padding resource, has a new option (-n) to set the sect size.
fkverify SQL Foreign Key Constraints Utility
Improved performance in the process by including a WHERE clause to remove NULL keys from consideration.
Utilities Updated for Use with Advanced Encryption
The ctrdmp restore utility and the ctfdmp (forward roll) utility now detect when transaction logs are using advanced encryption and when data or index files that are referenced in the transaction logs use advanced encryption. When the transaction logs use advanced encryption, these utilities prompt for the master password after opening the first transaction log, which is essentially at the beginning of the restore or forward roll process. When data or index files referenced in the logs use advanced encryption, the user is prompted for the master password the first time it finds a reference to a file that uses advanced encryption. This requires the ctsrvr.pvf password file to be created and present. The ctdmpidx dump index utility and ctvfyidx index verify utility now also detect when the index file that is being inspected is encrypted with advanced encryption. In this situation, the utilities turn on c-treeACE’s advanced encryption support and prompt for the master encryption password just as the server would at startup.
Chapter 11