Hi,
I want to change my database from SAPDB 7.3 to MAXDB 7.6
but a few parameter names seemed to have changed and I'm not too
familiar with the new ones.
This is the script I use for SAPDB 7.3, the errors occur in the
parameter setting section.
best regards Manuel
--------------------------------------------------------------------------------------
SAPDB_HOME=/opt/sapdb
export PATH=$SAPDB_HOME/indep_prog/bin:$PATH
#set -x
# name of the database
# ATTENTION - SID MAXLENGTH = 8!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
SID=ZIBDB
HOME=/data/dbuserspace
INST=$SAPDB_HOME/depend
DBM_LOGIN=dbmlogin
DBM_PASS=dbmpass
DBA_LOGIN=dbalogin
DBA_PASS=dabpass
SQL_LOGIN=sqllogin
SQL_PASS=sqlpass
DATA_SIZE=50000
LOG_SIZE=10000
BACKUPDIR=/data/dbbackup
echo start remote communication server
x_server start
echo "create new database: $SID"
dbmcli -s -R $INST db_create $SID $DBM_LOGIN,$DBM_PASS || exit 1
echo "create directory where to put the database files $HOME/$SID"
mkdir -p $HOME/$SID
echo setup database parameters
cat <<EOF | dbmcli -d $SID -u $DBM_LOGIN,$DBM_PASS
param_rmfile
param_startsession
param_init OLTP
param_put LOG_MODE SINGLE
param_put CAT_CACHE_SUPPLY 300
param_put DATA_CACHE 10000
param_put MAXDATADEVSPACES 5
param_put MAXDATAPAGES 1024000
param_put MAXUSERTASKS 90
param_put MAXCPU 1
param_checkall
param_commitsession
param_adddevspace 1 SYS $HOME/$SID/SYS F
param_adddevspace 1 DATA $HOME/$SID/DATA01 F $DATA_SIZE
param_adddevspace 1 LOG $HOME/$SID/LOG01 F $LOG_SIZE
quit
EOF
echo initialize database files and starts it!
cat <<EOF | dbmcli -d $SID -u $DBM_LOGIN,$DBM_PASS
db_start
util_connect $DBM_LOGIN,$DBM_PASS
util_execute init config
util_activate $DBA_LOGIN,$DBA_PASS
quit
EOF
echo load database system tables
dbmcli -d $SID -u $DBM_LOGIN,$DBM_PASS load_systab -ud domain
echo create database demo user
cat <<EOF | dbmcli -d $SID -u $DBA_LOGIN,$DBA_PASS
sql_connect $DBA_LOGIN,$DBA_PASS
sql_execute CREATE USER $SQL_LOGIN PASSWORD $SQL_PASS DBA NOT EXCLUSIVE
EOF
echo sql_execute CREATE USER $SQL_LOGIN PASSWORD $SQL_PASS DBA NOT EXCLUSIVE
echo create backup
mkdir -p $BACKUPDIR/$SID
cat <<EOF | dbmcli -d $SID -u $DBM_LOGIN,$DBM_PASS
backup_media_put data $BACKUPDIR/$SID/datasave FILE DATA 0 8 YES
backup_media_put log $BACKUPDIR/$SID/autosave FILE LOG
util_connect $DBM_LOGIN,$DBM_PASS
backup_start data MIGRATION
backup_start log
autolog_on log
quit
EOF
exit 0
------------------------------------------
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
