New space for Basis on the Wiki
Wiki space for Basis and Technical related content. Juan Reyes in Application Server, Beginner, Enterprise Portal (EP), SAP Developer Network, SAP MaxDB and liveCache, SAP NetWeaver Platform [Nov. 13, 2009 03:04 AM | 0 Comments | Permalink]

MaxDB - On locking mechsanisms and how we learn something new each day... Part II
Later than promised but yet here: the second part of my lock blog. Hope you have again fun reading it. Lars Breddemann in SAP Developer Network, SAP MaxDB and liveCache, SAP NetWeaver Platform, SAP TechEd [Oct. 20, 2009 09:10 AM | 4 Comments | Permalink]

MaxDB - On locking mechanisms and how we get to know our MaxDB a bit better each day... Part I
Why care about locking mechanisms in detail? Because you cannot do without them and they are out to catch you ... Lars Breddemann in SAP Developer Network, SAP MaxDB and liveCache, SAP NetWeaver Platform [Oct. 14, 2009 06:09 AM | 5 Comments | Permalink]

The others
Interested in learning more on MS SQL Server on SAP? Here's a blog you may find interesting. Lars Breddemann in SAP Developer Network, SAP MaxDB and liveCache, SAP NetWeaver Platform [Oct. 14, 2009 04:50 AM | 0 Comments | Permalink]

The New Discovery System v4 at TechEd Phoenix 09
Want to hear about the new SAP Discovery System version 4 first hand? Come meet us at TechEd Phoneix either at the hands-on workshops or at the Expert Networking Sessions. Itai Sadan in Business Intelligence (BI), Service-Oriented Architecture, SAP Solution Manager, SAP MaxDB and liveCache, SAP Interactive Forms by Adobe, Java Programming, ERP, Enterprise Portal (EP), Composition Environment (CE), Business Rules Management, Business Process Modeling, Business Process Management, Business Objects, Web Dynpro [Oct. 02, 2009 07:48 PM | 2 Comments | Permalink]

SAP MaxDB Online Training Sessions
Learn more about SAP MaxDB - Online Training Sessions available! Melanie Handreck in SAP MaxDB and liveCache, SAP NetWeaver Platform [Sep. 04, 2009 01:27 PM | 5 Comments | Permalink]

Questions to SAP-Support (MaxDB): "Data is gone after reboot - where the heck is it?"
You work hard on tight schedule and your development system just needs a reboot. When it's up again, all your data is gone! Read about this horrific situation a SAP customer and MaxDB user recently had to face and what led to this. Lars Breddemann in SAP Developer Network, SAP MaxDB and liveCache, SAP NetWeaver Platform, SAP TechEd [Aug. 11, 2009 01:13 PM | 8 Comments | Permalink]

Max DB log is full - SAP NW 2004S TestDrive for Linux
A short while back I downloaded and installed the SAP NetWeaver 2004S TestDrive SAP system (running on my Atom! machine at home). This provided me with my own (90-day licensed) basic SAP R/3 system which, according to the documentation, includes both ABAP and Java stacks running on SAP’s own database Max DB. One of the issues that this system is prone to is that the Max DB log gets full (there is no default log cycling). It is quite a well known issue and is even described on the SAP on Linux: Test Drives – Tips and Tricks FAQ . In my case, I encountered this issue after running an SGEN job to generate all the basis components on the system. I could log into the SAP system, but the GUI froze before anything useful came up. Trying to run stopsap, it hung forever at the checking database step (where it runs R3trans d). Looking in knldiag, I knew I had a full log problem because of this message: 2009-07-17 10:38:54 21 WNG 20001 KernelDB 99 percent of log area occupied, 126717 pages used Jonathan Groll in SAP MaxDB and liveCache [Jul. 22, 2009 04:24 AM | 1 Comments | Permalink]

Questions to SAP Support: "How to prevent MaxDB from creating backups to the RUNDIRECTORY?"
Never figured out how to specify the path to where MaxDB/liveCache backups are written? This blog tells you how... Lars Breddemann in Beginner, SAP Developer Network, SAP MaxDB and liveCache, SAP NetWeaver Platform [Jun. 30, 2009 05:52 AM | 0 Comments | Permalink]

'Mind the gap...' (#4 - reading query execution plans)
Moving to MaxDB as a DBA or database developer also requires that you get used to read the output of EXPLAIN in order to understand query execution in MaxDB. This time I'll write about the differences of WHAT and HOW the database shows you about its "optimizers thinking'. Lars Breddemann in SAP Developer Network, SAP NetWeaver Platform, SAP MaxDB and liveCache [May. 11, 2009 09:01 AM | 3 Comments | Permalink]

MaxDB - Space oddities, take II
Did you ever wonder why tables are smaller after you performed a R3load copy of tables with MaxDB? Get the answer - read this blog... Lars Breddemann in SAP NetWeaver Platform, SAP MaxDB and liveCache, SAP Developer Network [Feb. 03, 2009 10:49 AM | 3 Comments | Permalink]

MaxDB: Space oddities
MaxDB is well known as a DBMS with which nearly no space administration is necessary. Still it is possible to check on the internal space usage - this blog gives a headstart to this. Lars Breddemann in SAP MaxDB and liveCache, SAP Developer Network, SAP NetWeaver Platform [Jan. 28, 2009 09:48 AM | 4 Comments | Permalink]

MaxDB: Some notes on the INDEX_USED statistic
Ever wanted to know about the INDEX_USED statistic in MaxDBs INDEXES/INDEX_COLUMNS table? Read all about it here... Lars Breddemann in SAP NetWeaver Platform, SAP Developer Network, SAP MaxDB and liveCache [Nov. 21, 2008 07:20 AM | 0 Comments | Permalink]

Third SAP Infoday on SAP MaxDB was a success
The SAP-Infotag on SAP MaxDB 2008 took place again with more vistors and a lot of talk. Joerg Hoffmeister in Business Intelligence (BI), ERP, SAP NetWeaver Platform, SAP Solution Manager, SAP MaxDB and liveCache [Sep. 30, 2008 02:17 AM | 0 Comments | Permalink]

'Mind the gap...' (#3 - Backup/Restore - Part 2)
Backup/Recover in MaxDB and Oracle - what is different and what is similar with both DBMS. Today I'll cover the Oracle side and complete the 3rd part of the 'Mind the Gap' series. Lars Breddemann in Beginner, SAP Developer Network, SAP NetWeaver Platform, SAP MaxDB and liveCache [Sep. 21, 2008 07:15 PM | 2 Comments | Permalink]

Questions to SAP Support: "How to move MaxDB volumes?"
Lars Breddemann in SAP NetWeaver Platform, SAP Developer Network, SAP MaxDB and liveCache [Sep. 11, 2008 04:21 AM | 0 Comments | Permalink]

Questions to SAP Support: "How to generate a SQL Script via SQL on MaxDB?"
Switching from Oracle to MaxDB and bringing in your habits of generating SQL commands by using SQL? Stuck due to MaxDBs very own end-of-command delimiter 'newline'+'//' ? In this blog I show you an easy workaround for this. Lars Breddemann in SAP NetWeaver Platform, SAP Developer Network, SAP MaxDB and liveCache [Aug. 11, 2008 03:51 AM | 0 Comments | Permalink]

'Mind the gap...' (#3 - Backup/Restore - Part 1)
What's different and what's similar on MaxDB and Oracle installations - compared from a practitioners point of view. In todays issue: "Backup and Recovery of databases" Lars Breddemann in Beginner, Open Source, SAP Developer Network, SAP NetWeaver Platform, SAP MaxDB and liveCache [Jun. 24, 2008 04:20 AM | 0 Comments | Permalink]

SAP Infoday on SAP MaxDB: September 18, 2008
Third SAP Infoday on SAP MaxDB will take place September 18th in St. Leon-Rot. Joerg Hoffmeister in SAP Developer Network, SAP NetWeaver Platform, SAP MaxDB and liveCache [Jun. 13, 2008 01:52 AM | 0 Comments | Permalink]

Questions to SAP Support: "Is my MaxDB recovery still running?"
Ever wondered what's happening during the recovery of your MaxDB instance? In this blog I'll shed some light onto it. Lars Breddemann in SAP NetWeaver Platform, SAP Developer Network, SAP MaxDB and liveCache [Jun. 11, 2008 09:55 AM | 2 Comments | Permalink]

What you don't know about MaxDB...
Todays there are thousands of productive MaxDB/liveCache instances running at SAP, customers and partners. Also OpenSource developers use MaxDB to create their applications. Yet the knowledge about the MaxDB RDBMS is not spread to broadly, although there's a bunch of information available. Read the blog to learn what you don't know (yet). Lars Breddemann in Beginner, Enterprise Portal (EP), SAP Developer Network, SAP Process Integration (PI), SAP NetWeaver Platform, SAP MaxDB and liveCache [May. 08, 2008 06:24 AM | 0 Comments | Permalink]

Debugging the MaxDB Kernel - How to get a Call stack the easy way
Debugging the MaxDB Kernel via os-level debuggers may be necessary sometimes, but most often a simple MaxDB command is enough to get the current call stack of a process. Lars Breddemann in SAP NetWeaver Platform, SAP Developer Network, SAP MaxDB and liveCache [Feb. 08, 2008 01:13 AM | 0 Comments | Permalink]

'Mind the gap...' (#2 - Data storage)
Want to know how the inner workings of MaxDB and Oracle differ? Read my blog and find out about: data storage in the both DBMS. Lars Breddemann in SAP NetWeaver Platform, SAP Developer Network, SAP MaxDB and liveCache [Jan. 23, 2008 06:34 AM | 5 Comments | Permalink]

Parameters. parameters, parameters ... the mantra of db performance troubleshooting
Your database is horribly slow? Queries never end or abort after a far too long runtime? You encounter wrong values or other errors? Then it's time to check if your db instance is configured the right way. I'll show you how SAP notes can help you here. Lars Breddemann in SAP NetWeaver Platform, SAP Developer Network, SAP MaxDB and liveCache [Jan. 16, 2008 04:16 AM | 2 Comments | Permalink]

'Mind the gap ...'
What's different and what's similar on MaxDB and Oracle installations - compared from a practitioners point of view. Lars Breddemann in SAP NetWeaver Platform, SAP Developer Network, SAP MaxDB and liveCache [Dec. 06, 2007 06:50 AM | 3 Comments | Permalink]

MaxDB Internals Documentation available for free!
Ever wanted to know what ticks inside a MaxDB instance or what parameter is used for what? Get all the insight by reading my blog... ;-) Lars Breddemann in SAP Developer Network, SAP NetWeaver Platform, SAP MaxDB and liveCache [Nov. 19, 2007 06:45 AM | 1 Comments | Permalink]

Debugging the MaxDB Kernel on Windows - How to get a Call stack from hanging tasks
Ever wanted to really know what a Windows process is doing when it seems to hang? On Unix and Linux it's pretty easy with the onboard tools to get this kind of information. Windows does not bring these options out-of-the-box. Anyhow: it's possible, it's easy and today I'll show you how you can do it. Lars Breddemann in SAP Developer Network, SAP NetWeaver Platform, SAP MaxDB and liveCache [Nov. 15, 2007 04:38 AM | 1 Comments | Permalink]

MaxDB Database Studio 7.7 is available !
The long awaited download is finally there: MaxDB Database Studio 7.7.03 Build 18 ist available on the SAP Service Marketplace. Lars Breddemann in SAP NetWeaver Platform, SAP Developer Network, SAP MaxDB and liveCache [Oct. 15, 2007 04:48 AM | 2 Comments | Permalink]

Suck that data out ! Connect from Oracle to MaxDB
Getting data from one database into another can get tricky when the databases are on different DBMS. In this blog I demonstrate that it's still easy to access data in a MaxDB database from an Oracle instance. Lars Breddemann in SAP NetWeaver Platform, SAP Developer Network, SAP MaxDB and liveCache [Apr. 05, 2007 01:33 PM | 2 Comments | Permalink]