Results 1 to 4 of 4

Thread: db2audit

  1. #1
    Join Date
    Jul 2008
    Posts
    131

    Question Unanswered: db2audit

    Hi,
    I am using db2 V9.5 ESE on windows.
    I am trying to extract the log data into delimited ASCII so as to load the audit data in tables. but doing this creates the *.del files but with no data. I executed the following command for extraction

    >db2audit extract delasc delimiter ! from files db2audit.db.AUDIT.log.0

    AUD0036N Extract can not be performed on the active audit log file "C:\DOCUME~1
    \ALLUSE~1\APPLIC~1\IBM\DB2\DB2COPY1\DB2\security\a uditdata\db2audit.db.AUDIT.log
    .0".

    AUD0001N Operation failed.

    how do i inactivate the log file and then do the extraction?

  2. #2
    Join Date
    Feb 2009
    Posts
    114
    db2audit flush
    db2audit archive

  3. #3
    Join Date
    Jul 2008
    Posts
    131
    Thanks Getting the expected results.
    But at the load time, it throws the below error:

    >db2 load from objmaint.del insert into schemaName.tableName
    SQL0104N An unexpected token "insert" was found following "<identifier>".
    Expected tokens may include: "OF". SQLSTATE=42601

    I checked in the information center for the syntax. Tried including modified clause and lobinfile clause also, though not required always but its giving similar kind of error.

  4. #4
    Join Date
    Feb 2009
    Posts
    114
    That's a load problem - not audit. You are missing file type, e.g.
    LOAD FROM objmaint.del OF DEL insert into schemaName.tableName

Posting Permissions

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