SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
stored procedure: sp_audit_purge

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
stored procedure: sp_audit_purge
Author Message
lorellan



Joined: 13 Jun 2011
Posts: 124
Country: Ecuador

Post stored procedure: sp_audit_purge Reply with quote
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 ?
Thu Jun 16, 2011 12:32 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6509

Post Reply with quote
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
Fri Jun 24, 2011 1:23 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6509

Post Reply with quote
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
Fri Jun 24, 2011 1:24 pm View user's profile Send private message
lorellan



Joined: 13 Jun 2011
Posts: 124
Country: Ecuador

Post sp_sys_audit_purge is not Reply with quote
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
Fri Jun 24, 2011 3:16 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6509

Post Reply with quote
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
Fri Jun 24, 2011 3:50 pm View user's profile Send private message
lorellan



Joined: 13 Jun 2011
Posts: 124
Country: Ecuador

Post sp_audit_purge, sp_sys_audit_purge not Reply with quote
Only I can create sp_audit_purge

[img]




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

[img]

[/img]
Fri Jun 24, 2011 4:38 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6509

Post Reply with quote
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.
Fri Jun 24, 2011 5:14 pm View user's profile Send private message
lorellan



Joined: 13 Jun 2011
Posts: 124
Country: Ecuador

Post truncate table Reply with quote
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.
Fri Jun 24, 2011 5:33 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6509

Post Reply with quote
Once you have the central repository properly working, the repository replication jobs will take care of deleting old records from sysaudits_XX tables automatically.
Fri Jun 24, 2011 6:39 pm View user's profile Send private message
lorellan



Joined: 13 Jun 2011
Posts: 124
Country: Ecuador

Post time Reply with quote
To confirm: The time indicates in part of keep days?

[/img]

Fri Jun 24, 2011 6:54 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6509

Post Reply with quote
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
Mon Jun 27, 2011 7:50 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.