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.
SAP Knowledge Base Article - Preview