Results 1 to 3 of 3

Thread: audit user

  1. #1
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11

    Unanswered: audit user

    DB2 10.1 FP4 ese on p/series linux
    I need to audit dml for specific user
    db2 connect to clsm user db2inst1
    db2 "CREATE AUDIT POLICY USERPOLICY CATEGORIES EXECUTE WITH DATA STATUS BOTH ERROR TYPE AUDIT"
    db2 "COMMIT"
    db2 "AUDIT USER DB2USER USING POLICY USERPOLICY"
    db2 "COMMIT"
    db2audit configure datapath '/home/db2inst1/work/auditlog' archivepath '/home/db2inst1/work/auditarch'
    db2audit start
    db2 connect to clsm user db2user
    db2 "insert into dba.test values(1,1)" ...
    db2 connect to clsm user db2inst1
    db2audit flush
    db2audit archive
    Member DB Partition AUD Archived or Interim Log File
    Number Number Message
    -------- -------------- -------- -------------------------------------------------
    0 0 AUD0000I

    AUD0000I Operation succeeded.

    no audit records are being created
    Anyone has been using this feature before ?
    Am I missing a statement/operation ..
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  2. #2
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    To archive the database level audit records you have to use the following command:
    Code:
    db2audit archive database clsm
    Regards,
    Mark.

  3. #3
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    thanks for the update/help Mark B.
    this created the file and I could extract the info
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

Posting Permissions

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