Db2

Db2

Where DBAs and data experts come together to stop operating and start innovating. Connect, share, and shape the AI era with us.


#Data


#Data
#Databases
#Operatingsystems
#Db2
#Databasesolutions
 View Only

  • 1.  Db2 - NFS connection transfer archive logs error

    Posted 03/23/23 11:25 AM

    Hello community,

     I pointed  logarchmeth1 parameter to NFS storage and I can see only one log there with size "0". 

    the error that I see in db2.diag log is: "Operating system reason code (errno): 0x00000032 (50) = No CSI structure available"

    What may be the problem and how can I resolve this issue ?



    ------------------------------
    Galin Gospodinov
    ------------------------------


  • 2.  RE: Db2 - NFS connection transfer archive logs error

    Posted 03/24/23 04:23 AM

    maybe this can help

    https://www.mail-archive.com/sam-qfs-discuss@opensolaris.org/msg00190.html



    ------------------------------
    Thanks for all answers
    Best Regards,
    Guy Przytula
    ------------------------------



  • 3.  RE: Db2 - NFS connection transfer archive logs error

    Posted 03/24/23 04:30 AM

    Hi Guy Przytula, 

    Thank you for the reply.

    The problem is that we are using Windows with NFS client. We have full rights to read/write over the NFS and we continue to see this error and also we see the archive log on the NFS, but it`s size 0.



    ------------------------------
    Galin Gospodinov
    ------------------------------

    Original Message


  • 4.  RE: Db2 - NFS connection transfer archive logs error

    Posted 03/24/23 05:58 AM

    we had a similar problem on linux and had to add something to /etc/fstab mount setting

    https://www.ibm.com/support/pages/db2-backup-log-archive-nfs-mounted-drive-returns-dia8519c

    Consult with a System Administrator, to ensure the NFS directory is mounted with the "nolock" option.



    ------------------------------
    Thanks for all answers
    Best Regards,
    Guy Przytula
    ------------------------------

    Original Message


  • 5.  RE: Db2 - NFS connection transfer archive logs error

    Posted 03/24/23 09:00 AM

    I unmount the NFS and mount it again with no lock disabled, but the result is the same.  



    ------------------------------
    Galin Gospodinov
    ------------------------------

    Original Message


Related Content