More ISAM utilities

ctclntrn and cthghtrn - Manage Transaction Mark Numbers

The following utilities are provided in FairCom RTG/ISAM:

  • ctclntrn - “Cleans” the high-water transactions marks within a FairCom DB index.
  • cthghtrn - Displays the high-water transaction marks within an index file. This utility would typically be used when the FairCom Server transaction mark number gets too large

These utilities appear in the tools\cmdline folder.

For complete descriptions of these utilities, see the Command-Line Tools book on the FairCom website.

ct_tpc and cttpca TPC A Test

ct_tpc

This is a C++ code sample program implementing the TPC (Transaction Processing Council) A test using the FairCom DB ISAM, FairCom DB API (CTDB), and ODBC APIs. You can execute the same test set using any combination of these three APIs. (The version included with FairCom RTG/ISAM supports that interface as a fourth API.)

This utility is perfect for benchmarking across computer systems, or for comparing the performance of these FairCom DB APIs.

For full usage information, simply execute the utility without any parameters.

See cttpca for a C code version.

cttpca

This is a C code sample program implementing the TPC (Transaction Processing Council) A test using the FairCom DB ISAM, FairCom DB API (CTDB), and ODBC APIs. You can execute the same test set using any combination of these APIs. (The version included with FairCom RTG/ISAM supports that interface as a fourth API.)

This utility is perfect for benchmarking across computer systems, or for comparing the performance of these FairCom DB APIs.

For full usage information, simply execute the utility without any parameters.

See ct_tpc for a C++ code version.

Note: This program is considered legacy, in favor of the more advanced ct_tpc version.

Additional FairCom RTG/ISAM Command-Line Tools

These command-line tools are available in FairCom RTG/ISAM V3:

  • ctidmp - Lists the contents of a dynamic dump file or a specific extent of a dump broken into multiple files.
  • ctpass - Allows users to change their password.
  • ctsysm - Monitors error, warning, and informational messages logged to the server status log, CTSTATUS.FCS. Allows monitoring by an automated external process, such as the Tivoli monitoring system from IBM.
  • cttrap - Plays back a TRAP_COMM log file.
  • ctclntrn - “Cleans” the high-water transactions marks within a FairCom DB index.
  • cthghtrn - Displays the high-water transaction marks within an index file. This utility would typically be used when the FairCom Server transaction mark number gets too large.
  • The ctinfo utility is now included in the FairCom ISAM package. This utility retrieves IFIL and DODA structures from a FairCom DB file (and other header information).

For detailed information, see the Command-Line Tools guide on the FairCom website.

FPUTFGET Library

A multi-user standalone DLL / shared library (FPUTFGET) is now included with FairCom ISAM. This mode supports the Standalone Multi-User Model, described in the FairCom DB Programmer's Reference Guide. This library exports the BTRCALL and BTRCALLID functions. It is located in the following directory:

FairCom\Vx.x.x.RTG\win32\Driver\ctree.ISAM\ctreestd.dll

startserver and stopserver Scripts

Scripts have been added to the FairCom RTG product to start and stop the server. These scripts, startserver and stopserver, are equivalent to the FairCom DB scripts Unix sh (shell) scripts named startace and stopace.

Additional FairCom RTG/ISAM Command-Line Tools

These command-line tools are available in FairCom RTG/ISAM V3:

  • ctidmp - Lists the contents of a dynamic dump file or a specific extent of a dump broken into multiple files.
  • ctpass - Allows users to change their password.
  • ctsysm - Monitors error, warning, and informational messages logged to the server status log, CTSTATUS.FCS. Allows monitoring by an automated external process, such as the Tivoli monitoring system from IBM.
  • cttrap - Plays back a TRAP_COMM log file.
  • ctclntrn - “Cleans” the high-water transactions marks within a FairCom DB index.
  • cthghtrn - Displays the high-water transaction marks within an index file. This utility would typically be used when the FairCom Server transaction mark number gets too large.
  • The ctinfo utility is now included in the FairCom ISAM package. This utility retrieves IFIL and DODA structures from a FairCom DB file (and other header information).

For detailed information, see the Command-Line Tools guide on the FairCom website.