Function call Times by File Example

The c-treeACE Server SNAPSHOT function supports a mode that writes function timings for all files open by the c-treeACE Server to disk. Use the ctstat utility’s -funcfile option to output these timing statistics for all open files to SNAPFUNC.FCS in either a comma-delimited format, or a human readable format:

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,GTEVREC,GTEVREC,GETSEG,GETSEG,GETMAP,GETMAP,GTEREC,GTEREC,ADDVREC,ADDVREC,GETDODAX,GETDODAX

count,time,count,time,count,time,count,time,count,time,count,time,count,time,count,time,count,time,count,time,count,time,filename

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 c-treeACE SQL clients.