Introduction
In this article I discuss why recovery of a transaction log dump of a SAP ASE database may sometimes take longer than expected and
It is assumed you do have a working knowledge of SAP ASE as a DBA.
An important (the most important ?) p...
In this article I discuss dependence of procedure cache on SAP ASE parameters max online engines and engine local cache percent. It is a lesson learned from a situation where inappropriate configuration lead to really bad performance due to spinlock ...
There is a serious issue in SP04 PL04 (and SP04 PL03 and SP03 PL12 - PL14) that affects encrypted databases. See SAP note3400916 - SYB: Potential database corruption and error 605 on encrypted databasesIf your database is encrypted make sure you ins...
If an installmaster script is provided along with the ONE-OFF dataserver executable in the ONE OFF package you received from SAP Support , then it must be executed. If no installmater script is provided aloing with the ONE-OFF then it should be ok to...
Sounds unlikely to me that ASE should increase its memory footprint just after an OS upgrade (but who knows) I assume you don't have data on ASE's memory consumption of before the OS upgrade. (nor that of other processes running on the maschine) Mayb...
Another warning regarding manual update of system catalogue tables: This is not a supported method - so if something goes wrong your are on your own. SAP Support will probably not be able to help you. Sometimes manual update of system catalog tables ...
Just did a quick and dirty test (on a Linux box though) deliberately using a wrong password for sapadm : /usr/sap/hostctrl/exe/saphostctrl -function LiveDatabaseUpdate -user sapadm - -dbname XYZ -dbtype syb -updatemethod Execute -updateoption UPDA...
