Thanks a lot for your help ! I tried to set the -a option when I create the database, but it is still cold.
I have now a strange astable behavior of my system sometimes when I reboot. I cannot access the START button on my XP system. There is the sandglass if I try to access it. But only on some reboots. I still can access the DBMGUI and the database instances are still cold (yellow). It is quite essential starting the database in warm state because other applications which have to run on boot up need the db ! If I have to write a NTService which calls a batch script which warms up the db would be quite awful. Maybe someone can help me if he sees my database creation script: param_startsession param_init param_put RESTART_SHUTDOWN AUTO param_put MAXUSERTASKS 50 param_put SESSION_TIMEOUT 0 param_checkall param_commitsession param_adddevspace 1 SYS d:\ai_data\SYS_WORK_001 F param_adddevspace 1 LOG d:\ai_data\LOG_WORK_001 F 10000 param_adddevspace 1 DATA d:\ai_data\DAT_WORK_001 F 10000 db_cold db_start util_connect util_execute INIT CONFIG util_activate AIDBA,xxx sql_connect AIDBA,xxx sql_execute CREATE USER AIWORKUSER PASSWORD xxx RESOURCE NOT EXCLUSIVE util_connect AIDBA,xxx medium_put workdatabak d:\ai_backup\work.databak FILE DATA 0 8 YES medium_put worklogbak d:\ai_backup\work.logbak FILE AUTO 0 8 YES db_warm quit util_connect AIDBA,xxx backup_start workdatabak MIGRATION backup_start worklogbak autolog_on quit load_systab -u AIDBA,xxx -ud xxx quit Thomas Renninger wrote: > thanks, but I don't have a parameter called RESTART_AUTO. > > I only have a parameter called RESTART_SHUTDOWN. I changed it > from MANUAL to > AUTO, but it makes no difference. > > I have the Kernel Version 7.3.0 > > Does anyone know something else ??? As Bernd wrote some month ago: The "automatic" flag for the service is responsible for the OFFLINE to COLD transition. <<------ ! The "RESTART_SHUTDOWN AUTO" is responsible for COLD to WARM transition _only_ after an automatic start of the service. For an automatic restart of the database on reboot you have to set both values. Please notice that the "RESTART_SHUTDOWN AUTO" has no effect if you start the service manual via the service manager or the DBM. If you create a database with dbmcli on the command line you may use the option -a to create a service entry with automatic startup: dbmcli db_create -a <dbname> <dbmusr>,<pwd> (see also http://www.sapdb.org/htmhelp/6b/9cc7ac4b6311d4aa1100a0c9430730/content.htm ) This option is not available in the DBMGui. Elke -- SAP Labs Berlin BTW: we all have kernel version 7.3.0. The last, the 4. number makes the difference and is important very often > > > hello, > > set the parameter RESTART_AUTO of your database > instance to AUTO. by default, SAPDB sets this to > MANUAL. > > > --- Thomas Renninger <[EMAIL PROTECTED]> wrote: > > Hello, > > > > I already browsed the mail archive. I did find a > > similiar question like > > mine, but I could not find an answer. > > > > I need to get my database instances in warm state at > > Windows startup. > > > > The installed services of my database instances only > > set the database in > > cold state, but I essentially need it in the warm > > state. > > > > > > Thanks for help. > > > > regards, > > > > Thomas Renninger > > > > _______________________________________________ > > sapdb.general mailing list > > [EMAIL PROTECTED] > > > http://listserv.sap.com/mailman/listinfo/sapdb.general > > > __________________________________________________ > Do You Yahoo!? > Yahoo! - Official partner of 2002 FIFA World Cup > http://fifaworldcup.yahoo.com > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
