Moving sybsecurity and saving global audit settings

Drop the sybsecurity database:

drop database sybsecurity

Initialize the first device on which you want to place the sybsecurity database:

disk init name = "auditdev", 
    physname = "/dev/dsk/c2d0s4", 
    size = "10M"

Initialize the device where you want to place the security log:

disk init name = "auditlogdev", 
    physname = "/dev/dsk/c2d0s5",
    size = "2M"

Create the new sybsecurity database:

create database sybsecurity on auditdev
    log on auditlogdev

Load the contents of the old sybsecurity database into the new database. The global audit settings are preserved:

load database sybsecurity from "/remote/sec_file"

Run online database, which upgrades sysaudits and sysauditoptions if necessary:

online database sybsecurity

Load the auditing system procedures using the configuration documentation for your platform.

Extend the sybsecurity database to the device you initialized in step 1:

alter database sybsecurity on auditdev2 = "2M"

Run sp_addaudittable to create the next sysaudits table on the device you initialized in step 1:

sp_addaudittable auditdev2

Repeat steps 1 – 3 for each sysaudits table.