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 PW_SYDN_DATABASE_NAMES_N. |
| RSRO_FULL_OBJECT_ID | Name of the object, normalized in table PW_SYKN_LOCKED_OBJECT_NAMES_N. |
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_SYDN_DATABASE_NAMES_N. |
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. |