Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2002
    Posts
    456

    Unanswered: db2audit table ddl

    DB2 UDB V7 FP9 on AIX 5.1

    Is there any sample DDL to create audit tables (7 of them) for db2audit output data. I have extracted the output and from their site I can also see the structure of these tables but it will be tedious to certain extent so I am wondering if there is any easy way to do that.

    Thanks

    dollar

  2. #2
    Join Date
    Feb 2004
    Location
    Copenhagen
    Posts
    220

    Audit event

    Hi Dollar489

    To the best of my knowledge there is,
    no way to extract DDL with the audit
    function.

    However I think there is only 1 (one)
    table involved in auditing, what separates the
    records into 7 groups is the auditing event.

    So the easiset way is probably to create the
    table DDL yourself - once and for all.

    If you have tons of events there will be many
    null values of course, and it might be a good idea
    to have separate tables, because different auditing
    events involves different use of variables.

    Sincerely Yours

    Tank

Posting Permissions

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