SAP Knowledge Base Article - Preview

3259414 - Frequent drop and recreate table makes excessive growth in rs_schemas table in eRSSD - SRS

Symptom

  • In a HADR environment, frequent drop and recreate table makes excessive growth in rs_schemas table in eRSSD. 
  • Check the row count in the rs_schemas to see large number of rows.

1> select dbid,count(*) from rs_schemas group by dbid
2> go
dbid    count()
------- -----------
...
122      25013793
...


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 with Always-on Optio (HADR)
  • SAP Adaptive Server Enterprise (ASE) 16.0 with High Availability Disaster Recovery (HADR) for Business Suite

Product

SAP Replication Server all versions

Keywords

CR826569, CR#826569, 826569, growth in rs_schemas , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , BC-SYB-REP-HET , Replication Server Heterogeneous Edition (RSHE) , BC-SYB-REP-RTL , Rep Server Real-Time Loading Edition (RTLE) , BC-SYB-REP-RSO , Rep Server Options (RSO) , BC-SYB-REP-ME , Replication Server Messaging Edition (RSME) , Known Error

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.