Hi, Take a new DB2 backup as follows:
Db2 backup db PROD online use tsm include logs The log files in use during the backup is now included in the backup image. And restore / rollforward the database: Db2 restore db prod use tsm taken at <TIMESTAMP> INTO test Db2 rollforward db test stop The database test is now up and running and available for the appications. Best regards, Kurt > -----Oorspronkelijk bericht----- > Van: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Namens Remco > Post > Verzonden: vrijdag 8 augustus 2008 10:47 > Aan: [email protected] > Onderwerp: Re: [ADSM-L] DB2 Restore / Rollforward > > Herrmann, Boris wrote: > > Hello all, > > > > I've a question regarding db2 restore and rollforward. > > > > Our szenario: > > > > We have das datebase called "prod" and want restore this database on the > > SAME server into the database "test" > > The restore database command shoud be: > > DB2 RESTORE DB prod USE TSM TAKEN AT <TIMESTAMP> INTO test > > > > But how can I now rollforward the "test" db? (I don't want interfere the > > "prod" db). I miss somesting like rollforward >INTO<.... > > > > Any help is appreciated.... > > With kind regards, > > Boris > > > > > > I'd think that you would have more luck in a db2 specific forum. My > guess would be that either you can't, or that if you restore logfies > with the db, you could rollforward your test db to the desired point in > time. > > -- > Met vriendelijke groeten, > > Remco Post, PLCS *** Disclaimer *** Vlaamse Radio- en Televisieomroep Auguste Reyerslaan 52, 1043 Brussel nv van publiek recht BTW BE 0244.142.664 RPR Brussel http://www.vrt.be/disclaimer
