Symptom
- The distributer sqt cache is growing larger than configured.
- admin who, dist reports negative number for SqtMaxCache, for example:
- admin who, dist, ASE_1, pdb
- shows a negative number in SqlMaxCache: SqtMaxCache: -2147483648
- Note: Legal Values for dist_sqt_max_cache_size: 0 to 2147483647 for 32-bit Replication Server, 0 to 2251799813685247 for 64-bit Replication Server.
-
Source Connection Configuration Values: ASE_1.pdb
Configuration Option Name Value
------------------------------------------------- ----------------------------------------------------
dist_sqt_max_cache_size 3774873600 ====> 3600 MB
dsi_bulk_copy on
dsi_compile_enable off
dsi_keep_triggers off
dsi_replication off
parallel_dist offInbound SQT Cache Memory
Source Connection: ASE_1.pdb (5248)
Interval CmdsRead CmdsPerSec CmdMaxTran CmdAvgTran CacheMem MemAvgTran MemLowBnd CacheLow ControlMem
------------------------------ ------------- ------------ ---------- --------------- ------------ ---------------- ---------- ---------- ----------
(1) 20:35:22 -> 20:36:24 539275 8840.5 35464 71 36499.22 108.79 0.00 0 0 ====> 36GB
(2) 20:36:25 -> 20:37:26 3550 58.1 1819 9 36252.06 5.59 0.00 0 0
(3) 20:37:27 -> 20:38:27 10065 167.7 6536 20 35323.46 20.02 0.00 0 0
(4) 20:38:28 -> 20:39:28 9354 155.9 6427 16 34447.98 19.87 0.00 0 0
(5) 20:39:29 -> 20:40:29 5386 89.7 10 4 33477.03 0.03 0.00 0 0
(6) 20:40:30 -> 20:41:30 6040 99.0 10 5 32508.56 0.03 0.00 0 0
(7) 20:41:31 -> 20:42:31 3898 63.9 10 5 31572.56 0.03 0.00 0 0
(8) 20:42:32 -> 20:43:33 12011 193.7 8792 21 30509.18 26.96 0.00 0 0
(9) 20:43:34 -> 20:44:34 152576 2542.9 45221 722 30014.54 138.66 0.00 0 0
(10) 20:44:35 -> 20:45:35 41900 698.3 29180 581 29197.56 89.56 0.00 0 0
------------------------------ ------------- ------------ ---------- --------------- ------------ ---------------- ---------- ---------- ----------
784055 1290.9 45221 145 36499.22 40.95 0.00 0 0
Read more...
Environment
SAP Replication Server (SRS) 16.0
Product
Keywords
KBA , BC-SYB-REP , Sybase Replication Server (standalone) , Bug Filed
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.