Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2007

    Unanswered: Error backing up DB2 database on Linux to NFS system


    I keep getting this error after trying to do an online backup of the DB2 database to an NFS filesystem:

    SQL2025N An I/O error "6" occurred on media ...

    Has anyone ever seen this error? Any idea on how to fix it?

    I read somewhere on one of the posts here that it may be a locking issue. Here is a response to someone who had the same exact problem that I have:

    That's an ENOLCK (errno = 37, or 25 hex). It means that DB2 is trying
    to lock a file but can't. I suspect your nfs mounting options are not
    allowing locking over nfs.

    Here is the thread that has the above answer... I looked at the db2diag.log file and am getting the same errors too.

    If this is the solution, does anyone know how to enable locking over nfs? I have options in fstab set to default.

    Thanks for the help!

  2. #2
    Join Date
    Jun 2006
    as I remember, this must be a local directory
    "This target directory or device must exist on the database server" according the doc
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

  3. #3
    Join Date
    May 2003
    I do backups to an NFS mount all the time on Linux. The instance owner id must be the owner (not just write permission) of the directory you are backing up to.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts