On Fri, 2003-09-12 at 14:45, Joe Garrett wrote:
> Hello,
>
> I have SAPDB 7.4 installed on Windows XP. I've used the DB Manager to
> create 3 instances. I'm having problems that make sapdb unusable.
>
> 1. How do I delete an instance? I cannot find this in any of the
> documentation?
I use the following script. This is for unix, but you can easily figure
out a windows equivalent :
test "$UID" = "0" && {
echo "Please call me as user 'sapdb'."
exit 1
}
test -z "$1" && {
echo "Usage: dropdb <dbname>"
exit
}
export SERVERDB=${1:-TST}
SERVERDB=`echo $SERVERDB|tr a-z A-Z`
export SERVERDATA=2560
export SERVERLOG=1024
export SERVERPATH=/usr/sapdb/indep_data/wrk/$SERVERDB
# . /etc/profile.d/sapdb.sh
test -d $SERVERPATH || {
echo "Database '$SERVERDB' does not exist."
exit 1
}
# start remote communication server
x_server start >/dev/null 2>&1
echo "Switching $SERVERDB to offline mode:"
dbmcli -d $SERVERDB -u dbm,dbm db_offline
echo "Dropping $SERVERDB:"
dbmcli -d $SERVERDB -u dbm,dbm db_drop >/dev/null
test $? = 0 && echo "OK" || echo "not ok"
echo "Removing files:"
rm -rf /usr/indep_data/wrk/$SERVERDB &&
rm -f /usr/sapdb/depend/pgm/db:$SERVERDB &&
rm -f /etc/rc2.d/sapdb:$SERVERDB
test $? = 0 && echo "OK" || echo "not ok"
>
> 2. How do I completely remove sapdb from my computer?
The archive of this list is pretty verbose on that matter.
>
> 3. When I was loading data to a table, the database locked up. There were
Check the archive for autolog and lockup.
>
> Any help would be appreciated.
>
> Joe Garrett
> Minnesota, USA
>
>
>
> _______________________________________________
> sapdb.general mailing list
> [EMAIL PROTECTED]
> http://listserv.sap.com/mailman/listinfo/sapdb.general
>
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
