Updating Threshold Procedures for Audit Segments

An post-upgrade task is required for threshold procedures used to archive audit segments.

If your previous installation used a threshold procedure, similar to this, execute the following to archive the sysaudits table:
INSERT MyPre15SysAuditHistoryTable SELECT * FROM
where n corresponds to the sysaudits table number 1–8 and MyPre15SysAuditHistoryTable is a table defined prior to version 16.0, then you must alter MyPre15SysAuditHistoryTable to add a nodeid column using:
alter table MyPre15SysAuditHistoryTable 
    add nodeid tinyint NULL

See the Reference Manual: Tables for system tables for details about the sysaudits tables.