rs_ticket is now on its version 2 and provides support for non-ASE databases. You can use rs_ticket stored procedure without additional configuration and administration. Tickets are automatically inserted into the rs_ticket_history table, which is located in the replicate database. Tickets are sharable among multiple applications, where they are issued without obstruction from tickets of other applications.
With rs_ticket version 2, more ticket information is provided for better usability, such as the Replication Server Interface (RSI) timestamp, which you can retrieve without writing complex queries. You can directly query the rs_ticket_history table for Replication Server performance. If the computer time or tickets are not synchronized across multiple time zones, you can change the timestamp columns to adjust the ticket date.
The earlier version of rs_ticket has been renamed rs_ticket_v1. To use the earlier version, alter rs_ticket_report function string with your old content or with the default, exec rs_ticket_report ?rs_ticket_param!param?.
If you previously disabled dsi_rs_ticket_report and
upgraded to Replication Server 15.1, the dsi_rs_ticket_report setting
is reenabled after the upgrade process has finished.
These are the format changes that have been made to rs_ticket:
Changed version number to 2, V=2; if a ticket has version number equal to 1, Replication Server does not write date to tickets.
The ticket size has been increased from 255 to 1024 bytes.
The timestamp format has been changed to include the date. The new timestamp format is mm/dd/yy hh:mm:ss:mmm.
A Replication Server Interface (RSI) module timestamp that forces the RSI sender to parse RSI messages has been added. Tickets pass more than one RSI modules. However, the rs_ticket_history table keeps only the last RSI timestamp.
Primary and target Replication Server names have been added to identify where a ticket comes from and where it goes to.
Primary and replicate database names have been added.
Two DSI counters have been added:
DSI_T=xxx – total transactions that the Data Server Interface (DSI) reads.
DSI_C=xxx – total commands that the DSI reads.
See the Replication Server Reference Manual for detailed information about using rs_ticket version 2.
