How to startup Altibase automatically when booting from HP-UX#
Overview#
This section describes how to automatically startup Altibase when booting from HP-UX.
What is HP-UX Startup Script?#
In HP-UX, script files that are executed during system boot/shutdown are managed as follows.
- The actual script files that are executed at boot time exist in the /sbin/init.d directory.
- The configuration files for the above script files are in the /etc/rc.config.d directory. Each rc script has one configuration file and sets the definitions and values of variables necessary for script execution.
- Script files that are executed at boot time exist in the /sbin/rc*.d directory, and these files are symbolic links to the files in the /sbin/init.d directory.
How to write a script for automatic startup/stop of Altibase#
-
STEP 1#
Create the /etc/rc.config.d/altibase_conffile.
As described above, in this file, variables necessary for starting/shutdown of Altibase are defined and values are set.
The contents of this file are shown below.
ALTIBASE_HOME=/altibase/altibase_home; export ALTIBASE_HOME PATH=$ALTIBASE_HOME/bin:/usr/bin:/sbin; export PATH ALTIBASE_OWNER=altibase START_ALTIBASE=1If the user does not want to automatically start Altibase when booting HP-UX, set the value of START_ALTIBASE to 0. And if ALTIBASE_OWNER or ALTIBASE_HOME is changed, modify the altibase_conf file must be also modified.
-
STEP 2#
Create the /sbin/init.d/alti_start file. This file is a script that actually starts up Altibase by using the Altibase startup command.
#!/sbin/sh if [ -f /etc/rc.config.d/altibase_conf ] ; then . /etc/rc.config.d/altibase_conf fi ADMIN="${ALTIBASE_HOME}/bin/isql -u sys -p manager -sysdba -noprompt" ${ADMIN} << EOF startup quit EOF -
STEP 3#
Create the /sbin/init.d/alti_stop file. This file is a script that actually shuts down Altibase by using the Altibase shutdown command.
#!/sbin/sh if [ -f /etc/rc.config.d/altibase_conf ] ; then . /etc/rc.config.d/altibase_conf fi ADMIN="${ALTIBASE_HOME}/bin/isql -u sys -p manager -sysdba -noprompt" FUNC_CHECK_ISQL_CONN() { case $ISQL_CONNECTION in [Ii][Pp][Cc]) unset ISQL_CONNECTION ;; *) ;; esac } # Permit sysdba via IPC FUNC_CHECK_ISQL_CONN ${ADMIN} << EOF > /dev/null ALTER SYSTEM SET CHECKPOINT_BULK_WRITE_PAGE_COUNT = 0; ALTER SYSTEM SET CHECKPOINT_BULK_WRITE_SLEEP_SEC = 0; ALTER SYSTEM SET CHECKPOINT_BULK_WRITE_SLEEP_USEC = 0; quit; EOF killCheckServer > ${ALTIBASE_HOME}/trc/killCheckServer.log 2>&1 ${ADMIN} << EOF shutdown immediate; quit; EOF -
STEP 4#
Create the /sbin/init.d/altibase file.
This file can be created by copying the /sbin/init.d/template file, which is actually the file that the Start/Stop script will create symbolic links later on.#!/sbin/sh # # @(#)B.11.11_LR # # NOTE: This script is not configurable! Any changes made to this # script will be overwritten when you upgrade to the next # release of HP-UX. # # WARNING: Changing this script in any way may lead to a system that # is unbootable. Do not modify this script. # rval=0 # Check the exit value of a command run by this script. If non-zero, the # exit code is echoed to the log file and the return value of this script # is set to indicate failure. set_return() { x=$? if [ $x -ne 0 ]; then echo "EXIT CODE: $x" rval=1 # script FAILed fi } # Kill the named process(es). # $1= killproc() { pid=`ps -el | awk '(($NF ~ /'"$1"'/) && ($4 != mypid) && ($5 != mypid)) {print $4}' mypid=$$ ` if [ "X$pid" != "X" ]; then if kill "$pid"; then echo "$1 stopped" else rval=1 echo "Unable to stop $1" fi fi } case $1 in 'start_msg') # Emit a _short_ message relating to running this script with # the "start" argument; this message appears as part of the checklist. echo "Starting the Altibase Database" ;; 'stop_msg') # Emit a _short_ message relating to running this script with # the "stop" argument; this message appears as part of the checklist. echo "Stopping the Altibase Database" ;; 'start') # source the system configuration variables if [ -f /etc/rc.config.d/altibase_conf ] ; then . /etc/rc.config.d/altibase_conf else echo "ERROR: /etc/rc.config defaults file MISSING" fi # Check to see if this script is allowed to run... if [ "$START_ALTIBASE" != 1 ]; then rval=2 else # Execute the commands to start your subsystem su - $ALTIBASE_OWNER -c "/sbin/init.d/alti_start" fi ;; 'stop') # source the system configuration variables if [ -f /etc/rc.config.d/altibase_conf ] ; then . /etc/rc.config.d/altibase_conf else echo "ERROR: /etc/rc.config defaults file MISSING" fi # Check to see if this script is allowed to run... if [ "$START_ALTIBASE" != 1 ]; then rval=2 else su - $ALTIBASE_OWNER -c "/sbin/init.d/alti_stop" # Execute the commands to stop your subsystem fi ;; *) echo "usage: $0 {start|stop|start_msg|stop_msg}" rval=1 ;; esac -
STEP 5#
Create Symbolic Link of Startup Script and Shutdown Script in /sbin/rc2.d directory.
# cd /sbin/rc2.d # ln -s /sbin/init.d/altibase S955altibase # ln -s /sbin/init.d/altibase K955altibase -
STEP 6#
Modify the execution permission so that each script can be executed normally.
# cd /sbin/rc2.d # chmod 755 S955altibase # chmod 755 K955altibase # cd /sbin/init.d # chmod 755 *alti* -
STEP 7#
Test to see if it works properly. At this time, the test must be performed under the root account.
# su - root # /sbin/init.d/altibase