Restore from online db2 taken on TAPE

Former Member · ‎07-20-2014

Dear All,

We are taking the backup from db13 on tape after INITIALIZE , but we are not sure how to restore from tape .

As per me

1) INITIALIZE the tape drive

2) Restore from tape( But what will be the command to use for restore)?

Regards

RK

+91-8285932768

former_member182657 · ‎07-22-2014

Dear Rableen,

It's


db2 restore db <dbname> to \\.\tape0

Gaurav

Former Member · ‎07-22-2014

Dear Gaurav,

What command you use , whenever restore from tape , please write the same command.

RK

former_member182657 · ‎07-22-2014

Please follow SCN link


db2 restore db <sid> from . buffer <buffer size>

Hope this will be helpful.

Thanks,

Gaurav

Former Member · ‎07-21-2014

Dear All,

Please confirm me the command,

RK

Former Member · ‎07-20-2014

Hi Rableen Khurana,

Example 2 - Online tablespace restore into existing database from a tape device

db2 "restore database sample tablespace (syscatspace,

userspace1) online from /dev/rmt0 taken at 20010222151429 newlogpath

/home/db2v71/samplelogs without prompting"

See this link is usefully

Regards,

Visu

hugo_amo · ‎07-20-2014

Hi RK,

HAve a look at:

and

Regards,

Hugo

Re: excel to itab in rap