Home / SAP MaxDB (page 3)

SAP MaxDB

Updates for SAP MaxDB 7.6 and 7.7 Available for Download

Spring cleaning at SAP MaxDB: we have just published updates for our SAP MaxDB community edition. Go to the SDN download area to get the latest SAP MaxDB software packages: SAP MaxDB 7.6.06.10 SAP MaxDB 7.7.07.16 For a comfortable upgrade from older versions, use the SAP MaxDB Installation Manager (SDBSETUP). …

Read More »

MaxDB Event Dispatcher Intro

Infrastructure software like RBMS often tend to become feature-rich in many directions.MaxDB is no exception to this, so by reading the documentation there’s a pretty good change to digg out some features that are rarely seen or used. One example for this is the MaxDB database event dispatcher.It has been …

Read More »

MaxDB – Space oddities, take II

        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 be exposed to features like segment fragmentation …

Read More »

MaxDB: Space oddities

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.To investigate he decided to check whether the information visible in DBM GUI …

Read More »

MaxDB: Some notes on the INDEX_USED statistic

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 information if the index had been used at all yet and, starting with MaxDB 7.6 it also …

Read More »

Questions to SAP Support: ‘How to move MaxDB volumes?’

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 into the parameters section of the KNLDIAG reveals this: --------------------------------------------------------------------------------Date       Time       TID(hex) Typ MsgID Label    Message-Text--------------------------------------------------------------------------------2008-09-10 19:14:17      0x7A4     20234 RTE      Dump of all kernel parameters …

Read More »

What you don’t know about MaxDB…

Everyday I’m faced with collegues, customers, partners or SDN members asking questions about MaxDB. How can we setup an external backup tool? Why is my index not taken by the optimizer? Can I use MaxDB as a productive system? These question reveal that although there is a whole lot of information …

Read More »

SDN Wiki Features – what features?

While editing content for MaxDB Wiki here in SDN I wondered how I might return to a older version of the page. Unlinke e.g. MediaWiki http://www.mediawiki.org/  the WIKI engine behind Wikipedia (http://www.wikipedia.org) in the SDN Wiki there is no tab bar “Versions”. Instead one finds the “Info” tab bar, which brings …

Read More »

‘Mind the gap…’ (#2 – Data storage)

More and more customers decide to use MaxDB and with that, the number of customers asking for a comprehensive list of differences or a comparison increases as well. In my mini-series “Mind the gap” I will try to shed some light on where the little or big differences between MaxDB …

Read More »

‘Mind the gap …’

More and more customers decide to use MaxDB and with that, the number of customers asking for a comprehensive list of differences or a comparison increases as well. In my mini-series “Mind the gap” I will try to shed some light on where the little or big differences between MaxDB …

Read More »

MaxDB Internals Documentation available for free!

Today I spoke with Jörg Hoffmeister (Product and Development Manager of MaxDB and liveCache).He told me that finally the “MaxDB Internals” Documentation has been released to the public.Many thanks for that Jörg! Just browse to http://maxdb.sap.com/training/.There you’ll find a list of PDF files that contain the latest english version of the slides …

Read More »

MaxDB Database Studio 7.7 is available !

I’ve recently written about it (Something new is coming up…). We presented it on the Las Vegas TechEd (and it will also be shown in Munich). One question was present all the time: When will the new MaxDB Tool for DBAs/Developers be finally available to the (SAP)-public? Now there is …

Read More »

Something new is coming up…

For so many years now the DBMGui and the SQL Studio have been the primary graphical interfaces for developers and DBAs to access MaxDB instances.Beside the many good features and the relative high stability (i remember the early versions of Oracle’s SQL Worksheet in release 9i…) the major drawback has been …

Read More »