6 LOGFILE
=`grep LOG_FILE $CSQL_CONFIG_FILE| tail -1 | awk -F"=" '{ print $2 }'`
7 LOGDIR
=`dirname $LOGFILE`
9 echo "CSQL Server Stopped: " + `date` >>$LOGDIR/csqlserver.log
12 if [ "$OS" = "SunOS" ]
14 SQLPID
=`ps -ef | grep csqlsqlserver |head -1| awk -F" " '{ print $2 }'`
16 SQLPID
=`ps -e | grep csqlsqlserver |tail -1| awk -F" " '{ print $1 }'`
19 if [ "$SQLPID" != "" ]
31 if [ "$OS" = "SunOS" ]
33 REPLPID
=`ps -ef | grep csqlreplserver |head -1| awk -F" " '{ print $2 }'`
35 REPLPID
=`ps -e | grep csqlreplserver |tail -1| awk -F" " '{ print $1 }'`
37 if [ "$REPLPID" != "" ]
41 if [ "$OS" = "SunOS" ]
43 CACHEPID
=`ps -ef | grep csqlcacheserver |head -1| awk -F" " '{ print $2 }'`
45 CACHEPID
=`ps -e | grep csqlcacheserver |tail -1| awk -F" " '{ print $1 }'`
47 if [ "$CACHEPID" != "" ]
51 if [ "$OS" = "SunOS" ]
53 CSQLPID
=`ps -ef | grep csqlserver |head -1| awk -F" " '{ print $2 }'`
55 CSQLPID
=`ps -e | grep csqlserver |tail -1| awk -F" " '{ print $1 }'`
58 if [ "$CSQLPID" = "" ]
60 echo "returning early"
64 if [ "$OS" = "SunOS" ]
66 CSQLPID
=`ps -ef | grep csqlserver |head -1| awk -F" " '{ print $2 }'`
68 CSQLPID
=`ps -e | grep csqlserver |tail -1| awk -F" " '{ print $1 }'`
71 if [ "$CSQLPID" = "" ]
78 echo "stop server without force"
80 echo "stop server with force"
82 KEY
=`grep SYS_DB_KEY $CSQL_CONFIG_FILE| tail -1 | awk -F"=" '{ print $2 }'`
83 echo removing key
$KEY
85 KEY
=`grep USER_DB_KEY $CSQL_CONFIG_FILE| tail -1 | awk -F"=" '{ print $2 }'`
86 echo removing key
$KEY
88 KEY
=`grep ID_SHM_KEY $CSQL_CONFIG_FILE| tail -1 | awk -F"=" '{ print $2 }'`
89 echo removing key
$KEY
91 KEY
=`grep MSG_KEY $CSQL_CONFIG_FILE| tail -1 | awk -F"=" '{ print $2 }'`
92 echo removing message queue key
$KEY