Symptom
- You have HADR setup running on ASE 16.0 SP03 PL07 and higher.
- In SRS, dt_apply is enabled, the value is set higher than 1.
- In standby ASE, 'enable DTM' is turned on, configured as 1.
- In standby ASE, SPID 0 always hold share locks on syslogins table. This can be checked by sp_lock.
- SRS become hang and only when roll back the transactions in standby ASE, SRS can recover.
Read more...
Environment
ASE 16.0 SP03 PL07 and higher with HADR setup
Product
SAP Adaptive Server Enterprise all versions
Keywords
dt_apply, SRS, hang, hanging, syslogins, DTM, standby, HADR , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-REP , Sybase Replication Server (standalone) , BC-SYB-REP-SAP , Replication with SAP Suite / SAP BW , Problem
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.