Installation guide

10.7.2 Reenabling Auditing

If the server you upgraded from was configured for auditing, reenable auditing in the upgraded server.

Procedure

1. Enter:

sp_configure 'auditing', 1

2. Reenable auditing for all system stored procedures for which auditing was enabled before the upgrade.

a) Use the output of sp_displayaudit recorded during the preupgrade process to identify the system

stored procedures for which auditing was enabled.

b) Reenter the audit options using sp_audit. For example, if you had enabled stored procedure auditing for

sp_addgroup stored procedure in your server before upgrading, run:

sp_audit "exec_procedure", "all", "sp_addgroup", "on"

10.7.2.1 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

sysaudits_0n

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.

Installation Guide for Linux

SAP ASE Upgrades