Sybase ASE

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 »

Understanding SAP Sybase ASE Maintenance Jobs & When To Schedule

Understanding SAP Sybase ASE Maintenance Jobs & When To Schedule

Maintenance job basically comprises of two aspects – one is to deal with space management and remove fragmented space and second is to update the statistics with data change so that histogram reflects the latest data and plan selection could be optimized. Lets understand the first type of maintenance job which starts with reorg, as …

Understanding SAP Sybase ASE Maintenance Jobs & When To Schedule 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 »

Why Index Hints Should Never Be Used(My Experience)

Why Index Hints Should Not(judiciously) Be Used(My Experience)

I am sharing here my recent experience with one of our vendor who is considered as very much reputed and experienced, they have team of DBAs(development DBA cum Architect, Production DBA, Infrastructure DBA etc..) and mostly their database codes as well as their indexing are not disputable. I am the lonely DBA working in my …

Why Index Hints Should Not(judiciously) Be Used(My Experience) Read More »