Hi, I have a dedicated SAPDB server, dual processor (Intel Pentium 3 @ 1.26Ghz). Windows 2000 Server, Service Pack 2 and all latest Windows Update patches (as of May 21, 2002). I downloaded the latest SAPDB on May 21, 2002 - version 7.3.00.23. Clean Windows 2000 install and SAPDB install. The server is constructed with a Intel SCB2 mainboard, latest BIOS.
I am attempting to create the largest DATA_CACHE possible. The system itself is using less than 90MB of RAM after boot up. I am finding out that SAPDB won't let me use more than 1650MB of RAM for DATA_CACHE value (211200 8K pages) . Actually it fails at 1700MB, I haven't tried any values between 1650MB and 1700MB. Here is my script for creating the database: ==== begin database create script ===== set SID=ESMDB1 set DATA=f:\sapdb\data set DBLOG=d:\sapdb\log rem passwords set user1=user1 set user1PW=****** x_server start 1> NUL 2> NUL dbmcli -R %INSTPATH% db_create %SID% dbm,dbm md %DATA% md %DBLOG% md %DATA%\%SID% md %DBLOG%\%SID% echo param_rmfile > param.tmp echo param_startsession >> param.tmp echo param_init OLTP >> param.tmp echo param_put MAXUSERTASKS 64 >> param.tmp echo param_put MAXSERVERTASKS 15 >> param.tmp echo param_put DATE_TIME_FORMAT INTERNAL >> param.tmp echo param_put MAXLOCKS 3000 >> param.tmp echo param_put LOG_MODE SINGLE >> param.tmp echo param_put CAT_CACHE_SUPPLY 300 >> param.tmp REM ### DATA_CACHE is 8K pages of RAM that the database will use for buffer. REM ### There is overhead for the kernel.exe that is not included. REM ### 64MB = 8000 REM ### 16384 = 128MB, 24576=192MB REM ### 57344 = 448MB REM ### 185600 = 1450MB of RAM REM ### 204800 = 1600MB of RAM REM ### 211200 = 1650MB of RAM REM ### 217600 = 1700MB of RAM REM ### 224000 = 1750MB of RAM REM ### echo param_put DATA_CACHE 211200 >> param.tmp echo param_put _IDXFILE_LIST_SIZE 2048 echo param_put MAXDATADEVSPACES 8 >> param.tmp rem ### rem ### 16GB maximum space for this database. rem ### echo param_put MAXDATAPAGES 2048000 >> param.tmp echo param_put _UNICODE YES >> param.tmp echo param_put DEFAULT_CODE ASCII >> param.tmp echo param_checkall >> param.tmp echo param_commitsession >> param.tmp echo param_adddevspace 1 SYS %DATA%\%SID%\DISKSYS01 F >> param.tmp echo param_adddevspace 1 DATA %DATA%\%SID%\DISKDATA0001 F 614400 >> param.tmp echo param_adddevspace 1 LOG %DBLOG%\%SID%\DISKLOG001 F 131072 >> param.tmp type param.tmp | dbmcli -d %SID% -u dbm,dbm dbmcli -d %SID% -u dbm,dbm db_start echo util_connect dbm,dbm > param.tmp echo util_execute init config >> param.tmp echo util_activate dba,dba >> param.tmp type param.tmp | dbmcli -d %SID% -u dbm,dbm dbmcli -d %SID% -u dbm,dbm load_systab -u dba,dba -ud domain echo sql_connect dba,dba > param.tmp echo sql_execute CREATE USER %user1% PASSWORD %user1PW% DBA NOT EXCLUSIVE >> param.tmp type param.tmp | dbmcli -d %SID% -u dbm,dbm echo backup_media_put data %DATA%\%SID%\datasave FILE DATA 0 8 YES > param.tmp echo backup_media_put auto %DATA%\%SID%\autosave FILE AUTO >> param.tmp echo util_connect dbm,dbm >> param.tmp echo backup_save data >> param.tmp echo autosave_on >> param.tmp type param.tmp | dbmcli -d %SID% -u dbm,dbm del param.tmp ==== end database create script ===== When I create the database with 1650MB DATA_CACHE, I can use Windows Task Manager andd see my Mem Usage: 1853712K / 4035824K (the second figure includes the pagefile). This is actually with a web browser and a few CMD.EXE sessions running. So clearly there is at least another 150MB of RAM available. Yet when I try to set DATA_CACHE to 1700MB it fails. The first error I encounter: -24988,ERR_SQL: sql error -1003,Message not available I can live with 1650MB DATA_CACHE, but I was hoping to get it up to 1750MB or 1800MB (leaving the remaining for the kernel sessions and other memory). Anyone have any suggestions on operating system config or other tips to get the most out of this system? Thank you. _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
