Wednesday, February 23, 2022

DB2 backup error SQL2062N An error occurred while accessing media Reason code: "0x860f0003"

During this days I was working on a db2 configuration backup of an old db2 10.5.x server installed on SLES 11.3. 

The task was configuring online backup and set it on an NFS mount.

As precheck of this activity I tested db2owner instance user rights on the NFS and he was successfully able to create and delate file or folders.

When I tried to perform a "db2 backup database xxx " the NFS as destination ,  only an empty files was created and after some seconds I've got the following error: 

SQL2062N An error occurred while accessing media Reason code: "0x860f0003".

After some investigation I've found this IBM Technote , so I checked the /etc/fstab file and 

after  changing the munt options from DEFAULTS to   rw,sync,nolock  the db2 backup command work as expected.

No comments:

Post a Comment