beautypg.com

Sybase DC35823-01-1500-04 User Manual

Page 134

background image

Adding auditing

118

Adaptive Server Enterprise

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

5

To 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

v

Creating a device for the audit database transaction log

1

From 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