hi all, (cc: binarycloud-dev) forgive the oracle nomanclature, but I'm used to it :)
I'm trying to create a new DB, and I need to make sure that I have control over how big the files can get and how they are extended. I'm using the create test db script that comes with the latest version, and I don't see anything obvious that I can change. echo "set parameters for $SID..." _o=`cat <<EOF | dbmcli -d $SID -u dbm,dbm 2>&1 param_rmfile //removes current parameter file if there is one param_startsession // starts up a config session for me param_init OLTP // didn't see any mention of the 'OLTP' or other params in the docs param_put LOG_MODE SINGLE param_put CAT_CACHE_SUPPLY 300 param_put DATA_CACHE 2500 param_put MAXDATADEVSPACES 5 param_put MAXDATAPAGES 1024000 // I don't see any listing of these params in the documentation... actually I would really prefer to see a 'function reference' for DBMCLI. param_checkall param_commitsession // check, commit changes param_adddevspace 1 SYS /u01/db/$SID/DISKS01 F param_adddevspace 1 DATA /u01/db/$SID/DISKD0001 F 2560 param_adddevspace 1 LOG /u01/db/$SID/DISKL001 F 1024 // this seems to be what I'm interested in, but I can't find any way to // control anything but the initial size. Help? :) _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
