cancel
Showing results for 
Search instead for 
Did you mean: 

I get a "Disk error" message when I try to backup my db in db2

Former Member
0 Kudos

I have a serious problem when I try to make a backup, I always get an error.

This is the db2dump log:

2010-10-11-00.42.13.664439-300 E1943A319 LEVEL: Error (OS)

PID : 413852 TID : 1 PROC : db2pfchr 0

INSTANCE: db2pro NODE : 000

FUNCTION: DB2 UDB, oper system services, sqloReadBlocks, probe:60

CALLED : OS, -, unspecified_system_function

OSERR : EIO (5) "I/O error"

2010-10-11-00.42.13.668506-300 I3602A364 LEVEL: Error

PID : 413852 TID : 1 PROC : db2pfchr 0

INSTANCE: db2pro NODE : 000

FUNCTION: DB2 UDB, buffer pool services, sqlbDMSDirectRead, probe:860

RETCODE : ZRC=0x860F0003=-2045837309=SQLO_DERR "disk error occurred (DOS)"

DIA8402C A disk error has occurred.

At the same time I get these errors in OS:

E86653C3 1011004210 P H LVDD I/O ERROR DETECTED BY LVM

5ABCCC6B 1011004210 T H scraid0 DISK OPERATION ERROR

5ABCCC6B 1011004210 T H scraid0 DISK OPERATION ERROR

LABEL: LVM_IO_FAIL

IDENTIFIER: E86653C3

Date/Time: Mon Oct 11 00:42:13 CDT 2010

Sequence Number: 29781176

Machine Id: 000A3F6A4C00

Node Id: DN10DNP

Class: H

Type: PERM

Resource Name: LVDD

Resource Class: NONE

Resource Type: NONE

Location:

Description

I/O ERROR DETECTED BY LVM

Probable Causes

POWER, DRIVE, ADAPTER, OR CABLE FAILURE

I am using a RAID 5 and I have db2 for LUW 8.2 and AIX 5.3

I am pretty worried because I can't make a backup.

Can anybody help me?

Thanks in advance.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos
Former Member
0 Kudos

Thanks Sunil

but the problem was solved, it was an hardware failure, but now I am monitoring the database performance.

Kind regards.