Data, Process, Insights & things I write about
What I dislike in donating # Really, I’m not too big into making donations. It’s not that I’m greedy and what to keep everything for me. It’s also not that I’m parsimonious like Mr Scrooge. Actually, I do want to see… Read More » What a big impact a little money can have…
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. Read More » ‘Mind the gap…’ (#4 – reading query execution plans)
Just a short note, nothing spectacular today. After many years of customers asking, complaining and debating, SAP finally supports SSH for remote access to customer systems. Even more, also VNC connections are finally… Read More » SSH/VNC finally reached SAP Support
The default reaction # When working in support you get to see a lot of bugs, mistakes and errors. That’s of course how things are going and there’s not much to whine about. Read More » Now step back and start thinking!
After the tremendous (and very unlikely) success of the first MaxDB: Space oddities blog, I immediately decided: this must be the voice of the market asking for more. So here you get it. # While Oracle DBAs are used to… Read More » MaxDB – Space oddities, take II
MaxDB - Space oddities Recently a customer came up with the assumption that there is space somehow missing from the database. Although he deleted a whole lot of data via archiving the data area was still quite filled up.… Read More » MaxDB: Space oddities
Let’s face it - the really really bad performance issues are usually not due to some weird database bugs. Instead, a wrong system setup or the bad usage of the database prevents a high performance. Read More » Understanding database performance for developers
You may have already wondered about whether a specific index is sensible or if you can save space by dropping it. For this MaxDB provides statistic information in the INDEXES view. The column INDEXUSED provides the… Read More » MaxDB: Some notes on the INDEX_USED statistic
Before starting with this blog, I’ve to apologize for being so late with this issue of “Mind the Gap”. Since the last part of this series (‘Mind the gap…’ (#3 - Backup/Restore - Part 1) Read More » ‘Mind the gap…’ (#3 – Backup/Restore – Part 2)
Unlike Oracle, MaxDB does not have a CONTROLFILE to store the location of its files. Instead, all file locations are stored as common parameters. A quick look at the parameters section of the KNLDIAG reveals this: Read More » Questions to SAP Support: “How to move MaxDB volumes?”