Product Documentation

Database Integrity Utilities

Previous Topic

Next Topic

Admin-User Report -vau

The admin-user report, -vau user..., displays FairCom DB Server statistics for the specified users. All existing connections whose user ID match the specified user ID are displayed.

Example

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

ctstat -vau GUEST -u ADMIN -p ADMIN -s FAIRCOMS -h 10

log function sec fil lok l%h %m dlock tid/uid/nodename

7s TRANEND 0 2 1 98 2 0 GUEST/10/

7s ADDREC 0 2 2 98 2 0 GUEST/12/

7s ADDREC 0 2 1 98 2 0 GUEST/13/

7s ADDREC 0 2 0 98 2 0 GUEST/14/

0s ctSNAPSHOT 0 2 0 0 0 0 ADMIN/15/ctstat

7s ADDREC 0 2 0 98 2 0 GUEST/17/

The columns shown in this report are described as follows:

log Total logon time for client

function Function client is currently executing

sec Current function request time

fil Current number of files open by this client

lok Current number of locks held by this client

l%h Lock hit rate for this client

%m Lock miss rate for this client

dlock Number of deadlocks detected for this client

tid/uid/nodename Server thread ID/User ID/Node name for this client

TOCIndex