Taking Backup on tape Getting Error

[Former Member]

Hi,

My production server is running with SuSE Linux 10 SP2 with DB2 9.7 database.

I have LTO4 tape drive directly connected to my Production server

I am able to take backup to disk but when I am trying to take backup to tape I am getting error as below.

SRSPROD:shpadm 38> db2 backup database SHP to /dev/st0

SQL2031W Warning! Please mount the target or source media on device

"/dev/st0".

Do you want to continue(c), terminate this device only(d), abort the utility(t) ? (c/d/t)

I have full permissions on tape

SRSPROD:shpadm 39> ls -l /dev/st0

crwxrwxrwx 1 root disk 9, 0 2010-04-26 08:57 /dev/st0

Thanku

[paul_power · Accepted solution]

Hi,

Before we start into deeper analysis I would like to confirm that normal

writes to the tape works e.g. with OS meanings. Could you please test

if you are able to put an archive with tar to the tape?

e.g. with "tar cvf /home/<user> /dev/<TAPEDEVICE>"

What happens if you select continue as this message is only a warning?

Does the backup then end with an error?

If so please update with the error you recieve.

Regards,

Paul

[markus_doehr2]

> I am able to take backup to disk but when I am trying to take backup to tape I am getting error as below.

>

> SRSPROD:shpadm 38> db2 backup database SHP to /dev/st0

>

> SQL2031W Warning! Please mount the target or source media on device

> "/dev/st0".

> Do you want to continue(c), terminate this device only(d), abort the utility(t) ? (c/d/t)

>

Honestly I don't see any error.

The database requests you to mount a tape (put it inside the drive). Enter "c" plus pressing enter...

Markus