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 »

Very Useful Command to perform Health check of SAP Sybase ASE Replication Server

Very Useful Command to perform Health check of SAP Sybase ASE Replication Server

We will cover few basic commands today which is a must to have for DBA who is supporting SAP Sybase ASE Replication Server and is responsible to keep the replication in a healthy state. Please note that these commands could be stored as a sql query file and can be invoked using a shell script, …

Very Useful Command to perform Health check of SAP Sybase ASE Replication Server Read More »

How to not encounter Error 10330 SELECTINSERTUPDATEDELETEEXECUTE permission denied on object XXX, database XXX, owner XXX

How to not encounter “Error 10330 SELECT/INSERT/UPDATE /DELETE/EXECUTE permission denied on object XXX, database XXX, owner XXX”

You must have encountered one of these errors or more than one at many times whenever there is a new object created or procedure has been changed(dropped and recreated). Mostly DBAs handle permissions at role level however in many cases some of the objects or logins(or users) are not part of role which caters to …

How to not encounter “Error 10330 SELECT/INSERT/UPDATE /DELETE/EXECUTE permission denied on object XXX, database XXX, owner XXX” Read More »

The transaction log for database 'XXX' (dbid 5) can no longer be dumped due to user 'dba' (suid 35) executing ALTER TABLE

The transaction log for database ‘XXX’ (dbid 5) can no longer be dumped due to user ‘dba’ (suid 35) executing ALTER TABLE

I am sure you would have seen this warning in your SAP Sybase ASE Errorlog once in a while at Production environment when log backup is enabled and you are taking them periodically basis business requirement. Let’s see one of the most frequent root cause of this and also if there is any way to …

The transaction log for database ‘XXX’ (dbid 5) can no longer be dumped due to user ‘dba’ (suid 35) executing ALTER TABLE Read More »