Sybase ASE

Re-Initialize Replication for Secondary with MSA Online

How to Re-Initialize Replication for Secondary with MSA Online

In this post, we shall talk about reinitializing the replication to warm standby when it is already up and running for MSA(Multiple Subscriber Agent) to reporting or some other server. Actually, I faced this issue few days ago when we had commissioned a new reporting server and wanted to offload the reporting load to this …

How to Re-Initialize Replication for Secondary with MSA Online Read More »

Important 15 Sybase ASE DBA Interview Questions and Answers

Important 15 Sybase ASE DBA Interview Questions and Answers

I thought of doing another session for Sybase ASE DBA interview Questions and Answers inline with SQL Server DBA interview Questions and Answers and share with you. These questions are of expert levels and check your overall understanding as well as troubleshooting of SAP Sybase ASE database and approach towards solving issues. Interview typically lasts …

Important 15 Sybase ASE DBA Interview Questions and Answers Read More »

Error 226 'xxx' command not allowed within multi-statement transaction

Error 226 ‘xxx’ command not allowed within multi-statement transaction

In the earlier post Error 2762 The ‘xxx’ command is not allowed within a multi-statement transaction in the database, we covered how to find a work-around for solving multi-statement transaction error and keep it running while having option of rolling back or committing it based on the requirement and execution. Today, we will talk about …

Error 226 ‘xxx’ command not allowed within multi-statement transaction Read More »

SAP Sybase ASE - How to Add Server Entry in Interfaces File Through DSCP

SAP Sybase ASE – How to Add Server Entry in Interfaces File Through DSCP

As you know interface file holds details of servers where Sybase ASE can connect to, here we are talking about server level, we shall cover details about client side in different post. A typical interface file contains server name(could be anything as per your choice), IP or hostname of the server and port number, which …

SAP Sybase ASE – How to Add Server Entry in Interfaces File Through DSCP Read More »

Error 2762 The 'xxx' command is not allowed within a multi-statement transaction in the database

Error 2762 The ‘xxx’ command is not allowed within a multi-statement transaction in the database

While deploying the code from development team or support team or vendor provided code, you would have encountered below error and would have thought why this message and why to perform DDL statement inside a user transaction: The ‘%s’ command is not allowed within a multi-statement transaction in the ‘%.*s’ database. Lets understand why this …

Error 2762 The ‘xxx’ command is not allowed within a multi-statement transaction in the database Read More »

Capturing Sysmon at SAP ASE Replication Server and Scheduling

Capturing Sysmon at SAP ASE Replication Server and Scheduling

We all must have gathered sysmon output at ASE server and analyzed it while performing troubleshooting at server level. How about gathering similar output at replication server level – this is a very interesting output to look at and understand the details underlying. Lets first talk about the duration and scheduling of this command – …

Capturing Sysmon at SAP ASE Replication Server and Scheduling Read More »

Point in Time Recovery with Cumulative and Tran Backup Post Full Backup

Point in Time Recovery with Cumulative and Tran Backup Post Full Backup

As we are aware that, we have different types of Database Backup in SAP(Sybase) ASE inline with other relational databases. In this post, we shall cover types of Backup concerning sp_dboption(database option) and how to use them effectively together while loading the database in order to achieve Point in Time Recovery. Full Backup – This …

Point in Time Recovery with Cumulative and Tran Backup Post Full Backup Read More »

Replication Server failed with fatal error while allocating memory. Most likely, there is not enough memory. Replication Server is going to abort.

Replication Server failed with fatal error while allocating memory. Most likely, there is not enough memory. Replication Server is going to abort.

If you are working on SAP ASE(Sybase) replication server, there is likelihood of facing this error which states “Replication Server failed with fatal error while allocating memory. Most likely, there is not enough memory. Replication Server is going to abort.” We faced this issue when we added a MSA(Multi-Site Availability) to the existing set-up of …

Replication Server failed with fatal error while allocating memory. Most likely, there is not enough memory. Replication Server is going to abort. Read More »