Product Documentation

Database Administrator's Guide

Previous Topic

Next Topic

Function Call Times by File -funcfile

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

  • The function timings for a file are reset to zero when the file is physically closed.
  • As currently implemented, the c-tree function timings do not track c-tree API function calls made by FairCom DB SQL clients.

TOCIndex