Backup Central

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

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

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

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.EDU] Im Auftrag von BEYERS Kurt
Gesendet: Freitag, 8. August 2008 11:05
An: ADSM-L < at > VM.MARIST.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.EDU] Namens
Remco
Post
Verzonden: vrijdag 8 augustus 2008 10:47
Aan: ADSM-L < at > VM.MARIST.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