I had covered set of interview questions earlier( Important 15 Sybase ASE DBA Interview Questions and Answers) and it was liked by our DBA community and have got feedback to cover few more questions and a bit challenging ones. I have compiled list of a bit tricky questions and I am sure you would like …
SAP Sybase ASE DBA Experienced Interview Questions Read More »
In this post, we would like to cover Database Backup of different types and their restoration – which one is needed when and how to use them in which sequence. In earlier post, we had covered aspects of full backup with compression, cumulative backup and tran backup (Point in Time Recovery with Cumulative and Tran …
SAP Sybase ASE Backup Restoration and Point in Time Recovery Read More »
In this post, we shall cover password policy of SAP Sybase ASE in depth. Password policy is an integral part of Database Administrator job – it is getting more and more traction after incident of hacking has increased post pandemic. Security department wants to ensure that password matches to best possible stringent norms and it …
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 »
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 »
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 »
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 »
This is one of the most important job responsibility of DBA. Database administrator is supposed to create login, associate login with user in user database, grant minimum permission to perform required operation either directly at login(user) level or at role level. When there are many logins/users and too many objects at database, it becomes easier …
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 …
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 »