Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
SAP DB How To
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Documentation, Tips & Tricks
View previous topic :: View next topic  
Author Message
tuXXer
Tux's lil' helper
Tux's lil' helper


Joined: 23 Apr 2003
Posts: 83

PostPosted: Sun Jul 06, 2003 12:32 pm    Post subject: SAP DB How To Reply with quote

1. Download SAP DB and install SAP DB with SDBINST
2. Create file /etc/init.d/sapdb, source:

#!/sbin/runscript

depend() {
need net
use dns
}

start() {
ebegin "Starting SAP DB"
echo "Starting SAP DB database server..."
su - ${SAP_USER} -c "${SAP_INDEP_PROG_PATH}/bin/x_server ${SAP_START} >/dev/null 2>&1"
if [ "${SAP_DATABASES}" != "" ]; then
for DATABASE in ${SAP_DATABASES}; do
echo -n "Starting SAP DB database instance '${DATABASE}'..."
su - ${SAP_USER} -c "${SAP_DEPEND_PATH}/bin/dbmcli -d ${DATABASE} -u ${SAP_DBM_USER},${SAP_DBM_PASSWORD} db_warm 2>&1"
done
fi
if [ "${SAP_START_WEBTOOLS}" == true ]; then
echo "Starting SAP DB Webtools..."
su - ${SAP_USER} -c "${SAP_INDEP_PROG_PATH}/web/pgm/wahttp -f ${SAP_WEBTOOLS_CONFIG} >/dev/null 2>&1 & sleep 2"
fi
eend $?
}

stop () {
ebegin "Stopping SAP DB"
if [ "${SAP_START_WEBTOOLS}" == true ]; then
echo "Stopping SAP DB Webtools..."
killall wahttp >/dev/null 2>&1
fi
if [ "${SAP_DATABASES}" != "" ]; then
for DATABASE in ${SAP_DATABASES}; do
echo -n "Stopping SAP DB database instance '${DATABASE}'..."
su - ${SAP_USER} -c "${SAP_DEPEND_PATH}/bin/dbmcli -d ${DATABASE} -u ${SAP_DBM_USER},${SAP_DBM_PASSWORD} db_stop 2>&1"
done
fi
echo "Stopping SAP DB database server..."
su - ${SAP_USER} -c "${SAP_INDEP_PROG_PATH}/bin/x_server ${SAP_STOP} >/dev/null 2>&1"
eend $?
}


3. Create file /etc/conf.d/sapdb and change according to your settings, source:

# Where your SAP DB database server is located
SAP_DEPEND_PATH=/opt/sapdb/depend
SAP_INDEP_DATA_PATH=/opt/sapdb/indep_data
SAP_INDEP_PROG_PATH=/opt/sapdb/indep_prog

# SAP DB's User
SAP_USER=sapdb

# Start/Stop commands
SAP_START=start
SAP_STOP=stop

# Start Webtools
SAP_START_WEBTOOLS=true

# Location of Webtools configuration file
SAP_WEBTOOLS_CONFIG=/usr/spool/sql/ini/WebAgent74.ini

# Loading SAP DB database instances
SAP_DATABASES=""

# SAP DB DBM user
SAP_DBM_USER="dbm"
SAP_DBM_PASSWORD="dbm"

4. Create /etc/env.d/40sapdb and change according to your settings, source:

PATH=/opt/sapdb/depend/bin:/opt/sapdb/depend/pgm:/opt/sapdb/indep_prog/bin:/opt/sapdb/indep_prog/pgm:/opt/sapdb/indep_prog/web/pgm
ROOTPATH=/opt/sapdb/depend/bin:/opt/sapdb/depend/pgm:/opt/sapdb/indep_prog/bin:/opt/sapdb/indep_prog/pgm:/opt/sapdb/indep_prog/web/pgm
LDPATH=/opt/sapdb/depend/lib:/opt/sapdb/indep_prog/lib:/opt/sapdb/indep_prog/web/lib

5. Run env-update

Ét voilà it should run.
Back to top
View user's profile Send private message
tuXXer
Tux's lil' helper
Tux's lil' helper


Joined: 23 Apr 2003
Posts: 83

PostPosted: Tue Jul 08, 2003 8:33 am    Post subject: Now working on an ebuild Reply with quote

I'm working on an ebuild for SAP DB, now, but it takes a while, because the SAP installer isn't usefull for manual install. Here are the steps and states:

1st Phase:
Runlevel scripts and environment variable
=> done

2nd Phase:
Base server install
=> inprogress

3rd Phase:
Writing database instance installer
=> standby

4th Phase:
Webtools install
=> standby

5th Phase:
JDBD driver install
=> standby

6th Phase:
ODBC driver install
=> open

7th Phase:
Python modules install
=> open
Back to top
View user's profile Send private message
starbecks
n00b
n00b


Joined: 30 Mar 2003
Posts: 45

PostPosted: Wed Aug 27, 2003 10:24 am    Post subject: SAPDB ebuild Reply with quote

I was working with SAPDB on a project last year. Once I finally got it running (on MSW and Suse), it seemed to work very well. I liked the mix of the power and tuning like Oracle and the open source spirit like MySQL. A new project is coming up that looks like SAPDB may be a good fit. I've since moved all boxen to Gentoo and would like to know...

tuXXer,
You mentioned you are working on an ebuild for SAPDB. How's the progress? Anything I can do to help?

Is anyone else working on an ebuild for SAPDB?
-
Back to top
View user's profile Send private message
pennedinil
Tux's lil' helper
Tux's lil' helper


Joined: 08 Aug 2003
Posts: 95

PostPosted: Sat Aug 30, 2003 8:39 am    Post subject: Reply with quote

anyone compile SAP DB from source?
Back to top
View user's profile Send private message
tuXXer
Tux's lil' helper
Tux's lil' helper


Joined: 23 Apr 2003
Posts: 83

PostPosted: Mon Sep 01, 2003 4:48 pm    Post subject: The problem is... Reply with quote

Today, I've hadn't found a way to create the SAP DB registry which would be created through the installer (combined with perl). The registry is rewritten every time when a program or tool of SAP DB is updated, added, removed aso. Compiling wasn't the problem, but a compiled SAP DB without registry didn't work. So no ideas for getting on...
Back to top
View user's profile Send private message
pilla
Bodhisattva
Bodhisattva


Joined: 07 Aug 2002
Posts: 7729
Location: Underworld

PostPosted: Tue Sep 02, 2003 11:54 am    Post subject: Reply with quote

moved to Docs, Tips & Tricks

thanks, pYrania
_________________
"I'm just very selective about the reality I choose to accept." -- Calvin
Back to top
View user's profile Send private message
berarul
Tux's lil' helper
Tux's lil' helper


Joined: 12 Apr 2004
Posts: 75
Location: Bucuresti

PostPosted: Sun Apr 25, 2004 2:18 pm    Post subject: Reply with quote

There seems to be a prallel building effort of a maxdb ebuild
Code:

http://forums.gentoo.org/viewtopic.php?t=122009&highlight=maxdb


However, in my experience MaxDB is too unstable (MySQL says that it is to be used only by developers).
I would like to help out with an ebuild for SapDB. I tried it alone and I failed, though.
_________________
You need to stand up to your mother, smack her in the face and say "That's enough of your shit, you fucking bitch!"
Back to top
View user's profile Send private message
mundi
n00b
n00b


Joined: 27 Jun 2003
Posts: 60

PostPosted: Wed May 26, 2004 10:12 pm    Post subject: Reply with quote

berarul wrote:
There seems to be a prallel building effort of a maxdb ebuild
Code:

http://forums.gentoo.org/viewtopic.php?t=122009&highlight=maxdb


However, in my experience MaxDB is too unstable (MySQL says that it is to be used only by developers).
I would like to help out with an ebuild for SapDB. I tried it alone and I failed, though.


Hi!

As you allready have noticed i did an ebuild for maxdb to build it from sources - you can find it in the bug system as described in the link that you gave above.
Right now i am working on a version for 7.5.00.12 - will be finished soon.
We are having problems compiling from sources on systems that where installed from 2004.x gentoo distributions. If you want to help, every testing effort would be appreciated.
Just one remark - calling maxdb unstable is a rather daring statement. We are running large SAP installations with hundreds of users on the basis of maxdb and linux. In my experience it is as stable as any other enterprise grade db-system (including ORACLE).

have fun - mundi
Back to top
View user's profile Send private message
berarul
Tux's lil' helper
Tux's lil' helper


Joined: 12 Apr 2004
Posts: 75
Location: Bucuresti

PostPosted: Thu May 27, 2004 12:06 am    Post subject: Reply with quote

Well actually you're right. At the time I was very pissed off at MySQL at the time since the Windows version worked without any hassle MaxDB v 7.5.00.05 was a bitch to get going on Linux systems, while SapDB v 7.4 worked beautifully on Linux.

Will try your e-build as soon as the free-time package finishes emerging :D.
Since you run such big installations, have you ever compared the SAP on Linux to SAP on windows? Performance and stability alike?
Just being curious.[/quote]
_________________
You need to stand up to your mother, smack her in the face and say "That's enough of your shit, you fucking bitch!"
Back to top
View user's profile Send private message
mundi
n00b
n00b


Joined: 27 Jun 2003
Posts: 60

PostPosted: Thu May 27, 2004 5:55 am    Post subject: Reply with quote

berarul wrote:

Since you run such big installations, have you ever compared the SAP on Linux to SAP on windows? Performance and stability alike?
Just being curious.

Dont missunderstand this as an offical statement its just my personal statement. SAP installation are significant faster and more relyable on the linux/maxdb platform compared to the windows/maxdb platform. It is definitly my prefered scenario for large SAP installations.
Nowadays i prefer this platform over all other possible supported os/db-system combinations. Only in high load 24/7 all year situations oracle might still be a better choice because of the redo-log system that is a bit more flexible.

have fun (btw. the ebuild for 7.5.0.12 is finished and can be found in bugs.gentoo.org)
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Documentation, Tips & Tricks All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum