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.0, 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.