3193812 - isql session hangs when audit table is full - SAP ASE for Business Suite

• You are unable to change any DB parameter from isql using stored procedure "sp_configure": the session is getting hang.
• ASE auditing is enabled (ASE configuration parameter "auditing" = 1) which is normally the default setting for Business Suite on ASE systems.
• Checking the current audit database it is reported that there is only one audit table like in this sample:

isql -S<SID> -Usapsso -X -w999

1> use sybsecurity
2> go
1> sp_helpsegment
2> go
 segment name       status
 ------- ---------- ------
       0 system          0
       1 default         1
       2 logsegment      0
       3 aud_seg_01      0 <<<< one audit table
(return status = 0)

• Checking existence of threshold for audit segments, you'll have this output where there is no reference of audit table segment "aud_seg_01":

isql -S<SID> -Usapsso -X -w999

1> use sybsecurity
2> go
1> exec sp_helpthreshold
2> go

segment name   free pages   last chance   threshold procedure
-------------- ------------ ------------- ------------------------
logsegment              568             1 sp_thresholdaction

SAP Adaptive Server Enterprise (ASE) 16.0
SAP Netweaver - All versions

KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , Problem