Hi,

thanks for this info. Unfortunately in the prod database is an error. And our 
db2 colleague want a restore from Wednesday into another name and then compare 
the both databases....so I've to rollforward old logs....

Best regards,
Boris 


-----Ursprüngliche Nachricht-----
Von: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] Im Auftrag 
von BEYERS Kurt
Gesendet: Freitag, 8. August 2008 11:05
An: ADSM-L AT VM.MARIST DOT EDU
Betreff: Re: [ADSM-L] DB2 Restore / Rollforward


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:ADSM-L AT VM.MARIST DOT EDU] Namens
Remco
> Post
> Verzonden: vrijdag 8 augustus 2008 10:47
> Aan: ADSM-L AT VM.MARIST DOT EDU
> 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