Transmission of data between Sybase's ASA and ASE databases through SQL remote often encounters errors in the transmission log point.
First, through the translation of the log, and against the ASA, ASE Transmission log, determine the correct ASA send point
1, in ASA through Sa_setremoteuser stored procedures, change the Sysremoteuser table Log_sent, confirm_sent fields, other fields to retain the original values in the Sysremoteuser table
2, the following is the Sa_setremoteuser function and its parameters:
Sa_setremoteuser (p_user_id unsigned integer,p_log_sent numeric (), p_confirm_sent Numeric (), P_send_count Integer, P_resend_count integer,p_log_received Numeric (m), p_confirm_received Numeric (m), P_receive_count Integer,p_ Rereceive_count integer)
3, the Sa_setremoteuser parameter and table Sysremoteuser field value correspondence relation
Parameter fields
p_user_id user_id
P_log_sent log_sent
P_confirm_sent confirm_sent
P_send_count Send_count
P_resend_count Resend_count
P_log_received log_received
P_confirm_received confirm_received
P_receive_count Receive_count
P_rereceive_count Rereceive_count
4, ASA Sysremoteuser table and ASE Sr_remoteuser table of the corresponding relationship, but some of the values on either side of the field will not be exactly the same, for example: there can be ASA in the data transfer, but ASE has not done data transmission, at this time ASA Log_ Sent may be greater than ASE's log_received
ASA Sysremoteuser ASE Sr_remoteuser
Log_sent log_received
Confirm_sent confirm_received
Send_count Receive_count
Resend_count Rereceive_count
Log_received log_sent
Confirm_received confirm_sent
Receive_count Send_count
Rereceive_count Resend_count