Re: How to make MAXDB database instance auto start in state ONLINE when start up?

Hi David !

You can use something like the following init script:
Remarks: 
*) i change the actual username and password to <username>,<password>
*) this is a gentoo linux runscript but a normal init script
in /etc/init.d would look similar
----
#!/sbin/runscript

start() {
        echo -n "starting maxdb service:"
        LD_LIBRARY_PATH="/opt/sdb/programs/lib:${LD_LIBRARY_PATH}"
        export LD_LIBRARY_PATH
        PATH="${PATH}:/opt/sdb/programs/bin" export PATH
        cd /opt/sdb/programs/pgm
# start the web-server (needs /usr/spool/sql/ini/WebAgent75.ini to be
configured !!!)
        ./wahttp & > /dev/null 2>&1
# start the x_server
        /opt/sdb/programs/bin/x_server -Y start > /dev/null 2>&1
# startup db-instance BCO
        /opt/sdb/programs/bin/dbmcli -d bco -u <username>,<password>
db_warm  > /dev/null 2>&1
        exit 0
}

stop() {
        echo -n "stoping maxdb service:"
# set the db-instance BCO offline
        /opt/sdb/programs/bin/dbmcli -d bco -u <username>,<password>
db_stop  > /dev/null 2>&1
# stop the x_server
        /opt/sdb/programs/bin/x_server -Y stop  > /dev/null 2>&1
# kill the web service
        killall wahttp  > /dev/null 2>&1
        exit 0
}
----

You can do about everything to your maxdb system from the command line
using the command "dbmcli" so i'd suggest you'll read some of its
documentation.

regards mundi

---
Am Freitag, den 21.01.2005, 14:37 +0100 schrieb David Pérez Gómez:

> Hello.
> 
> May I know how to auto startup a database instance whenever my OS (LINUX)
> start up ?
> 
> Currently, I have to launch the database manager application and
> manually turn my database instance into online mode.
> 
> I have installed MAXDB in my machine with the following configuration:
> 
> - Pentium IV 1500 Mhz with SUSE LINUX 9, that works as database server.
> - MaxDB 7.5.00.15
> 
> 
> Thanks for your help.
> 
> regards,
> 
> 
>