Sybase DC35823-01-1500-04 manual 118, Creating a device for the audit database transaction log

Adding auditing

List of	devices for the	audit tables:
Logical	name Physical	name	Segment name	Table name	Size

6.Audit_01' secret1/sybase_dr/install/aud1.dat’ sysaudits_01 5

5To add multiple audit devices, repeat steps 1– 6.

You can add as many as eight devices. Sybase recommends adding three or more audit table devices.

After adding a device, auditinit returns to the Configure Auditing menu and displays all the devices you have created.

CONFIGURE AUDITING

1.Configure auditing: yes

2.Add a device for audit table(s)

3.Add a device for the audit database transaction log

4.Delete a device entry

5.Change a device entry

List of		devices	for the audit	tables:
Logical		name	Physical name	Segment name	Table
name		Size
6.	Audit_01'		/secret1/sybase_dr/install/aud1.dat’ sysaudits_01			5
7.	Audit_02'		/secret1/sybase_dr/install/aud2.dat' sysaudits_02			5

vCreating a device for the audit database transaction log

1From the Configure Auditing menu, select Add a Device for the Audit Database Transaction Log.

auditinit displays the Add/Change a New Device for Auditing menu.

ADD/CHANGE A NEW DEVICE FOR AUDITING

1.sybsecurity physical device name:

2.Logical name of the device:

3.Size of the new device (Meg):

4.Device size for auditing:

2 Select Sybsecurity Physical Device Name.

auditinit prompts for the physical name and supplies you with a default, if available:

Enter the physical name of the device to use for the sybsecurity database (default is''):

/dev/path_to_partition

118 Adaptive Server Enterprise