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

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