SAP : ecc 6.0 os : linux 64 db : DB2 Tape : Hp data protector 6.0
Issue : Online backup to tape fails
Running : 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".
db2dialog shows as follows
2010-03-17-19.23.23.660048+330 E76410036E373 LEVEL: Severe PID : 7674 TID : 47600836241360PROC : db2agent (HCP) 0 INSTANCE: db2hcp NODE : 000 DB : HCP APPHDL : 0-1487 APPID: *LOCAL.db2hcp.100317133414 AUTHID : DB2HCP FUNCTION: DB2 UDB, database utilities, sqlubcka, probe:869 MESSAGE : Backup terminated. details as below
2010-03-17-19.23.23.618573+330 E76409191E844 LEVEL: Severe PID : 7674 TID : 47600836241360PROC : db2agent (HCP) 0 INSTANCE: db2hcp NODE : 000 DB : HCP APPHDL : 0-1487 APPID: *LOCAL.db2hcp.100317133414 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-03-17-19.23.23.660048+330 E76410036E373 LEVEL: Severe PID : 7674 TID : 47600836241360PROC : db2agent (HCP) 0 INSTANCE: db2hcp NODE : 000 DB : HCP APPHDL : 0-1487 APPID: *LOCAL.db2hcp.100317133414 AUTHID : DB2HCP FUNCTION: DB2 UDB, database utilities, sqlubcka, probe:869 MESSAGE : Backup terminated. hclprdm:db2hcp 63>
on disk the backup is happening and on tape not happening. Tar command is also working
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
Thanks in advance