Hi Everyone !

The aim of this document ist to help people install MaxDB on gentoo systems from sources.
This is a very long running process (about 10h) and it can not be done totaly automatic.
The ebuilds that i provide need interaction at a given point where they will tell you what to do.

This is meant as an alternativ to installing the binary version an using the LD_ASSUME_KERNEL hack.
It is meant to be used by people who dont mind spending their time in endles compilation sessions

If you do not know why you should use MaxDB read John L. Singleton's "Musings on MaxDB, Five Reasons Why MaxDB Will Replace Your Current Database"
(http://www.johnsingleton.com/maxdb/2004/06/five-reasons-why-maxdb-will-replace.html).

The following points should help you to install maxdb.
I.) Before you start:
THIS EBUILDS DO NOT SUPPORT UPDATES.
If you have a running MaxDB instance on your system then:
- BACKUP YOUR DATA
- move the directory /opt/sdb to something like /opt/sdb.off
- move the directory /usr/spool/sql to something like /usr/spool/sql.off
- move the file /etc/opt/sdb to something like /etc/opt/sdb.off

II.) portage principle
1.) ebuilds that are not allready in the portage tree should be copied to a so called portage overlay directory.
if you do not allready have on, do the following:
- create a overlay directory. (normaly /usr/local/portage)
- add the overlay directory to you /etc/make.conf by adding a line like PORTDIR_OVERLAY=/usr/local/portage

2.) creating directories in the overlay directory
you should create directories for the ebuilds in the overlay directory:
- create a directory /usr/local/portage/dev-db/maxdb-devtools-src for the devtools.
- create a directory /usr/local/portage/dev-db/maxdb-src for the db-system

III.) Get the ebuilds
the ebuild you will need can be found in the bug system (bugs.gentoo.org).
-> bug 42286 for the devtools
-> bug 42465 for the db-system

1. Download the ebuilds into the directories:
- download maxdb-devtools-src-528670.ebuild from bug 42286 and put it to /usr/local/portage/dev-db/maxdb-devtools-src
- download maxdb-src-7.5.0.18.ebuild from bug 42465 and put it to /usr/local/portage/dev-db/maxdb-src
- create a /usr/local/portage/dev-db/maxdb-src/files directory for the patches 
- download maxdb-source-7_5_0_18_all.patch from bug 42465 and put it to /usr/local/portage/dev-db/maxdb-src/files
- download maxdb-source-7_5_0_18_ini.patch from bug 42465 and put it to /usr/local/portage/dev-db/maxdb-src/files

IV) Installation
0. Remarks
Both of the ebuilds require user action in the middle of the process.
Actually the build process itself can not be started by the ebuild.
I do not know why yet but if i start the build process (the imf tool to be more precise) the imf (a perl script) will consume most of your processors time but will not start the build process.
Maybe i will find a solution for this, but i did not up to know.

1. Keywords
Both ebuils are masked with the keyword ~x86 (as they should be because they are not included in the official portage tree).
Add them to the /etc/portage/package.keywords by doing a:
- execute "echo dev-db/maxdb-devtools-src ~x86 >> /etc/portage/package.keywords"
- execute "echo dev-db/maxdb-src ~x86 >> /etc/portage/package.keywords"

2. install the devtools
- go to the /usr/local/portage/dev-db/maxdb-devtools-src directory

create the digest:
- execute "ebuild maxdb-devtools-src-528670.ebuild digest"

emerge the devtools:
- execute "emerge maxdb-devtools-src"

The ebuild will stop in the after unpacking the sources and confinguring the package and tell you what do to.
Open a second terminal and follow the steps given in the first.
You can ignore the warning and error in the and off the make process about the global SapDB registry it will be created by the ebuild later.
When the make process ends, go back to the first terminal and press ENTER.

If this worked you should have your devtools in /opt/sdb/devtools. 

3. Install the db system
FIRST (AGAIN): if you allready have a maxdb installation (or SAPDb) SAVE YOUR DATA !!!!
- go to the /usr/local/portage/dev-db/maxdb-src directory

create the digest:
- execute "ebuild maxdb-src-7.5.0.18.ebuild digest"

emerge the db-system:
- execute "emerge maxdb-src"

The ebuild will stop in the after unpacking the sources and confinguring the package and tell you what do to.
Open a second terminal and follow the steps given in the first.
- go to bed or to the next bar (you have got about 5 to 10 hours time now) :-))

When the build process ends, go back to the first terminal and press ENTER.
- in the end of the installation the ebuild will give some informations - follow them

When everthing works fine you got it.

V) Post Installation
1. Database Installation
If you know dont khow to create a database instance 
- look at http://dev.mysql.com/doc/maxdb/index.html and follow the link "How to Create a MaxDB Instance".

The last command "load_systab" still does not work from within dbmcli you have to execute 
"/opt/sdb/programs/bin/x_python /opt/sdb/programs/env/lsystab.py -u <dba_user>,<dba_user_password> -d <DBNAME> -R /opt/sdb/programs"
from outside of dbmcli.

2. Information
Another very good source of information is http://sapdb.2scale.net the MaxDb Wiki Page

3. (And by god not least) THANX
Thanks to everybody who helped and still helps me to create and test this ebuilds.
Special thanks to:
*) Daniel Dittmar from SAP Labs Berlin - he is the guy who knows.
*) oldie, domlogic, cchee and the other guys from the forum who must have spent days testing the ebuils (big thanx guys)

If you have any problems or need help in what ever way fell free to contact me directly (hmun@thinkthinkdo.com) or even better post a forum message.

Last remark:
English is not my native language. So if there are typos or grammar erros please provide feedback.

Have fun - looking forward to your feedback - Mundi