tom@dr.uucp (Tom Rojahn) (01/10/90)
When we try to RECOVER files, only transactions during the first islogopen.... islogclose are recovered. That is when all transactions are finished with COMMIT or ROLLBACK. However, if the last transaction is not ended (e.g. islogclose is performed without a commit or rollback for the last isbegin), and we do this before every islogclose, then all transactions in the logfile are recovered. But then again the last transaction in the application must be a dummy transaction since it's not committed to the logfile. We also recieves an errormessage (119) when we recovers files where all transactions are ended with commit or rollback, even when the logfile is opened just once, and the recover function seems to be successful. When the last transaction is not ended, we don't recieve the message. Our problem seems to appear when we closes the logfile after a completed transaction. Please reply by mail! Tom Rojahn +-------------------------------------------------------------+ ! DataRojahn-> Tel: +479876720 or: +473006606 Fax: +479876766 ! ! USENET/EUnet: ...!mcsun!nuug!dr!tom or: tom@dr.uucp ! +-------------------------------------------------------------+