SAP Knowledge Base Article - Preview

2971902 - The number of audit records generates many rows - SAP ASE

Symptom

  • When auditing is enabled, there are over 14K records are generated with a single command
  • When auditing is disabled, there is no record in sysaudits_01
  • All the select statements that are executed with sp_helpdb, which is multiplied by the number of databases.
    1> sp_configure 'auditing',1
    2> go
    Parameter Name Default Memory Used Config Value Run Value Unit Type
    ---------------- ----------- ------------- -------------- ------------ ------ -------
    auditing 0 0 1 1 switch dynamic
    (1 row affected)
    Configuration option changed. ASE need not be rebooted since the option is dynamic.
    Changing the value of 'auditing' does not increase the amount of memory Adaptive Server uses.
    (return status = 0)
  • 1> sp_spaceused sysaudits_01
    2> go
    name rowtotal reserved data index_size unused
    ------------ -------- -------- ------- ---------- ------
    sysaudits_01 14353 3522 KB 3518 KB 0 KB 2 KB
    (1 row affected)
    (return status = 0)


Read more...

Environment

SAP Adaptive Server Enterpise (ASE)

Product

SAP Adaptive Server Enterprise 16.0

Keywords

Auditing, duplicate, sp_helpdb, rows, curdbid, thisopt, ##822883, #822883, CR822883 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.