SAP Knowledge Base Article - Preview

2971902 - Enable auditing causes excessive records to be generated with a single command - SAP ASE


  • 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.
    sp_configure 'auditing',1
    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)

    sp_spaceused sysaudits_01

    name rowtotal reserved data index_size unused
    ------------ -------- -------- ------- ---------- ------
    sysaudits_01 14353 3522 KB 3518 KB 0 KB 2 KB
    (1 row affected)
    (return status = 0)



SAP Adaptive Server Enterprise (ASE) 16.0


SAP Adaptive Server Enterprise 16.0


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.