Sybase SQL remote Change the way to transfer a breakpoint

Source: Internet
Author: User
Tags numeric log sybase

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.