Special Considerations for Threshold Procedures for Audit Segments

Learn about special considerations for threshold procedures for audit segments.

If your installation used a threshold procedure to archive the sysaudits table using T-SQL similar to the following example:
INSERT MyPre15SysAuditHistoryTable SELECT * FROM
sysaudits_0n
Where n corresponds to the sysaudits table number 1 – 8 and MyPre15SysAuditHistoryTable is a table defined prior to Adaptive Server version 15.5, then you must alter MyPre15SysAuditHistoryTable to add a nodeid column using the following command:
alter table MyPre15SysAuditHistoryTable 
    add nodeid tinyint NULL

See the Reference Manual for system tables sysaudits01 through sysaudits08 for further details about the sysaudits tables.