Sven K�hler > > > Did you check if your log is full and the database kernel is waiting > > for an admin doing the backup for this log or switching on > the AutoLog-option? > > There are several things about the AutoLog-Option that i don't > understand. Perhaps because of some basic mistakes in my knowledge. > So please correct me and the following: > > 1. The Log is used to store information that's used to rollback or > replay transactions > 2. The Log grows until the data is commited and ?safely? written into > the data-tables
That is not correct. Because during commit not every data page needed to store the data changed by that transaction is written to disk and therefore save, the log is NOT cleared when the commit finishes. It is needed for those cases where between the commit and the next time EVERY changed data page is written to disk, the kernel is stopped (without shutdown, which would write to disk). To assure after restart that every committed transaction can be redone one has to store the log even after commit and save it using explicit or implicit (auto-) backup-mechanism. Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
