SCN Blog

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… Read More » MaxDB ST05-trace fallacy - when sometimes the trace is wrong...

Recently a colleague asked me about how to analyze the following short dump: Database error text........: "ORA-01007: variable not in select list" Database error code........: 1007 Triggering SQL statement...: "FETCH… Read More » ORA-01007 in ABAP stack and what to do about it.

It’s been quite a while since my last blog post and we’ve been pretty busy in the primary support department. A major change for us had been the introduction of “Enterprise Support” (ES) and the offer to customers to not… Read More » How to run a SAP landscape (or so)

Infrastructure software like RDBMS often tends to become feature-rich in many directions. MaxDB is no exception to this, so by reading the documentation there’s a pretty good chance to dig out some features that are… Read More » MaxDB Event Dispatcher Intro

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… Read More » MaxDB – On locking mechanisms and how we learn something new each day… Part II

Ok, I admit, I don’t have a very good idea of MS SQL Server. I do Oracle and MaxDB - that pretty much is it. Of course, as a database support guy you always need to peek over the fence to the other DBMS (e.g. working on… Read More » The others

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… Read More » MaxDB – On locking mechanisms and how we get to know our MaxDB a bit better each day… Part I

Browsing through closed support messages while looking for a possible approach to a certain Oracle CBO problem I came across a quite problematic issue. Some support colleagues sometimes seem to focus too much on removing… Read More » A fix is not a solution!

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… Read More » Questions to SAP-Support (MaxDB): “Data is gone after reboot – where the heck is it?”

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… Read More » Questions to SAP Support: “How to prevent MaxDB from creating backups to the RUNDIRECTORY?”