Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Latency issue

2 posts in General Discussion Last posting was on 2013-02-04 16:37:56.0Z
Jack Posted on 2013-02-04 05:20:00.0Z
Sender: 2710.510f3e04.1804289383@sybase.com
From: Jack
Newsgroups: sybase.public.rep-server
Subject: Latency issue
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <510f4500.2984.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 3 Feb 2013 21:20:00 -0800
X-Trace: forums-1-dub 1359955200 172.20.134.41 (3 Feb 2013 21:20:00 -0800)
X-Original-Trace: 3 Feb 2013 21:20:00 -0800, 172.20.134.41
Lines: 360
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9307
Article PK: 1307439

Hi All,

We have warmstandby setup & every day after EOD run,
Origintime is not moving in rs_lastcommit(RDS).
latency starts draining daily after 11:30 am & it completely
drained out almost 10 hrs latency in an hour and after that
no latency till next EOD, not sure what is an issue.

can anyone come across same situtation, please share.

Thank You

Repserver version:
Replication Server/12.6/EBF 14703 ESD#9

Source & target ASE version:
Adaptive Server Enterprise/12.5.4/EBF 13381

rs_configure result:

Config Name Config Value Run Value
-------------------------- ----------------------
--------------------------
byte_order 256 256
cm_fadeout_time 300 300
cm_max_connections 600 600
current_rssd_version 1260 1260
dsi_commit_check_locks_int 1000 1000
dsi_commit_check_locks_log 200 200
dsi_commit_check_locks_max 400 400
dsi_commit_control on on
dsi_exec_request_sproc on on
dsi_exec_request_sproc on on
dsi_exec_request_sproc on on
dsi_exec_request_sproc on on
dsi_exec_request_sproc on on
dsi_exec_request_sproc on on
dsi_exec_request_sproc on on
dsi_exec_request_sproc on on
dsi_exec_request_sproc on on
dsi_exec_request_sproc on on
dsi_exec_request_sproc on on
dsi_exec_request_sproc on on
dsi_exec_request_sproc on on
dsi_exec_request_sproc on on
dsi_exec_request_sproc on on
dsi_exec_request_sproc on on
dsi_ignore_underscore_name on on
dsi_ignore_underscore_name on on
dsi_ignore_underscore_name on on
dsi_ignore_underscore_name on on
dsi_ignore_underscore_name on on
dsi_ignore_underscore_name on on
dsi_ignore_underscore_name on on
dsi_ignore_underscore_name on on
dsi_ignore_underscore_name on on
dsi_ignore_underscore_name on on
dsi_ignore_underscore_name on on
dsi_ignore_underscore_name on on
dsi_ignore_underscore_name on on
dsi_ignore_underscore_name on on
dsi_ignore_underscore_name on on
dsi_ignore_underscore_name on on
dsi_max_xacts_in_group 20 20
dsi_max_xacts_in_group 60 60
dsi_max_xacts_in_group 60 60
dsi_max_xacts_in_group 60 60
dsi_max_xacts_in_group 60 60
dsi_max_xacts_in_group 60 60
dsi_max_xacts_in_group 60 60
dsi_max_xacts_in_group 60 60
dsi_max_xacts_in_group 60 60
dsi_max_xacts_in_group 60 60
dsi_max_xacts_in_group 60 60
dsi_max_xacts_in_group 60 60
dsi_max_xacts_in_group 60 60
dsi_max_xacts_in_group 60 60
dsi_max_xacts_in_group 60 60
dsi_partitioning_rule none none
dsi_partitioning_rule none none
dsi_partitioning_rule none none
dsi_partitioning_rule none none
dsi_partitioning_rule none none
dsi_partitioning_rule none none
dsi_partitioning_rule none none
dsi_partitioning_rule none none
dsi_partitioning_rule none none
dsi_partitioning_rule none none
dsi_partitioning_rule none none
dsi_partitioning_rule none none
dsi_partitioning_rule none none
dsi_partitioning_rule none none
dsi_partitioning_rule none none
dsi_rs_ticket_report off off
dsi_text_convert_multiplie 1.0 1.0
dsi_text_convert_multiplie 1.0 1.0
dsi_text_convert_multiplie 1.0 1.0
dsi_text_convert_multiplie 1.0 1.0
dsi_text_convert_multiplie 1.0 1.0
dsi_text_convert_multiplie 1.0 1.0
dsi_text_convert_multiplie 1.0 1.0
dsi_text_convert_multiplie 1.0 1.0
dsi_text_convert_multiplie 1.0 1.0
dsi_text_convert_multiplie 1.0 1.0
dsi_text_convert_multiplie 1.0 1.0
dsi_text_convert_multiplie 1.0 1.0
dsi_text_convert_multiplie 1.0 1.0
dsi_text_convert_multiplie 1.0 1.0
dsi_text_convert_multiplie 1.0 1.0
dsi_text_convert_multiplie 1.0 1.0
exec_cmds_per_timeslice 100000 100000
exec_cmds_per_timeslice 100000 100000
exec_cmds_per_timeslice 100000 100000
exec_cmds_per_timeslice 100000 100000
exec_cmds_per_timeslice 100000 100000
exec_cmds_per_timeslice 100000 100000
exec_cmds_per_timeslice 100000 100000
exec_cmds_per_timeslice 100000 100000
exec_cmds_per_timeslice 100000 100000
exec_cmds_per_timeslice 100000 100000
exec_cmds_per_timeslice 100000 100000
exec_cmds_per_timeslice 100000 100000
exec_cmds_per_timeslice 100000 100000
exec_cmds_per_timeslice 100000 100000
exec_cmds_per_timeslice 100000 100000
exec_cmds_per_timeslice 100000 100000
exec_sqm_write_request_lim 983040 983040
exec_sqm_write_request_lim 983040 983040
exec_sqm_write_request_lim 983040 983040
exec_sqm_write_request_lim 983040 983040
exec_sqm_write_request_lim 983040 983040
exec_sqm_write_request_lim 983040 983040
exec_sqm_write_request_lim 983040 983040
exec_sqm_write_request_lim 983040 983040
exec_sqm_write_request_lim 983040 983040
exec_sqm_write_request_lim 983040 983040
exec_sqm_write_request_lim 983040 983040
exec_sqm_write_request_lim 983040 983040
exec_sqm_write_request_lim 983040 983040
exec_sqm_write_request_lim 983040 983040
exec_sqm_write_request_lim 983040 983040
exec_sqm_write_request_lim 983040 983040
ha_failover off off
id_msg_confidentiality not_required
not_required
id_msg_integrity not_required
not_required
id_msg_origin_check not_required
not_required
id_msg_replay_detection not_required
not_required
id_msg_sequence_check not_required
not_required
id_mutual_auth not_required
not_required
id_security_mechanism
id_server REP REP
id_unified_login not_required
not_required
init_sqm_write_delay 1000 1000
init_sqm_write_max_delay 10000 10000
md_source_memory_pool 983040 983040
md_sqm_write_request_limit 100000 100000
md_sqm_write_request_limit 983040 983040
md_sqm_write_request_limit 983040 983040
md_sqm_write_request_limit 983040 983040
md_sqm_write_request_limit 983040 983040
md_sqm_write_request_limit 983040 983040
md_sqm_write_request_limit 983040 983040
md_sqm_write_request_limit 983040 983040
md_sqm_write_request_limit 983040 983040
md_sqm_write_request_limit 983040 983040
md_sqm_write_request_limit 983040 983040
md_sqm_write_request_limit 983040 983040
md_sqm_write_request_limit 983040 983040
md_sqm_write_request_limit 983040 983040
md_sqm_write_request_limit 983040 983040
md_sqm_write_request_limit 983040 983040
memory_limit 1500 1500
memory_max 3 3
minimum_rssd_version 1260 1260
msg_confidentiality not_required
not_required
msg_integrity not_required
not_required
msg_origin_check not_required
not_required
msg_replay_detection not_required
not_required
msg_sequence_check not_required
not_required
mutual_auth not_required
not_required
num_client_connections 100 100
num_concurrent_subs 100 100
num_msgqueues 250 250
num_msgs 204800 204800
num_mutexes 1500 1500
num_stable_queues 35 35
num_threads 1000 1000
oserver REP REP
password_encryption 0 0
queue_dump_buffer_size 1000 1000
rec_daemon_sleep_time 120 120
rep_as_standby off off
rsm_proc_compat_version 1260 1260
rssd_error_class rs_sqlserver_error_cla
rs_sqlserver_error_class
security_mechanism
security_services off off
send_truncate_table on on
smp_enable on on
sqm_recover_segs 1 1
sqm_warning_thr_ind 70 70
sqm_warning_thr1 75 75
sqm_warning_thr2 90 90
sqm_write_flush on on
sqt_init_read_delay 2000 2000
sqt_max_cache_size 134217728 134217728
sqt_max_prs_size 262144 262144
sqt_max_read_delay 10000 10000
sre_reserve 0 0
stats_daemon_sleep_time 600 600
stats_flush_rssd on on
stats_reset_afterflush on on
stats_sampling on on
sts_cachesize 1000000 1000000
sts_full_cache_rs_articles on on
sts_full_cache_rs_classes on on
sts_full_cache_rs_columns on on
sts_full_cache_rs_config on on
sts_full_cache_rs_database on on
sts_full_cache_rs_datatype on on
sts_full_cache_rs_diskaffi on on
sts_full_cache_rs_diskpart off off
sts_full_cache_rs_erroract off off
sts_full_cache_rs_exceptsc off off
sts_full_cache_rs_exceptsh off off
sts_full_cache_rs_exceptsl off off
sts_full_cache_rs_funcstri off off
sts_full_cache_rs_function off off
sts_full_cache_rs_idnames off off
sts_full_cache_rs_ids off off
sts_full_cache_rs_maintuse off off
sts_full_cache_rs_objects off off
sts_full_cache_rs_oqid on on
sts_full_cache_rs_publicat off off
sts_full_cache_rs_queuemsg off off
sts_full_cache_rs_queuemsg off off
sts_full_cache_rs_queues off off
sts_full_cache_rs_recovery off off
sts_full_cache_rs_repdbs off off
sts_full_cache_rs_repobjs on on
sts_full_cache_rs_routes off off
sts_full_cache_rs_routever off off
sts_full_cache_rs_rules on on
sts_full_cache_rs_segments on on
sts_full_cache_rs_sites off off
sts_full_cache_rs_statcoun off off
sts_full_cache_rs_statdeta off off
sts_full_cache_rs_statrun off off
sts_full_cache_rs_subscrip off off
sts_full_cache_rs_systext off off
sts_full_cache_rs_translat off off
sts_full_cache_rs_users on on
sts_full_cache_rs_version off off
sts_full_cache_rs_wherecla off off
sub_daemon_sleep_time 10000 10000
sub_sqm_write_request_limi 983040 983040
sub_sqm_write_request_limi 983040 983040
sub_sqm_write_request_limi 983040 983040
sub_sqm_write_request_limi 983040 983040
sub_sqm_write_request_limi 983040 983040
sub_sqm_write_request_limi 983040 983040
sub_sqm_write_request_limi 983040 983040
sub_sqm_write_request_limi 983040 983040
sub_sqm_write_request_limi 983040 983040
sub_sqm_write_request_limi 983040 983040
sub_sqm_write_request_limi 983040 983040
sub_sqm_write_request_limi 983040 983040
sub_sqm_write_request_limi 983040 983040
sub_sqm_write_request_limi 983040 983040
sub_sqm_write_request_limi 983040 983040
sub_sqm_write_request_limi 983040 983040
unified_login not_required
not_required
use_security_services off off
use_ssl off off
varchar_truncation off off
(return status = 0)


RepAgent config:
Parameter Name Default
Config Value Run Value
------------------------------
------------------------------
------------------------------
------------------------------
trace flags 0
0 0
scan timeout 15
15 15
send buffer size 2k
16k 16k
schema cache growth factor 1
3 3
retry timeout 60
30 30
priority 5
4 4
scan batch size 1000
5000 5000
connect dataserver PDS01
PDS01 PDS01
rs servername n/a
REP REP
msg confidentiality false
false false
msg integrity false
false false
msg origin check false
false false
msg out-of-sequence check false
false false
msg replay detection false
false false
mutual authentication false
false false
send maint xacts to replicate false
false false
unified login false
false false
security mechanism n/a
n/a n/a
trace log file n/a
n/a n/a
data limits filter mode stop
stop off
connect database DB
DB DB
rs username n/a
DB_rep_agent DB_rep_agent
send structured oqids false
true true
send warm standby xacts false
true true
short ltl keywords false
true true
skip ltl errors false
true true
skip unsupported features false
true true
batch ltl true
true true
ha failover true
true true


Network bandwidth: 32MB


Mark A. Parsons Posted on 2013-02-04 16:37:56.0Z
Sender: 4d16.510fe1ea.1804289383@sybase.com
From: Mark A. Parsons
Newsgroups: sybase.public.rep-server
Subject: Re: Latency issue
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <510fe3e4.4daf.1681692777@sybase.com>
References: <510f4500.2984.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 4 Feb 2013 08:37:56 -0800
X-Trace: forums-1-dub 1359995876 172.20.134.41 (4 Feb 2013 08:37:56 -0800)
X-Original-Trace: 4 Feb 2013 08:37:56 -0800, 172.20.134.41
Lines: 41
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9308
Article PK: 1307445

My initial guess would be that you have a long running
transaction in the PDB that's causing the lengthy latency
issues.

Keep in mind that the DSI (into the RDB) has to wait for the
transaction in the PDB to complete *before* it can complete
the transaction in the RDB. This can lead to increased
latency issues, stable queues filling up, and of course the
PDB transaction log filling up.

Soooo, during the EOD processing in the PDB, look for
something/someone holding open a transaction for a long
period of time (see master..syslogshold,
master..systransactions).

The fact that latency eventually drops off would tend to
indicate that a long-running transaction in the PDB was
eventually closed (either a 'commit tran' was issued or the
parent process was killed thus causing the tran to be closed
with a 'rollback tran').
----------------

Other possibilities would include the PDB repagent not
running (or having problems), log transfer being disabled in
the repserver, repserver DSI thread being down, excessive
blocking in the RDB.

All of these could lead to lengthy latency times.

The fact that latency eventually drops off would imply that
one of these issues was eventually addressed.

> We have warmstandby setup & every day after EOD run,
> Origintime is not moving in rs_lastcommit(RDS).
> latency starts draining daily after 11:30 am & it
> completely drained out almost 10 hrs latency in an hour
> and after that no latency till next EOD, not sure what is
> an issue.
>
> can anyone come across same situtation, please share.

... snip ...