Detailed Field Information Related Information Examples & Tutorials
Want new features? Check out the news on the latest version of Collect! available. Members can download new enhancements FREE! Interested in new features available but not currently on a Membership? Please contact us for pricing. Enhancements may be purchased separately.
“ Your claims and promises have been truthful and upfront. That makes doing business with you a pleasure. ” Paul S.

RDM Server Statistics

The RDM Server Statistics form displays all statistics gathered from a call to gather statistics from the CV11 Server. You can refresh the statistics by selecting the REFRESH button. When the statistics are refreshed, all accumulated statistics are totaled.

This diagnostic tool enables system technicians to benchmark CV11 Server and Extension Module performance. This is meant to help troubleshoot server related issues.

tip.gif These statistics are primarily to enable the Collect! Technical Services Team to more quickly pinpoint issues related to the CV11 Server and Extension Module.

The RDM Server Statistics form may be accessed through the System, Diagnostics menu. Select Db Statistics to open the form.

A complete list of the defined server constants appears below. These constants contain the index into the array of longs returned from s_statistics. All values are totals and do not show current values. For example, the value returned in the LOGINS field represents the total number of user logins that have occurred since the server was started, not the current number of active users. To obtain the current number, subtract the total of LOGOUTS from LOGINS.

Page Zero Read

Total number of times RDM Server performed a page zero read from a database file.

Top of page.

Page Zero Write

Total number of times RDM Server performed a page zero write to a database file.

Top of page.

Open Db Tables

Total number of times a database open required a database dictionary read from disk.

Top of page.

Close Db Tables

Total number of times a database dictionary was removed from memory. This counter is incremented when all users of the database have called d_close and the table can be removed from RDM Server memory.

Top of page.

Open Db

Total number of times RDM Server performed a database open.

Top of page.

Close Db

Total number of times RDM Server performed a database close.

Top of page.

Group Lock Request

Total number of lock requests RDM Server serviced. This counter is incremented when RDM Server receives a lock request, whether it was granted, blocked, timed out, or an RDM Server error occurred.

Top of page.

Group Lock Blocked

Total number of lock requests blocked because of an incompatible lock.

Top of page.

Group Lock Timeout

Total number of times a lock timed out because of an incompatible lock.

Top of page.

Instance Read Locks

Total number of times an instance read lock is granted.

Top of page.

Table Read Locks

Total number of times a table read lock is granted.

Top of page.

Instance Write Locks

Total number of times an instance write lock is granted.

Top of page.

Table Write Locks

Total number of times a table write lock is granted.

Top of page.

Freed Locks

Total number of successful requests to free instance and table locks.

Top of page.

Transaction Begins

Total number of times a database transaction began. This counter is incremented after every successful d_trbegin call to an open database.

Top of page.

Transaction Ends

Total number of times a database transaction ended. This counter is incremented after every successful d_trend call to an open database.

Top of page.

Transaction Aborts

Total number of times a transaction aborted. This counter is incremented after a transaction was aborted by a d_trabort call on an open database.

Top of page.

Change Log Write

Total number of times the change log is updated. This counter is incremented when a transaction is written to a change log on disk.

Top of page.

Change Logs

Total number of change logs created. This counter is incremented when RDM Server creates multiple change log cycles.

Top of page.

Change Logs Bytes Write

Total number of bytes written to change logs. This counter is increased by the size of each write and is only incremented each time CHANGE LOG WRITE is increased.

Top of page.

Open Change Log

Total number of times the change log is opened. This counter is incremented each time RDM Server opens the change log file.

Top of page.

Close Change Log

Total number of times the change log file is closed. This counter is incremented each time RDM Server closes the change log file.

Top of page.

Transaction Rollbacks

Total number of transaction rollbacks. This counter is incremented after a call to d_trrollback is successful on an open database.

Top of page.

Checkpoints

Total number of cache checkpoints. See Chapter 3 of the RDM Server User's Guide for information on checkpoint processing.

Top of page.

Piggybacks

Total number of times a contiguous block writes to a database file during a checkpoint. This is a measure of the fragmentation of the checkpoint writes. Higher values mean less fragmentation.

Top of page.

Server Rpc Total

Total number of client RPC calls serviced by the server.

Top of page.

Logins

Total number of times the server processed a login.

Top of page.

Logouts

Total number of times the server processed a logout. This counter is increased when a successful client logout is serviced by RDM Server.

Top of page.

Client Aborts

Total number of times RDM Server aborted a client session. For every session abort, a logout will be automatically performed by RDM Server, hence the LOGOUTS total is also incremented.

Top of page.

Requests

Total number of d_ function calls. This counter is increased each time a d_ function call is made to RDM Server by a client or by an RDM Server extension module.

Top of page.

Db Function Calls

Total number of d_ function calls. This counter is increased each time a d_ function call is made to RDM Server by a client or by an RDM Server extension module.

Top of page.

Db Errors

Total number of database errors. This counter is increased each time a database error occurs.

Top of page.

Normal Requests

Total number of normal RPC requests. This counter is increased each time RDM Server receives a normal RPC request that is serviced by a normal RDM Server thread.

Top of page.

Pri Requests

Total number of priority RPC requests. This counter is increased each time RDM Server receives a priority RPC request that is serviced by a priority RDM Server thread.

Top of page.

Refresh

Select this to refresh the statistics gathered from the CV11 Server.

Top of page.

OK

Select this to close the RDM Server Statistics form.

Top of page.

See Also

- Database Topics

Top of page.

Was this page helpful? Do you have any comments on this document? Can we make it better? If so how may we improve this page.

Please click this link to send us your comments: helpinfo@collect.org

Collection Advisor Veracode Verified RMA ACA Member