Product Documentation

FairCom RTG COBOL User Guide

Previous Topic

Next Topic

Performance Monitoring with ctstat

The performance of FairCom RTG can be monitored using the FairCom DB Statistics Utility, ctstat. This utility displays statistics collected by the FairCom DB server and provides valuable real time monitoring of critical FairCom DB operations.

The ctstat -func option displays the Function Timing Report, which shows the statistics for each c-tree function that a client has called at least once since the time the server started. You can learn more about this utility in the monitoring sections of the FairCom DB Server Administrator Guide, Function Timing Report Example.

This information is also available in the Function Timing tab of the FairCom DB Monitor.

Using this report, you can profile FairCom RTG operation to see where the system is spending the most time. This information can provide insight into the efficiency of your application. For example, an application that opens and closes a file for every read might be made more efficient if it keeps the file open during a long series of reads, assuming other considerations allow this (e.g., does the file need to be closed between reads for other reasons). In this example, performance may improve using the FairCom DB KEEPOPEN configuration option. See Troubleshooting Performance for more tips.

The FairCom RTG driver uses a number of custom functions that can be seen when using ctstat -func. To help you better understand this report, the list below describes the COBOL operations that map to these functions and what they accomplish:

  • RTG_MAKE - create file
  • RTG_OPEN - open file
  • RTG_CLOSE - close file
  • RTG_WRITE - add record
  • RTG_READ - random read record
  • RTG_START - position record
  • RTG_NEXTPREV - sequential read record
  • RTG_REWDEL - rewrite or delete record
  • RTG_DELETE - delete records
  • RTG_UNLOCK - unlock record
  • RTG_VERSION - get server version
  • RTG_SQLINFO - get or set SQL information
  • RTG_SQLLINK - link or unlink file to SQL dictionaries
  • RTG_COPY - copy file
  • RTG_INFO - get file information
  • RTG_ADDIDX - add index to file

TOCIndex