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 …
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 »
In real world scenario, we have come across many situations wherein table will have more than 254 columns and when you try to create the same in Sybase ASE, you would face an error as below: Number of variable length columns exceeds limit of 254 for allpage locked tables. CREATE TABLE for ‘table_name’ failed. By …