Hi, I'm in the process of creating a database instances for production use.
The machine I have is a Sun E250 with 6X36GB harddrives, two processors and
2GB's of ram. I'm going to use RAID1 on all the drives which will leave me
with 3X36GB drives. I have put the OS on a disk by it's self with a 6GB
partition. That leaves me two separate disks for the database devspaces and
30GB's on the disk that the OS is installed on. I've created five
partitions:
/data/data01 = /dev/rdsk/c0t9d0s3 ->30GB
/data/data02 = /dev/rdsk/c0t11d0s1 -> 30GB
/data/log01 = /dev/rdsk/c0t9d0s1 -> 2GB
/data/log02 = /dev/rdsk/c0t11d0s0 -> 2GB
/data/sys = /dev/rdsk/c0t9d0s0 -> 2GB
Now I'm in the process of modifying the demo script that came with the
database. This is the part I'm not sure of. This server will be used for
this database only and maybe one demo database that I will use for
development. I'm setting this script to use raw devices. I have a 20GB
uncompressed and 40GB compressed tape drive that will be backing up the
database. Could someone look at all this and tell me if I'm going in the
right direction. Any help would be greatly appreciated. Here's the script:
#!/bin/sh
###
# create database
###
id=`id | sed s/\(.*// | sed s/uid=//`
if [ "$id" = "0" ]; then
echo "dont start script as root " 1>&2
exit 1
fi
if [ "$HOME" = "" ]; then
USER=`id | sed s/^.*\(// | sed s/\).*//`;export USER
HOME=`echo ~$USER`;export HOME
if [ "$HOME" = "" ]; then
echo "cannot find ${USER}s home directory - set HOME in environment and
retry" 1>&2
exit 1
fi
fi
INSTROOT=/usr/sapdb/depend
PATH=/usr/sapdb/indep_prog/bin:$PATH
export PATH
# name of the database
SID=VUDMS
# start remote communication server
x_server start >/dev/null 2>&1
# stop and drop probably existing demo database
dbmcli -d $SID -u dbm,dbm db_offline >/dev/null 2>&1
dbmcli -d $SID -u dbm,dbm db_drop >/dev/null 2>&1
# create new demo database
echo "create database $SID..."
_o=`dbmcli -s -R $INSTROOT db_create $SID dbm,dbm 2>&1`
_test=`echo $_o | grep OK`
if [ "$_test" = "" ]; then
echo "create $SID failed: $_o" 1>&2
exit 1
fi
# create directory where to put the database files
mkdir -p /data/sys/$SID
mkdir -p /data/data01/$SID
mkdir -p /data/data02/$SID
mkdir -p /data/log01/$SID
mkdir -p /data/log02/$SID
# setup database parameters
echo "set parameters for $SID..."
_o=`cat <<EOF | dbmcli -d $SID -u dbm,dbm 2>&1
param_rmfile
param_startsession
param_init OLTP
param_put LOG_MODE SINGLE
param_put CAT_CACHE_SUPPLY 300
param_put DATA_CACHE 2500
param_put MAXDATADEVSPACES 30
param_put MAXDATAPAGES 1024000
param_checkall
param_commitsession
param_adddevspace 1 SYS data/sys/$SID/SYS01 F
param_adddevspace 1 DATA dev/rdsk/c0t9d0s3/$SID/DATA0001 R 62500
param_adddevspace 1 DATA dev/rdsk/c0t11d0s1/$SID/DATA0002 R 62500
param_adddevspace 1 DATA dev/rdsk/c0t9d0s3/$SID/DATA0003 R 62500
param_adddevspace 1 DATA dev/rdsk/c0t11d0s1/$SID/DATA0004 R 62500
param_adddevspace 1 DATA dev/rdsk/c0t9d0s3/$SID/DATA0005 R 62500
param_adddevspace 1 DATA dev/rdsk/c0t11d0s1/$SID/DATA0006 R 62500
param_adddevspace 1 DATA dev/rdsk/c0t9d0s3/$SID/DATA0007 R 62500
param_adddevspace 1 DATA dev/rdsk/c0t11d0s1/$SID/DATA0008 R 62500
param_adddevspace 1 LOG dev/rdsk/c0t9d0s1/$SID/LOG001 R 31250
param_adddevspace 1 LOG dev/rdsk/c0t11d0s0/$SID/LOG002 R 31250
quit
EOF`
_test=`echo $_o | grep ERR`
if [ "$_test" != "" ]; then
echo "set parameters failed: $_o" 1>&2
exit 1
fi
# startup database
echo "start $SID..."
_o=`dbmcli -d $SID -u dbm,dbm db_start 2>&1`
_test=`echo $_o | grep OK`
if [ "$_test" = "" ]; then
echo "start $SID failed: $_o" 1>&2
exit 1
fi
# initialize database files
echo "initialize $SID..."
_o=`cat <<EOF | dbmcli -d $SID -u dbm,dbm 2>&1
util_connect dbm,dbm
util_execute init config
util_activate dba,dba
quit
EOF`
_test=`echo $_o | grep ERR`
if [ "$_test" != "" ]; then
echo "initializing $SID failed: $_o" 1>&2
exit 1
fi
# load database system tables
echo "load system tables..."
_o=`dbmcli -d $SID -u dbm,dbm load_systab -u dba,dba -ud domain 2>&1`
_test=`echo $_o | grep OK`
if [ "$_test" = "" ]; then
echo "load system tables failed: $_o" 1>&2
exit 1
fi
# create database demo user
echo "create database demo user..."
_o=`cat <<EOF | dbmcli -d $SID -u dba,dba
sql_connect dba,dba
sql_execute CREATE USER test PASSWORD test DBA NOT EXCLUSIVE
EOF`
_test=`echo $_o | grep ERR`
if [ "$_test" != "" ]; then
echo "create db user failed: $_o" 1>&2
exit 1
fi
echo "set backup parameters..."
_o=`cat <<EOF | dbmcli -d $SID -u dbm,dbm 2>&1
medium_put data $HOME/$SID/datasave FILE DATA 0 8 YES
medium_put auto $HOME/$SID/autosave FILE AUTO
util_connect dbm,dbm
backup_save data
autosave_on
quit
EOF`
_test=`echo $_o | grep ERR`
if [ "$_test" != "" ]; then
echo "set backup parameters failed: $_o" 1>&2
exit 1
fi
exit 0
Thank You,
Justin A. Stanczak
Web Manager
Shake Learning Resource Center
Vincennes University
(812)888-5813
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
