cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

DB2 Offline backup error

Former Member

on ‎01-16-2013 7:16 AM

0 Kudos

Hi,

While trying to take offline backup to disk storage in our SAP ERP system with SLES and IBM DB2 9.7 database getting the error and backup is terminating.

SQL0980C  A disk error occurred.  Subsequent SQL statements cannot be

processed.  SQLSTATE=58005

Command used -> db2 backup db SID to "<filesystem - path>"

SQL0980C  A disk error occurred.  Subsequent SQL statements cannot be

processed.  SQLSTATE=58005

These are the information in the db2diag.log file. Please suggest any solutions.

2013-01-16-06.00.51.828201-300 E4800E449           LEVEL: Info
PID     : 18694                TID  : 140258142316288PROC : db2sysc 0
INSTANCE: db2SID               NODE : 000          DB   : SID
APPHDL  : 0-7                  APPID: *LOCAL.db2SID.130116110046
AUTHID  : DB2SID
EDUID   : 23                   EDUNAME: db2agent (SID) 0
FUNCTION: DB2 UDB, database utilities, sqlubSetupJobControl, probe:1604
MESSAGE : Starting an offline db backup.

2013-01-16-06.00.52.480848-300 I5250E1341          LEVEL: Error
PID     : 18694                TID  : 140258066818816PROC : db2sysc 0
INSTANCE: db2SID               NODE : 000          DB   : SID
APPHDL  : 0-7                  APPID: *LOCAL.db2SID.130116110046
AUTHID  : DB2SID
EDUID   : 41                   EDUNAME: db2bm.23.0 (SID) 0
FUNCTION: DB2 UDB, oper system services, sqloReadVLow, probe:100
MESSAGE : ZRC=0x860F0003=-2045837309=SQLO_DERR "disk error occurred (DOS)"
          DIA8402C A disk error has occurred.
DATA #1 : Codepath, 8 bytes
11
DATA #2 : String, 16 bytes
readv() failed !
DATA #3 : signed integer, 8 bytes
-1
DATA #4 : unsigned integer, 4 bytes
5
DATA #5 : File handle, PD_TYPE_SQO_FILE_HDL, 8 bytes
  File Handle              = 157
  File System Block Size   = 4096 bytes

File Handle Flags :
    Require Sector Align   = No
    DIO/CIO Mode           = Yes
    Raw Block Device       = No
    Reserved Handle        = No
    Flush On Close         = No
    Thread-Level Lock      = No
    Write-through Mode     = Yes
    File Not Tracked       = Yes
DATA #6 : signed integer, 4 bytes
14
DATA #7 : signed integer, 4 bytes
0
DATA #8 : File Offset, 8 bytes
2326528
DATA #9 : signed integer, 4 bytes
15
DATA #10: signed integer, 4 bytes
32768
DATA #11: signed integer, 8 bytes
0

2013-01-16-06.00.52.487444-300 I6592E640           LEVEL: Error
PID     : 18694                TID  : 140258066818816PROC : db2sysc 0
INSTANCE: db2SID               NODE : 000          DB   : SID
APPHDL  : 0-7                  APPID: *LOCAL.db2SID.130116110046
AUTHID  : DB2SID
EDUID   : 41                   EDUNAME: db2bm.23.0 (SID) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbServiceDirectReadVRequest, probe:6778
MESSAGE : ZRC=0x860F0003=-2045837309=SQLO_DERR "disk error occurred (DOS)"
          DIA8402C A disk error has occurred.
DATA #1 : String, 31 bytes
Error in sqlbServiceDirectReadV
DATA #2 : unsigned integer, 4 bytes


2013-01-16-06.00.52.487512-300 I7233E594           LEVEL: Severe
PID     : 18694                TID  : 140258066818816PROC : db2sysc 0
INSTANCE: db2SID               NODE : 000          DB   : SID
APPHDL  : 0-7                  APPID: *LOCAL.db2SID.130116110046
AUTHID  : DB2SID
EDUID   : 41                   EDUNAME: db2bm.23.0 (SID) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbpfParallelDirectReadV, probe:5225
MESSAGE : ZRC=0x860F0003=-2045837309=SQLO_DERR "disk error occurred (DOS)"
          DIA8402C A disk error has occurred.
DATA #1 : String, 26 bytes
Error during direct Read V

2013-01-16-06.00.52.487565-300 E7828E692           LEVEL: Error
PID     : 18694                TID  : 140258066818816PROC : db2sysc 0
INSTANCE: db2SID               NODE : 000          DB   : SID
APPHDL  : 0-7                  APPID: *LOCAL.db2SID.130116110046
AUTHID  : DB2SID
EDUID   : 41                   EDUNAME: db2bm.23.0 (SID) 0
FUNCTION: DB2 UDB, database utilities, sqlubReadDMS, probe:309
MESSAGE : ZRC=0x860F0003=-2045837309=SQLO_DERR "disk error occurred (DOS)"
          DIA8402C A disk error has occurred.
DATA #1 : Pool ID, PD_TYPE_POOL_ID, 2 bytes
7
DATA #2 : unsigned integer, 4 bytes
765432
DATA #3 : unsigned integer, 4 bytes
558
DATA #4 : unsigned integer, 4 bytes
558

2013-01-16-06.00.52.487640-300 E8521E552           LEVEL: Severe
PID     : 18694                TID  : 140258066818816PROC : db2sysc 0
INSTANCE: db2SID               NODE : 000          DB   : SID
APPHDL  : 0-7                  APPID: *LOCAL.db2SID.130116110046
AUTHID  : DB2SID
EDUID   : 41                   EDUNAME: db2bm.23.0 (SID) 0
FUNCTION: DB2 UDB, database utilities, sqlubReadDMS, probe:312
DATA #1 : Sqlcode, PD_TYPE_SQLCODE, 4 bytes
-980
DATA #2 : Hexdump, 8 bytes
0x00007F8E29970998 : 0300 0F86 0300 0000                        ........

2013-01-16-06.00.52.487721-300 E9074E924           LEVEL: Severe
PID     : 18694                TID  : 140258066818816PROC : db2sysc 0
INSTANCE: db2SID               NODE : 000          DB   : SID
APPHDL  : 0-7                  APPID: *LOCAL.db2SID.130116110046
AUTHID  : DB2SID
EDUID   : 41                   EDUNAME: db2bm.23.0 (SID) 0
FUNCTION: DB2 UDB, database utilities, sqlubReadDMS, probe:312
MESSAGE : SQL0980C  A disk error occurred.  Subsequent SQL statements cannot be
          processed.
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -980   sqlerrml: 1
sqlerrmc: 3
sqlerrp : sqlubRea
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:

2013-01-16-06.00.52.484374-300 I9999E1235          LEVEL: Error
PID     : 18694                TID  : 140258091984640PROC : db2sysc 0
INSTANCE: db2SID               NODE : 000
EDUID   : 35                   EDUNAME: db2pfchr (SID) 0
FUNCTION: DB2 UDB, oper system services, sqloReadVLow, probe:100
MESSAGE : ZRC=0x860F0003=-2045837309=SQLO_DERR "disk error occurred (DOS)"
          DIA8402C A disk error has occurred.
DATA #1 : Codepath, 8 bytes
11
DATA #2 : String, 16 bytes
readv() failed !
DATA #3 : signed integer, 8 bytes
-1
DATA #4 : unsigned integer, 4 bytes
5
DATA #5 : File handle, PD_TYPE_SQO_FILE_HDL, 8 bytes
  File Handle              = 159
  File System Block Size   = 4096 bytes
  File System Type         = ext3
  File Handle Flags :
    Require Sector Align   = No
    DIO/CIO Mode           = Yes
    Raw Block Device       = No
    Reserved Handle        = No
    Flush On Close         = No
    Thread-Level Lock      = No
    Write-through Mode     = Yes
    File Not Tracked       = Yes
DATA #6 : signed integer, 4 bytes

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member188883
Active Contributor
‎01-16-2013 7:30 AM
0 Kudos

Hi,

Could you please check whether the file system path specified has full access. If not provide 777 access to the file path and retry the backup.

Regards,

Deepak Kori

Show replies
Show replies
Former Member
‎01-16-2013 8:11 AM
0 Kudos

Thanks for your reply.

File system path has full permissions.

former_member188883
Active Contributor
‎01-16-2013 8:21 AM
0 Kudos

Hi Sandeep,

It looks like OS/Hardware problem. Get it checked with the vendor.

For details refer link http://www-01.ibm.com/support/docview.wss?uid=swg1IZ48399

Regards,

Deepak Kori

Former Member
‎01-16-2013 9:17 AM
0 Kudos

Thanks for the link.

However, the related issue seems to be fixed with 9.5 FP5 and we are 9.7 FP4.

Also, we checked with Linux/Disk support team and they say no issue could be found.

Former Member
‎01-16-2013 9:22 AM
0 Kudos

We are having issues with these services as mentioned in db2diag.log file.

FUNCTION: DB2 UDB, oper system services, sqloReadVLow, probe:100

FUNCTION: DB2 UDB, buffer pool services, sqlbServiceDirectReadVRequest, probe:6778

FUNCTION: DB2 UDB, buffer pool services, sqlbpfParallelDirectReadV, probe:5225

FUNCTION: DB2 UDB, database utilities, sqlubReadDMS, probe:309

FUNCTION: DB2 UDB, database utilities, sqlubReadDMS, probe:312

FUNCTION: DB2 UDB, database utilities, sqlubReadDMS, probe:312

FUNCTION: DB2 UDB, oper system services, sqloReadVLow, probe:100

However, In the related link, i am seeing DB2 service - sqloflock.

Any suggestions welcome.

former_member188883
Active Contributor
‎01-16-2013 10:13 AM
0 Kudos

Hi Sandeep,

As per the link below I still feel you should apply latest fix packs for 9.7 db2 database to resolve most of the issues related to I/Os.

http://www-01.ibm.com/support/docview.wss?uid=swg1IC73648

Regards,

Deepak Kori

Ask a Question