Freelancers
Cancel
 Sign In
Join Now

Adding a DR node to ASE Always-on for a Custom Application (Part 1)

Currently we document creating an Always-on (HADR) environment for Custom and Business Suite applications HADR Users Guide and adding a 3rd node DR to a Business Suite Application HADR System with DR Node Users Guide, but in the latter document there is no section on “Adding a DR Node to an Existing Custom HA System”. My intention is....

Adding a DR node to ASE Always-on for a Custom Application (Part 3)

Dropping the DR node Dropping the DR node can be done in 3 steps from the primary RMA: Drop database replication to DR: 1> sap_disable_replication Toronto, Offsite, tpcc 2> go TASKNAME TYPE VALUE ------------------- ----------------- --------------------------------------------------------------------------------------------------------------------------------------------------------- Disable Replication Start Time Thu Dec 08 21:54:47 UTC 2022 Disable Replication Elapsed Time 00:00:45 DisableReplication Task Name Disable....

Adding a DR node to ASE Always-on for a Custom Application (Part 2)

Adding a database to the HADR cluster Existing databases can be added to the HADR cluster for replication in one of 2 ways: Using the setuphadr response file to create the devices and database. Using the RMA command ‘sap_update_replication’ and ‘sap_materialize’ commands. The first method has already been demonstrated in Part 1 using the response....

How to make an ASE rep_agent wait for a recent transaction to be sent to the repserver

This article concerns replicating data from the SAP Adaptive Server Enterprise (“ASE”) database server (formerly Sybase ASE) to the SAP Replication Server (aka “repserver,” formerly the Sybase repserver) In certain critical transactions, it might be desirable for the application to wait until the most recent transaction has made it out of the ASE transaction log....

Recovery of a transaction log dump takes unexpectedly long

Introduction In this article I discuss why recovery of a transaction log dump of a SAP ASE database may sometimes take longer than expected and It is assumed you do have a working knowledge of SAP ASE as a DBA. An important (the most important ?) part of your job as a database administrator (DBA)....