MaxDB ST05-trace fallacy – when sometimes the trace is wrong…

One of the most important analytical tools used to investigate slow running SQL statements is the well-known ST05 - SQL trace. The idea of it is that the ABAP database interface notes down what SQL statement it sends to the database, how long it took to get the result, what selection criteria were used and … Continue reading MaxDB ST05-trace fallacy – when sometimes the trace is wrong…

MaxDB – On locking mechsanisms and how we learn something new each day… Part II

As I promised here's the second part of my short excurse into the shoals of lock management with MaxDB databases. (The first part can be found MaxDB - On locking mechanisms and how we get to know our MaxDB a bit better each day... Part I) 2) When deadlocks go unnoticed... Ok, big buzz word … Continue reading MaxDB – On locking mechsanisms and how we learn something new each day… Part II

MaxDB – On locking mechanisms and how we get to know our MaxDB a bit better each day… Part I

One of the most boring topics within the area of DBMS surely is locking. It's also one of the topics that most DB users try to avoid as much as possible. Still, it's utmost important to correctly understand how locking works in the database of choice to be able to work successfully with it and without bad … Continue reading MaxDB – On locking mechanisms and how we get to know our MaxDB a bit better each day… Part I

Questions to SAP-Support (MaxDB): “Data is gone after reboot – where the heck is it?”

From time to time I start to believe that there are certain problems that would not come up anymore, once the topic is documented well enough. My colleagues from the development know that too well as I'm asking for documentation and notes all the time for everything. However, the written documentation does help nothing if … Continue reading Questions to SAP-Support (MaxDB): “Data is gone after reboot – where the heck is it?”

Questions to SAP Support: “How to prevent MaxDB from creating backups to the RUNDIRECTORY?”

Hello, community! Just a minute ago I got to work on a message where a customer asked: "Hello support team, could you please tell me how to teach MaxDB not to save backups to the default RUNDIRECTORY but to a path specified by me?" Since it's actually not that difficult to figure out how this works, … Continue reading Questions to SAP Support: “How to prevent MaxDB from creating backups to the RUNDIRECTORY?”

‘Mind the gap…’ (#4 – reading query execution plans)

In my mini-series "Mind the gap..." I will try to shed some light on where the little or big differences between MaxDB and Oracle databases are and what to keep in mind when working with them. Today I'd like to write a bit about the pitfalls you can tap into when trying to apply your … Continue reading ‘Mind the gap…’ (#4 – reading query execution plans)