datarows

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 »