Product Documentation

Database Administrator's Guide

Previous Topic

Next Topic

I/O Statistics per File -file

The FairCom DB Server SNAPSHOT feature supports a mode to write snapshot statistics for all files open by the FairCom DB Server to disk. Use the ctstat utility’s -file option. The snapshot statistics for all open files are then written to the SNAPFILE.FCS file in comma-delimited or human-readable format.

CSV Example

Write statistics for all open files to SNAPFILE.FCS in comma-delimited format using the ctstat utility:

# ctstat -file csv -i 1 1

Sample SNAPFILE.FCS Contents

On-Demand File Snapshot

Mon Jun 25 16:40:51 2007

physical file size,logical file size,serial number,active entries,tran high mark,update timestamp,max file size,read ops,bytes read,write ops,bytes written,memory file high bytes,read time (msec.),write time (msec.),index height,file id,server id,time id,node size,record length,permanent file mode,max leaf key bytes,max non-leaf key bytes,file type,key length,key member number,number of members, super file type,max leaf marks,wrthdr sequence number,total lock attempts,header lock attempts,total lock wait count,header lock wait count,deadlocks,total locks denied,total locks freed,total blocks released,current locks held,current blocked requests,max special cache pages,current special cache pages,number of buffer pages,number of data cache pages,number of channels,number of users with file open,current memory record count,highest memory record count,killed locks,max segments,active segments,update flag,file type,duplicate key flag,index delete type,key padding byte,flavor,alignment,pointer size,file name

16384,16384,0,15,0,0,0,0,0,5,16768,0,0,0,-1,0x00000000,0x00000000,0x00000000,8192,0,0x00000000,8148,8174,1,12,0,0,0,2048,3,44,23,0,0,0,0,44,0,0,0,0,0,0,0,1,1,0,0,0,1,0,0xff,0,0,0,32,2,8,4,I0000001.FCS

====================

Human Readable Example

Write statistics for all open files to SNAPFILE.FCS in human-readable format using the ctstat utility:

# ctstat -file -i 1 1

Sample SNAPFILE.FCS Contents

On-Demand File Snapshot

Tue Jun 26 09:58:28 2007

phyrec numrec sernum nument hghtrn tstamp mxfilz fredops fredbyt fwrtopts fwrtbyt mhghbyt fredtim fwrttim idxhgt fileid servid timeid nodsiz reclen logtyp maxkbl maxkbn filtyp keylen kmem nmem suptyp maxmrk hdrseq floktry flokhlk flokblk flokhbk flokdlk flokdny flokfre flokrel flokcur fblkcur datlmt datspl bufcnt datcnt numchn fusrcnt memcnt hghcnt flokkil segmax seglst updflg ktype autodup deltyp keypad flflvr flalgn flpntr filename

16384 16384 0 15 0 0 0 1 8192 10 57728 0 0 0 -1 0x00000000 0x00000000 0x00000000 8192 0 0x00000000 8148 8174 1 12 0 0 0 2048 3 68 35 0 0 0 0 68 0 0 0 0 0 0 0 1 1 0 0 0 1 0 0xff 0 0 0 32 2 8 4 I0000001.FCS

====================

TOCIndex