Installation guide

Reenabling Auditing
If the server you upgraded from was configured for auditing, reenable auditing in the upgraded
server.
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 preupgrade to help determine 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_addlogin
stored procedure in your server before upgrade,
run:
sp_audit "exec_procedure", "all", "sp_addlogin", "on"
Updating Threshold Procedures for Audit Segments
An update is required for threshold procedures used to archive audit segments.
If your previous installation used a threshold procedure, similar to this, 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 Adaptive Server version
15.7 ESD #2, 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.
Reenabling Replication Server After the Dataserver Upgrade
If you disabled replication before the upgrade, you must reenable replication.
1.
Remove older formatted log records from your database.
2.
Use the dump tran command to dump the database and transaction logs to remove the
older format log records from your database. This prevents Replication Agent
™
and other
log readers from accessing the preupgrade portion of the transaction logs.
1> use master
2> go
1> dump database sales to dumpdev
2> go
CHAPTER 10: Adaptive Server Upgrades
90 Adaptive Server Enterprise