Please Help! Logfiles lost, but online-backup could be restored
This is a discussion on Please Help! Logfiles lost, but online-backup could be restored within the DB2 forums, part of the Database Server Software category; --> We have some problems with DB2 V8 on Linux. DB2 showed SQL 1042. So we restored the last online ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-26-2008, 06:37 PM
| ||||
| ||||
 Please Help! Logfiles lost, but online-backup could be restored We have some problems with DB2 V8 on Linux. DB2 showed SQL 1042. So we restored the last online backup successfully. But because there are only 2 log files rollforward is not possible. Is it possible to tell db2 that it should forget about the rollforward pending (not to care about inconsistency)? Regards, -- Burkhard Schultheis Tele Data Electronic, Wagnerstr. 10, D-76448 Durmersheim Email: schultheis@tde-online.de Phone: +49-7245-9287-21, Fax: +49-7245-9287-30      |
|
02-26-2008, 06:37 PM
| |||
| |||
| Re: Please Help! Logfiles lost, but online-backup could be restored Only by contact to IBM support. There is not a command in DB2 to do it. /Kim "Burkhard Schultheis" <schultheis@tde-online.de> wrote in message news:c4gpkb$2hd1i9$1@ID-100086.news.uni-berlin.de... > We have some problems with DB2 V8 on Linux. DB2 showed SQL 1042. So we > restored the last online backup successfully. But because there are only > 2 log files rollforward is not possible. Is it possible to tell db2 that > it should forget about the rollforward pending (not to care about > inconsistency)? > > Regards, > -- > Burkhard Schultheis > Tele Data Electronic, Wagnerstr. 10, D-76448 Durmersheim > Email: schultheis@tde-online.de > Phone: +49-7245-9287-21, Fax: +49-7245-9287-30 |
|
02-26-2008, 06:38 PM
| ||||
| ||||
| Re: Please Help! Logfiles lost, but online-backup could be restored You can use db2dart to dump the data, but it won't be consistent and it can be quite time consuming. "Kim Bundgaard" <kib at kmd.dk> wrote in message news:<406c0164$0$183$edfadb0f@dread11.news.tele.dk >... > Only by contact to IBM support. > There is not a command in DB2 to do it. > > /Kim > > "Burkhard Schultheis" <schultheis@tde-online.de> wrote in message > news:c4gpkb$2hd1i9$1@ID-100086.news.uni-berlin.de... > > We have some problems with DB2 V8 on Linux. DB2 showed SQL 1042. So we > > restored the last online backup successfully. But because there are only > > 2 log files rollforward is not possible. Is it possible to tell db2 that > > it should forget about the rollforward pending (not to care about > > inconsistency)? > > > > Regards, > > -- > > Burkhard Schultheis > > Tele Data Electronic, Wagnerstr. 10, D-76448 Durmersheim > > Email: schultheis@tde-online.de > > Phone: +49-7245-9287-21, Fax: +49-7245-9287-30 |
Linear Mode
