PW_RSRS_REP_SERVER_STATS_T
Replication server statistics.
| Column Name | Column Description |
|---|---|
RSRS_PWII_INSTANCE_ID | ID of the Replication Server instance. |
RSRS_TIMESTAMP | Date and time the statistic was sampled. |
RSRS_ASE_INST_ID | ID of the Sybase ASE instance. |
RSRS_DATABASE_ID | Name of the database, normalized in table PW_SYDN_DATABASE_NAMES_N. |
RSRS_PWHG_ID | Hour group ID. |
RSRS_MINUTES_COUNT_SUM | The timeframe needed to calculated the row, in minutes. |
RSRS_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
RSRS_DSIE_CMDS_SUCCEED_SUM | Commands successfully applied to the target database by a DSI/E. |
RSRS_DSIE_FS_MAP_TIME_SUM | Time, in seconds, to perform function string mapping on commands in DSI/E. |
RSRS_DSIE_BATCH_TIME_SUM | Time, in seconds, to process command batches submitted by a DSI. |
RSRS_DSIE_SEND_TIME_SUM | Time, in seconds, spent in sending command buffers to the RDS. |
RSRS_DSIE_SEND_RPC_TIME_SUM | Time, in 100ths of a second, spent in sending RPCs to the RDS. |
RSRS_DSIE_SEND_DT_TIME_SUM | Time, in 100ths of a second, spent in sending chunks of text or image data to the RDS. |
RSRS_DSIE_RESULT_TIME_SUM | Time, in seconds, to process the results of command batches submitted by a DSI. |
RSRS_DSIE_SCC_TIME_SUM | Time, in seconds, to check the sequencing on commits. |
RSRS_DSIE_SCB_TIME_SUM | Time, in seconds, to check the sequencing on command batches which require some kind of synchronization, such as wait_for_commit. |
RSRS_DSIE_TRAN_TIME_SUM | Time, in seconds, to process transactions by a DSI/E thread. This includes function string mapping, sending, and processing results. A transaction may span command batches. |
RSRS_DSIE_TRAN_EXEC_SUM | Time net, in seconds, to execute transactions by a DSI/E thread. This is computed by deducting the time for function string mapping, sending, and processing the result from the Total Transaction Time. |
RSRS_DSIE_CMDS_READ_SUM | Total DSI commands read. |
RSRS_REPAGENT_BYTES_RCVD_SUM | Total commands sent. |
RSRS_SQM_CMDS_WRITTEN_SUM | Total SQM commands written. |
RSRS_SQMR_BLCK_READ_CCHD_SUM | Total SQMR blocks read. |
RSRS_SQMR_CMDS_READ_SUM | Total SQMR commands read. |
RSRS_SQT_TRANS_REMOVED_SUM | Transactions removed from cache. |
RSRS_SQT_CACHE_MEM_USED_MAX | Cache memory used. |
RSRS_ROWID | ID of the row. |
PW_RSRO_REPLICATED_OBJECTS
Replicated objects.
| Column Name | Column Description |
|---|---|
RSRO_PWII_INSTANCE_ID | ID of the Replication Server instance. |
RSRO_ASE_INST_ID | ID of the Sybase ASE Instance. |
RSRO_DATABASE_ID | Name of the database, normalized in table |
RSRO_FULL_OBJECT_ID | Name of the object, normalized in table |
PW_RSRD_REPLICATED_DATABASES
Replicated databases.
| Column Name | Column Description |
|---|---|
RSRD_PWII_INSTANCE_ID | ID of the Replication Server instance. |
RSRD_ASE_INST_ID | ID of the Sybase ASE Instance. |
RSRD_DATABASE_ID | Name of the database, normalized in table |
PW_RSRC_REPLICATION_COUNTERS
Replication counters.
| Column Name | Column Description |
|---|---|
RSRC_MODULE_NAME | Module name. |
RSRC_DIRECTION | Internal use only. |
RSRC_COUNTER_NAME | Counter name in Sybase. |
RSRC_COUNTER_VALUE_TYPE | Internal use only. |
RSRC_ACCUMULATIVE | Internal use only. |
RSRC_TABLE_NAME | Name of the table in Precise. |
RSRC_COLUMN_NAME | Internal use only. |
RSRC_COUNTER_DESCRIPTION | Description of the counter. |
RSRC_FROM_VERSION | The Sybase version that starts collecting the current counter. |
RSRC_TILL_VERSION | The Sybase version that versions later than it stops collecting the current counter. |
PW_RSAR_ASE_REP_SERVER
Adaptive Server Enterprise replication server.
| Column Name | Column Description |
|---|---|
RSAR_PWII_INSTANCE_ID | ID of the replication server instance. |
RSAR_ASE_INST_ID | ID of the Sybase ASE Instance. |
RSAR_TYPE | Marks whether this is the last or current counter's value. |
PW_RSRP_REP_PART_INFO_T
Replication server stable partitions.
| Column Name | Column Description |
|---|---|
RSRP_PWII_INSTANCE_ID | ID of the Replication Server instance. |
RSRP_TIMESTAMP | Date and time the statistic was sampled. |
RSRP_ASE_INST_ID | ID of the Sybase ASE Instance. |
RSRP_PWHG_ID | Hour group ID. |
RSRP_MINUTES_COUNT_SUM | The timeframe needed to calculate the row (in minutes). |
RSRP_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
RSRP_PARTITION_PATH | Partition path. |
RSRP_PARTITION_LOGICAL_NAME | Partition name. |
RSRP_TOTAL_SEGMENTS_MAX | Total segments number. |
RSRP_USED_SEGMENTS_MAX | Used segments number. |
RSRP_ROWID | Row ID. |
PW_RSCP_REP_SERVER_CONFIG_T
Replication server configuration.
| Column Name | Column Description |
|---|---|
RSCP_PWII_INSTANCE_ID | ID of the Replication Server instance. |
RSCP_TIMESTAMP | Date and time the statistic was sampled. |
RSCP_PWHG_ID | Hour group ID. |
RSCP_MINUTES_COUNT_SUM | The timeframe needed to calculate the row (in minutes). |
RSCP_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
RSCP_SQT_CACHE_SIZE_MAX | SQT cache size. |
RSCP_ROWID | Row ID. |