Appendix A: Distribution Database Schema

Statistics table

The rpl_statistics table stores information about ASE Replicator statistics.

Table A-16 lists the columns in the rpl_statistics table.

**Table A-16: Statistics table**
Column name	Datatype	Description
type	varchar(3)	Type of entity the statistic applies to
name	varchar(128)	Name of the entity
tstamp	datetime	Time stamp when the statistic value was generated
statistic	varchar(128)	Name of the statistic
value	varchar(255)	Value of the statistic

Each row in the rpl_statistics table identifies the value of a single statistic.

New rows are added to the rpl_statistics table when statistics are generated. Statistics are generated automatically at the time interval specified by the stat_write_timeout configuration parameter.

Rows are truncated from the rpl_statistics table automatically at the time interval specified by the stat_trunc_interval configuration parameter.

View this book as PDF