Creating a Device for the Audit Database Transaction Log

Add a device for the audit 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

    where path_to_partition is the path to the raw partition for the device.

  3. Enter the full path name of a physical device.
  4. Press Return.
    auditinit displays the Add/Change a New Device for Auditing menu and the value you selected for the physical name of the device. 
    ADD/CHANGE A NEW DEVICE FOR AUDITING 
1.sybsecurity physical device name: 
      /secret1/sybase_dr/install/auditlog.dat
2.Logical name of the device: 
3.Size of the device: 
4.Device size for auditing:
  5. Proceed through the remaining items on this menu. As you do so, be aware of:

    • Sybase recommends a minimum size of 2MB for the size of the transaction log.

    • auditinit displays the size in both Size of the Device and in Device Size for Auditing in the Add/Change a New Device for Auditing menu.

    • The Device Size for Auditing default value is equal to the size of the device, based on the assumption that you may want to devote the entire device to log for the auditing task. Use only a subset of the device, edit the Size of the Device value.

  6. Press Ctrl+A to accept the settings that appear in the Add/Change a New Device for Auditing menu.
    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 
8. auditlog    /secret1/.../auditlog.dat logsegment   syslogs        2
  7. When you are ready to execute the audit configuration, press Ctrl+A.
  8. On the Sybase Server Configuration screen, press Ctrl+A again. You see:
    Execute the Sybase Server Configuration now?
  9. Enter “y” (yes).
    auditinit executes the tasks to install auditing. When installation completes successfully, you see: 
    Running task: install auditing capabilities.
....................Done
Auditing capability installed.
Task succeeded: install auditing capabilities.
Configuration completed successfully.
Press <return> to continue.
Parent topic: Install Auditing