2005/9/28, Manuel Reiter <[EMAIL PROTECTED]>: > 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.
Where exactly? Which parameters are affected? Btw, you can omit all the cats in your script. :-) Regards robert > 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] > > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
