Hi

SAP : ecc 6.0
db2 : 9.1
Susi x86_64 x86_64 x86_64 GNU/Linux
Tape : HP MSL 2024

Issue : Command level backup to tape not happening.

I am able to take Command level backup to disk and able to transfer to
tape using tar

However I am not able to take backup from db2 command prompt

command db2 backup db hcp online to /dev/rst0

/dev/rst0==> is a tape volume

Trying to take online backup from db2 from command prompt to the tape.


hclprdm:~ # su - db2hcp
hclprdm:db2hcp 51> db2 backup db hcp online to /dev/rst0
SQL2031W Warning! Please mount the target or source media on device
"/dev/rst0".
Do you want to continue(c), terminate this device only(d), abort the
utility(t) ? (c/d/t) c
SQL2025N An I/O error "-902" occurred on media "/dev/rst0".

on disk the backup is happening and on tape not happening.

I could able to see the activity on the tape for some time.

Tar level backup from OS to the tape is happening and even able to
restore the tar backup.

How to resolve the issue pl. let me know

2010-04-03-17.31.22.708665+330 I93531007E424 LEVEL: Warning
PID : 16466 TID : 46965805479888PROC : db2logmgr
(HCP) 0
INSTANCE: db2hcp NODE : 000
FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile,
probe:3170
MESSAGE : Completed archive for log file S0000578.LOG to
/db2/HCP/log_archive/db2hcp/HCP/NODE0000/C0000001/ from
/db2/HCP/log_dir/NODE0000/.

2010-04-03-17.33.12.996801+330 E93531432E306 LEVEL: Error
PID : 29723 TID : 46965805479888PROC :
db2med.29688.0 0
INSTANCE: db2hcp NODE : 000
FUNCTION: DB2 UDB, database utilities, sqluMCTerminateBackup,
probe:1282
DATA #1 : <preformatted>
Reason code = -2029060094.

2010-04-03-17.33.13.014378+330 I93531739E325 LEVEL: Warning
PID : 29723 TID : 46965805479888PROC :
db2med.29688.0 0
INSTANCE: db2hcp NODE : 000
FUNCTION: DB2 UDB, database utilities, sqluMCTerminateBackup,
probe:1293
MESSAGE : Media controller -- Problem closing local device /dev/rst0

2010-04-03-17.33.13.014488+330 E93532065E579 LEVEL: Severe
PID : 29688 TID : 46965805479888PROC : db2agent
(HCP) 0
INSTANCE: db2hcp NODE : 000 DB : HCP
APPHDL : 0-1794 APPID: *LOCAL.db2hcp.100403114153
AUTHID : DB2HCP
FUNCTION: DB2 UDB, database utilities, sqlubMWResponse, probe:1041
DATA #1 : Sqlcode, PD_TYPE_SQLCODE, 4 bytes
-2025
DATA #2 : Hexdump, 19 bytes
0x00000003A88C21A0 : 17F8 FFFF 2D39 3032 FF2F 6465 762F 7273
....-902./dev/rs
0x00000003A88C21B0 : 7430 00 t0.

2010-04-03-17.33.13.033633+330 E93532645E844 LEVEL: Severe
PID : 29688 TID : 46965805479888PROC : db2agent
(HCP) 0
INSTANCE: db2hcp NODE : 000 DB : HCP
APPHDL : 0-1794 APPID: *LOCAL.db2hcp.100403114153
AUTHID : DB2HCP
FUNCTION: DB2 UDB, database utilities, sqlubMWResponse, probe:1041
MESSAGE : SQL2025N An I/O error "" occurred on media "".
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -2025 sqlerrml: 14
sqlerrmc: -902 /dev/rst0
sqlerrp : sqlubMWR
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:

2010-04-03-17.33.13.055773+330 E93533490E373 LEVEL: Severe
PID : 29688 TID : 46965805479888PROC : db2agent
(HCP) 0
INSTANCE: db2hcp NODE : 000 DB : HCP
APPHDL : 0-1794 APPID: *LOCAL.db2hcp.100403114153
AUTHID : DB2HCP
FUNCTION: DB2 UDB, database utilities, sqlubcka, probe:869
MESSAGE : Backup terminated.


--
glnsarma
------------------------------------------------------------------------
glnsarma's Profile: http://forums.novell.com/member.php?userid=82452
View this thread: http://forums.novell.com/showthread.php?t=406676