Troubleshooting
Problem
How to resolve SQL2062N error that occurred while taking a DB2 backup?
Symptom
db2 backup db online to /db/backup/abc compress
SQL2062N An error occurred while accessing media
"/db/backup/abc". Reason code: "0x860f0003".
Diagnosing The Problem
db2diag -rc 0x860f0003
Input ZRC string '0x860f0003' parsed as 0x860F0003 (-2045837309).
ZRC value to map: 0x860F0003 (-2045837309)
V7 Equivalent ZRC value: 0xFFFFE603 (-6653)
ZRC class :
Critical Media Error (Class Index: 6)
Component:
SQLO ; oper system services (Component Index: 15)
Reason Code:
3 (0x0003)
Identifer:
SQLO_DERR
Identifer (without component):
SQLZ_RC_DERR
Description:
disk error occurred (DOS)
Associated information:
Sqlcode -980
SQL0980C A disk error occurred. Subsequent SQL statements cannot be
processed.
Number of sqlca tokens : 0
Diaglog message number: 8402
- Obtain "mount -v" output from OS Shell to verify mount options: rw, sync, nolock
Resolving The Problem
- Make sure that NFS is mounted with NOLOCK nfs option.
- Confirm that"ls -l" output shows read and write permissions
for both instance user and the group on the database backup directory structure.
Related Information
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21993375