This is the best documentation I've found on creating a maxdb instance. It also has other installation instructions.
http://www.transporeon.org/download/sapdb/maxdb_installation_administrat ion.pdf I was working with another person. He actually installed the maxdb software. I built the database. He said he made other changes based on earlier sections of this document, that might have to do with environment variable settings, such as LD_ASSUME_KERNEL, and library path settings. He could not remember what he did. These instructions from the document did not work exactly. I don't exactly recall. It had to do with the database user name, which below is dbm, password dbm. I haven't figure out what the database user names are in maxdb. __________________________________________________________ 3.1 Creating A MaxDB Instance 3.1.2 with MaxDB DBMCLI Set MaxDB parameters: export SID=TEST01 export INSTROOT=/opt/sdb/7500 export RUNDIRECTORY=/var/opt/sdb/data/wrk/$SID Start the x_server: /opt/sdb/programs/bin/x_server start Drop existing instance of same name: /opt/sdb/programs/bin/dbmcli -d $SID -u dbm,dbm db_offline /opt/sdb/programs/bin/dbmcli -d $SID -u dbm,dbm db_drop Create a new database instance: /opt/sdb/programs/bin/dbmcli -s -R $INSTROOT db_create $SID dbm,dbm Create directories and set permissions: mkdir -p $RUNDIRECTORY chown sdb:sdba $RUNDIRECTORY chmod 770 $RUNDIRECTORY Set database instance parameters and create data and log volume(s): /opt/sdb/programs/bin/dbmcli -d $SID -u dbm,dbm -i create_db content of file create_db: param_startsession param_init OLTP param_put CAT_CACHE_SUPPLY 300 param_put CACHE_SIZE 15000 param_put MAXDATAVOLUMES 5 param_put MAXUSERTASKS 20 param_checkall param_commitsession param_addvolume 1 DATA DAT_0001 F 10240 param_addvolume 1 LOG LOG_0001 F 1024 db_admin util_connect db_activate dba,dba util_release load_systab -ud domain quit Change mode to ONLINE: /opt/sdb/programs/bin/dbmcli -d $SID -u dbm,dbm db_online Register backup media, backup database and enable autosave: /opt/sdb/programs/bin/dbmcli -d $SID -u dbm,dbm -i backup_db content of file backup_db: medium_put data datasave FILE DATA 0 8 YES medium_put auto autosave FILE AUTO util_connect dbm,dbm backup_save data autosave_on quit If you prefer to use the "overwrite" log mode execute: /opt/sdb/programs/bin/dbmcli -d $SID -u dbm,dbm util_execute set log auto overwrite on -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
