Auditing options are added in support of in-memory and relaxed-durability databases, incremental data transfer, and deferred name resolution.
| Audit option | Command or access to be audited | Event | Information in extrainfo |
|---|---|---|---|
| all, create | transfer table | 136 | Keywords or options: transfer_table |
| all, create | alter table | 3 |
If alter table contains set transfer table on, Adaptive Server prints this to extrainfo: SET TRANSFER TABLE ON. If alter table contains set transfer table off, Adaptive Server prints this to extrainfo: SET TRANSFER TABLE OFF. |
| all, create | create table | 12 |
If create table contains with transfer table on, Adaptive Server prints this to extrainfo: WITH TRANSFER TABLE ON. If create table contains with transfer table off, Adaptive Server prints this to extrainfo: WITH TRANSFER TABLE OFF. |
| all, create | create database | 9 | Keywords or options: inmemory |
| all, create | alter database | 2 | Keywords or options: inmemory |
| all, create | create procedure | 11 | Keywords or options: deferred_name_resolution |