Db2 On Premise and Cloud

 View Only

db2audit AUD0003N error

  • 1.  db2audit AUD0003N error

    Posted Wed June 22, 2022 10:12 AM
    Edited by Igor MERKU' Wed June 22, 2022 10:13 AM
    I am running DB2 Community edition V9.7 on linux.
    I am trying to get some audit running and extract data.


    Audit active: "TRUE "
    Log audit events: "BOTH"
    Log checking events: "FAILURE"
    Log object maintenance events: "FAILURE"
    Log security maintenance events: "FAILURE"
    Log system administrator events: "FAILURE"
    Log validate events: "FAILURE"
    Log context events: "BOTH"
    Return SQLCA on audit error: "FALSE "
    Audit Data Path: "/home/db2inst1/sqllib/security/auditdata/"
    Audit Archive Path: "/home/db2inst1/sqllib/security/auditarchive/"

    So in dir /home/db2inst1/sqllib/security I have these dirs:
    drwxrwxrwx 2 db2inst1 db2iadm1 4096 Jun 22 15:49 auditarchive
    drwxrwxrwx 2 db2inst1 db2iadm1 4096 Jun 22 15:19 auditdata
    drwxrwxrwx 2 db2inst1 db2iadm1 4096 Jun 22 15:50 auditdelasc

    I have run
    db2audit flush
     db2audit archive database FAMMC to /home/db2inst1/sqllib/security/auditarchive/

    Node AUD Archived or Interim Log File
    -------- -------- ---------------------------------------------------
    0 AUD0000I

    AUD0000I Operation succeeded.

    Now I would like to extract some data:
    db2inst1@db2migt:~/sqllib/security> db2audit extract delasc to /home/db2inst1/sqllib/security/auditdelasc from files /home/db2inst1/sqllib/security/auditarchive/*
    AUD0003N I/O error on accessing "/home/db2inst1/sqllib/security/auditarchive/auditlobs", make sure the directory/file exists and has the right permission.

    AUD0001N Operation failed.

    I have played with permissions (rwx, rw-, rx etc in various combinatins) to no avail.
    Any ideas?

    Thanks a lot, Igor

    Igor MERKU'