The FairCom DB Server SNAPSHOT function supports a mode that writes function timings for all files open by the FairCom DB Server to disk. Use the ctstat utility’s -funcfile option to output these timing statistics for all open files to SNAPFUNC.FCS (output to the data folder) in either a comma-delimited format (adding the csv option), or a human readable format shown below:
CSV Example
# ctstat -funcfile csv -i 1 1
SNAPFUNC.FCS Contents
On-Demand Function Snapshot
Tue Jun 26 13:22:40 2007
DELVREC,DELVREC,ADDREC,ADDREC,RWTREC,RWTREC,GETALTSEQ,GETALTSEQ,SETDEFBLKX,SETDEFBLKX, ...
count,time,count,time,count,time,count,time,count,time,count,time,count,time,count,time,...
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,I0000001.FCS
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,D0000000.FCS
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,FAIRCOM.FCS
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,FAIRCOM.FCS!USER.dat
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,FAIRCOM.FCS!USER.idx
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,FAIRCOM.FCS!GROUP.dat
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,FAIRCOM.FCS!GROUP.idx
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,FAIRCOM.FCS!UG.dat
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,FAIRCOM.FCS!UG.idx
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,FAIRCOM.FCS!UG.idx M#01
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,FAIRCOM.FCS!UVAL.dat
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,FAIRCOM.FCS!UVAL.idx
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,SYSLOGIX.FCS
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,SYSLOGDT.FCS
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,SYSLOGIX.FCS M#01
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,SYSLOGIX.FCS M#02
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,D0000001.FCS
0,0,590737,502096,698884,347088,0,0,2,0,0,0,0,0,5,0,0,0,0,0,20,0,mark.dat
0,0,0,0,0,0,5,0,0,0,0,0,5,0,0,0,322988,136944,0,0,0,0,mark.idx
0,0,0,0,0,0,5,0,0,0,0,0,5,0,0,0,376483,171571,0,0,0,0,mark.idx M#01
0,0,0,0,0,0,5,0,0,0,0,0,5,0,0,0,0,0,0,0,0,0,mark.idx M#02
====================
Human-readable Example
# ctstat -funcfile -i 1 1
SNAPFUNC.FCS Contents
On-Demand Function Snapshot
Wed Jun 27 15:26:06 2007
ADDREC RWTREC GTEREC
count time count time count time filename
0 0 0 0 0 0 I0000001.FCS
0 0 0 0 0 0 D0000000.FCS
0 0 0 0 0 0 FAIRCOM.FCS
0 0 0 0 0 0
0 0 0 0 0 0 FAIRCOM.FCS!USER.dat
0 0 0 0 0 0 FAIRCOM.FCS!USER.idx
0 0 0 0 0 0 FAIRCOM.FCS!GROUP.dat
0 0 0 0 0 0 FAIRCOM.FCS!GROUP.idx
0 0 0 0 0 0 FAIRCOM.FCS!UG.dat
0 0 0 0 0 0 FAIRCOM.FCS!UG.idx
0 0 0 0 0 0 FAIRCOM.FCS!UG.idx M#01
0 0 0 0 0 0 FAIRCOM.FCS!UVAL.dat
0 0 0 0 0 0 FAIRCOM.FCS!UVAL.idx
0 0 0 0 0 0 SYSLOGIX.FCS
0 0 0 0 0 0 SYSLOGDT.FCS
0 0 0 0 0 0 SYSLOGIX.FCS M#01
0 0 0 0 0 0 SYSLOGIX.FCS M#02
0 0 0 0 0 0 D0000001.FCS
9910 74592 1380 10993 0 0 mark.dat
0 0 0 0 1381 67772 mark.idx
0 0 0 0 0 0 mark.idx M#01
0 0 0 0 0 0 mark.idx M#02
====================
Function Timing Limitations