3496931 - DB6: SQL0980C A disk error occurred during a database restore.

• When restoring the database from backup, the restore fails with
  SQL0980C  A disk error occurred. 
• Checking the db2diag.log in the /db2/<SID>/db2dump directory shows errors like

2024-07-15-15.52.24                                                                      LEVEL: Error (OS)
MESSAGE : ZRC=0x860F0003=-2045837309=SQLO_DERR "disk error occurred (DOS)"
DIA8402C A disk error has occurred.
CALLED  : OS, -, read
OSERR   : EIO (5) "I/O error"
DATA #1 : File handle, PD_TYPE_SQO_FILE_HDL, 8 bytes
  File Handle              = 21
  File System Block Size   = 0 bytes
  File System Type         = UNKNOWN
  File Handle Flags :
  Require Sector Align   = No
  DIO/CIO Mode           = No
  Raw Block Device       = No
  Reserved Handle        = No
  Flush On Close         = No
  Thread-Level Lock      = Yes
  Write-through Mode     = No
  File Not Tracked       = No

2024-07-15-15.52.24.                                                                    LEVEL: Error (OS)

CALLED  : OS, -, read 
OSERR   : EIO (5) "I/O error"

CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
  [0] 0x0900000007ECCB7C oss_log__FP9OSSLogFacUiN32UlN26iPPc + 0x1BC
  [1] 0x0900000007ECD00C ossLogSysRC + 0x6C
  [2] 0x0900000007EE4CD8 ossErrorIOAnalysis__FCPC21OSSErrorAnalysisParam + 0xDD8
  [3] 0x090000000DA56DC0 sqloSystemErrorHandler + 0x380
  [4] 0x090000000DA13508 sqloread + 0x428
  [5] 0x090000000DA1A638 sqloreadEx + 0x38
  [6] 0x0900000013E6F63C sqluReadFromFileDeviceInternal__FPvT1UlPUli + 0x35C
  [7] 0x0900000013E6FC34 sqluReadFromFileDevice__FP13SQLUMC_IBLK_TPvPUl + 0xB4
  [8] 0x0900000011F54528 sqluMCReadFromDevice__FP13SQLUMC_IBLK_TPvPUl + 0x13C8
  [9] 0x0900000013E6B8B8 sqluMCReadFromDev4Restore__FP13SQLUMC_IBLK_TP17SQLU_TRANS_BUFFER + 0x498
  [10] 0x0900000013E69F38 sqluMCContinueRestore__FP13SQLUMC_IBLK_T + 0xD98
  [11] 0x0900000013E67084 sqluMCProcessRestoreStates__FPP13SQLUMC_IBLK_T + 0x10C4
  [12] 0x0900000013E65CE4 sqluMCStartRestoreMediaController__FPcUi + 0x644
  [13] 0x090000000DA39500 sqloEDUEntry + 0x360
  [14] 0x09000000004FCE10 _pthread_body + 0xF0
  [15] 0xFFFFFFFFFFFFFFFC ?unknown + 0xFFFFFFFF

2024-07-15-15.52.24.                                                        LEVEL: Error
MESSAGE : Media controller -- Problem reading from local device 
 /<backup_path>

2024-07-15-15.52.24. vvvvvvvvvvvvvvvvvvvvvvvvvvvvv      LEVEL: Error
MESSAGE : SQL0980C  A disk error occurred.  Subsequent SQL statements cannot be processed.

2024-07-15-15.52.24.564633+330 E3207284489A458      LEVEL: Severe
MESSAGE : Restore Terminated.

Db2 LUW IBM

Backup Vendor, controller, disk, storage, device, fail, restore from, OS level. backup , KBA , BC-DB-DB6-DBA , Database Administration , Problem