stored procedure: sp_audit_purge

Greetings,
The stored procedure: "sp_audit_purge" the data of which table clean?
The table sybsecurity.sysaudits_01 ?
The table sybsecurity.audit_201106131441022720 ?
The table db_audit.AUD$100004_xxx of Central Repository ?

All of the tables configured for the data-change auditing in the monitored database, i mean tables sybsecurity.audit_XXXXXXXXXXXXXXX
sp_sys_audit_purgge deletes old data from sybsecurity.sysaudits_XX tables

By the way, central repository purge is not procedure based. An Alert Center job is responsible for maintaining data retention policy for tables in the central repository database server

I don't have sp_sys_audit_purge
Please show me the steps to enable the sp.

sybsecurity table:

Name Owner Object_type
------------------------------ ------------------------------ ----------------------
audit_201106161712463680 db_audit user table
audit_201106161718455410 db_audit user table
audit_201106171611238700 db_audit user table
data_audit_apps db_audit user table
data_audit_columns db_audit user table
data_audit_trail db_audit user table
data_audit_users db_audit user table
sys_audit_trail db_audit user table
sysalternates dbo system table
sysattributes dbo system table
sysauditoptions dbo system table
sysaudits_01 dbo system table
sysaudits_02 dbo system table
syscolumns dbo system table
syscomments dbo system table
sysconstraints dbo system table
sysdepends dbo system table
sysgams dbo system table
sysindexes dbo system table
sysjars dbo system table
syskeys dbo system table
syslogs dbo system table
sysobjects dbo system table
syspartitions dbo system table
sysprocedures dbo system table
sysprotects dbo system table
sysqueryplans dbo system table
sysreferences dbo system table
sysroles dbo system table
syssegments dbo system table
sysstatistics dbo system table
systabstats dbo system table
systhresholds dbo system table
systypes dbo system table
sysusermessages dbo system table
sysusers dbo system table
sysxtypes dbo system table
audit_archive_01 dbo stored procedure
audit_archive_02 dbo stored procedure
audit_thresh dbo stored procedure
sp_audit_purge db_audit stored procedure
data_audit_all_co_160000570 dbo default
data_audit_audit__112000399 dbo default
data_audit_audit__128000456 dbo default
data_audit_audit__144000513 dbo default
data_audit_audit__96000342 dbo default
data_audit_source_80000285 dbo default
data_audit_update_208000741 dbo default

Please see http://www.softtreetech.com/dbaudit/db_audit4.pdf, pages 29-30.
"Install" button installs data audit trail purge procedure sp_audit_purge and schedules it periodic run.
"Install System Purge" button installs system audit trail purge procedure sp_sys_audit_purge procedure and schedules it periodic run

Only I can create sp_audit_purge

[img]

There is no button "Install System Purge" for Sybase.[/img]

[img]

[/img]

I see, there is no "Install System Purge" button and procedure for your versions of Sybase ASE. That's because your Sybase version doesn't need them. It takes care of automatic audit trail purge and rotation.

Yes, I would have liked the tool do for me, and I don't run the 'truncate table sysaudits_01' and 'truncate table sysaudits_02' commands every day and empty the log table area with 'dump tran sybsecurity with truncate_only'. Like the other engines are similar commands.

Once you have the central repository properly working, the repository replication jobs will take care of deleting old records from sysaudits_XX tables automatically.

To confirm: The time indicates in part of keep days?

[/img]

That's correct. However, based on your other post http://www.softtreetech.com/support/phpBB2/viewtopic.php?t=23454 I suggest to set this parameter for the moment to "All" that means (do not delete old data explicitly), until the other issue is solved