Product Documentation

Database Administrator's Guide

Previous Topic

Next Topic

Admin-System Report -vas

The admin-system (-vas) report displays FairCom DB Server system-wide statistics in the areas of cache usage, disk I/O, open files, established client connections, file locks, and transactions.

Example

Below is a sample admin-system report produced by executing the command:

ctstat -vas -u ADMIN -p ADMIN -s FAIRCOMS -h 10 -i 2

 

cache

 

disk i/o

files

connect

 

locks

transactions

d%h

%m

i%h

%m

r/s

w/s

cur/max

cur/max

cur

l%h

%m

dead

act

t/s

r/t

w/t

99

1

99

1

1

1

2581/10000

2/128

0

100

0

0

1

36

0

0

99

1

99

1

2

0

2581/10000

2/128

0

100

0

0

1

35

0

0

99

1

99

1

2

0

2581/10000

2/128

0

100

0

0

1

28

0

0

99

1

99

1

0

0

2581/10000

2/128

0

100

0

0

1

22

0

0

The columns shown in this report are described as follows:

d%h Data cache hit rate

%m Data cache miss rate [100 - Data cache hit rate]

i%h Index cache hit rate

%m Index cache miss rate [100 - Index cache hit rate]

r/s Disk reads per second

w/s Disk writes per second

cur Current number of open files

max Server limit on number of open files

cur Current number of client connections

max Server limit on number of client connections

cur Number of locks currently held

l%h Lock hit rate [(lock attempts - locks blocked - locks denied) / lock

attempts]

%m Lock miss rate [100 - Lock hit rate]

dead Number of dead locks detected

act Current number of active transactions

t/s Number of transactions per second

r/t Number of read operations per transaction

w/t Number of write operations per transaction

log save Avg log save time per interval (microseconds) when used with the delta (-d) option

TOCIndex