FairCom RTG COBOL Edition User's Guide

ctstat - Statistics Utility

The FairCom DB Server Statistics Utility, ctstat, is a client utility used to display statistics collected by the FairCom DB Server. ctstat, provides valuable real time monitoring of critical FairCom DB Server operations.

Usage

# ctstat report_type [-s svn] [-u uid] [-p upw]
[-i int [cnt]] [-h frq] [-d] [-m] [-t] [-mu]

Reports:

-vas	Admin-System Report
-vts	Tivoli-System Report
-vaf file...	Admin-File Report
-vtf file...	Tivoli-File Report
-vau user...	Admin-User Report by User Name
-vau handle...	Admin-User Report by User Handle
-vah handle...	Admin-User Report by Connection Handle
-func	Function Timing Report
-funcfile	Function Timing By File Report
-userinfo	User Report with stats from USERINFO() function
-isam	ISAM Activity Report
-sql	SQL Activity Report
-text	System Activity Report, Write System Snapshot to SNAPSHOT.FCS
-file [csv]	File Activity Report
-iotime on \| off	Turn disk I/O call timing on or off
-wrktime on \| off [reset]	Turn function call timing on or off; reset allows function-timing statistics to be reset

The following memory statistics options require the use of the DIAGNOSTICS MEMTRACK keyword AFAF:

-mf logfile	Log all memory allocations to the specified file
-ma logfile	Log aggregate memory allocations to the specified file
-mr min,max	Log only memory allocations in the range min,max
-ms	Output memory allocation statistics
-mu	Unload module debug symbols

Options:

-s svn	FairCom DB Server name
-u uid	User name
-p upw	User password
-i int [cnt]	Pause int seconds for optional cnt times
-h frq	Print a description header every frq outputs
-d	Show cache stats as delta
-m	Show memory file stats when using -vaf report. The following additional statistics are output: phyrec - Last byte offset of file for non-memory file or current memory in use for memory file. mhghbyt - Largest amount of memory used for memory file since file was created. memcnt - Current number of memory records. hghcnt - Largest number of memory records since file was created.
-t	Output timestamp with header.
-mu	Unload the module debug symbols (can be used if FairCom Support needs you to unload debug symbols, e.g., if the initial load of the symbols failed). Due to performance considerations, do not use debug symbols on a production system unless instructed by FairCom Support.