Dear

I made a audit thro ttaad4111m000.

give the table name for all companies and database is 001

after one month I want to delete the audit detail of given table. HOW?

pls help, my database size going too big

pls help, my database size going too big

Hi,

Database size and audit log are 2 different things....Audit info is stored at file system level and not in tables.

after one month I want to delete the audit detail of given table. HOW?

To delete you have to use "purge audit files" session and then, delete the files from file system level.

From Purge Audit files. it give a error.

Message Code : ttaad44020
Error : Can not remove sequence 000 of table tdltc004 and company 310 on host 'localhost'

You can remove terminated sequences only.

To delete you have to use "purge audit files" session and then, delete the files from file system level.
Refer to the Session's help:

Purge Audit Files (ttaad4261m000)
Each time an audit sequence file exceeds its maximum size, that is specified in the Audit Trail File Sizes (ttaud3135m000) session, the sequence file is terminated and a new sequence file is generated. The maximum number of sequence files for each table/company combination is 999. When the last sequence file is terminated, the audit server will try to reuse sequence file 000 again. However, the audit server cannot overwrite existing sequence files.
Use this session to remove the old sequence files so that the audit server can reuse them to write new audit information.
To purge sequence files, enter a range of:
tables
packages
companies
sequences
Click Purge to remove the audit sequence files within the range.
Notes
You can purge an audit file only if
cleaning is allowed for the audit file: i.e. if the Cleaning Allowed check box in the Audit Trail Security (ttaud3137m000) session is selected.
you are authorized to purge the audit file. Refer to the online help of the Audit Authorizations (ttaad4162s000) session for details.
the audit file is not currently active: you cannot clean audit files with status "UNTERMINATED".
Important!
Remove audit sequence files through this session only. Do not remove audit sequence files by using commands such as rm or del, because the status of the sequence file is maintained in the sequence header in the audit information file. When this session deletes the sequence file, the session also sets the status of this sequence in the information file as deleted. If the file is removed by any other means, the status is not set and this results in inconsistency

Dear Rao

session Purge Audit Files (ttaad4261m000), ttaud3135m000 and Cleaning Allowed check box in the Audit Trail Security (ttaud3137m000) are not working in B40c4 is4.

I checked that

any other way to do pls update

thanks

Hi SK,

Did you delete audit files from server level? Till then, you wont be able to save disk space.

And i am still not able to understand how your Database is growing because of Audit trail....can you please support your statement with valid observations?

Dear kaukul

forget about database. I want to remove one month record from audit. how?

when I run the session to display audit, it will show only one month report.

Hi,

You can set a job for session "purge audit files" with commit time set to "-30" days. This job can be ran on daily basis in off-business hours. After running this session, you have to delete all files from the audit directory only for this table and that are older than 30 days. As you are using windows, create a batch and put it in the above job below the session "Purge Audit files".