Hallo Andrea, ok, step 3. should be
3.) start database in COLD mode 'dbmcli -d <dbname> -u <usr,pwd> db_cold' sorry for that. SDBUPD is doing both, software update and database update, even you are running SAP DB on Windows. regards, Christoph Bautz, SAP Labs Berlin Bautz, Christoph wrote: > Hallo Andrea, > > > For now a description how to update to SAP DB 7.4.3, if you use SDBUPD: > 1.) database version is > 7.3.00 Build 25 or higher, instance type is OLTP database is in state WARM, system > tables are > loaded, database parameters have not been changed since last restart Uhm... how can I now if system tables are loaded? I usually create the database with a modified version of the TST script, create tables with an sql script loaded by repmcli, then just use it... > 2.) stop the database 'dbmcli -d <dbname> -u <usr,pwd> db_offline' > > 3.) start database in COLD mode 'dbmcli -d <dbname> -u <usr,pwd> db_offline' The same command first stops the database then turns it into cold mode? I thought that db_offline was intended to turn the database from warm to cold state directly. > 4.) make a complete data backup or alternatively as of SAPDB 7.4.03 Build 012 or > higher a > incremental backup and a log backup 'dbmcli -d <dbname> -u <usr,pwd> backup_start > <medium>' > > 5.) run SDBUPD, you must not start the database after the backup './SDBUPD -d > <dbname> -u > <usr,pwd> > > 6.) Your database is updated to 7.4.3 and ONLINE > Ok, the database is updated to 7.4.3. And the software? Should I run sdbinst after the database update or before? Or sdbupd also upgrades the software when the first database instance is upgraded? Best regards Andrea PS: I'm running sapdb on windows. _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
