Another way, to do that is to is to set auto log on when starting the machine. This let the database starts, and give some times to set auto log to on.
the following script set autolog on if needed. but you can just try to set it on without testing ( dbmcli -n %NODE% -d %SID% -u %DBUSEROPE%,%DBPWDOPE% autolog_on ) Stéphane @echo off rem ################################################################# rem # rem # Set autolog to on if necessary rem # rem # rem ################################################################# rem LogPath rem ------- set LOGPATH="SapDb_AutoLog.log" rem name of the database rem -------------------- set SID=EDP350 set DBUSEROPE=ESKDBOPE set DBPWDOPE=edp350 set NODE=127.0.0.1 if EXIST %LOGPATH% del %LOGPATH% echo -------------- >> %LOGPATH% echo --- Start Log at %date% %time%--- >> %LOGPATH% echo -------------- >> %LOGPATH% Echo -------------------------- >> %LOGPATH% Echo Check autosave for log file >> %LOGPATH% Echo -------------------------- >> %LOGPATH% dbmcli -n %NODE% -d %SID% -u %DBUSEROPE%,%DBPWDOPE% autolog_show >> %LOGPATH% find /N /i "AUTOSAVE IS ON" %LOGPATH% SET MyRC=%ERRORLEVEL% IF %MyRC% EQU 0 ( Echo -------------------------- >> %LOGPATH% Echo - Log autosave is ON (No action required) >> %LOGPATH% Echo -------------------------- >> %LOGPATH% ) ELSE ( Echo -------------------------- >> %LOGPATH% Echo - Log autosave is OFF : Turn it ON >> %LOGPATH% Echo -------------------------- >> %LOGPATH% dbmcli -n %NODE% -d %SID% -u %DBUSEROPE%,%DBPWDOPE% autolog_on>> %LOGPATH% ) echo -------------- >> %LOGPATH% echo --- End Log at %date% %time%--- >> %LOGPATH% echo -------------- >> %LOGPATH% <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi > > we are using SAP DB 7.4.3.30 on a windows 2000 server as service. > We have to use it as service. > We have a problem with autolog on. Sometimes it is on, and then it is off. > I have read a few discussions about that in the mailinglist. But have not found a good solution for that problem, because some are using different version, same aren't using windows and same dont even use it as service. > Can anybody tell me how I can set autolog on permanent, even restart and service on/off. > > Thank you very much > > Philipp Schneider > > > P.S. The maillist search on the mysql homepage is not working if you choose "within maxdb"!!! > > > -- > 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]
