Create a Log Entry Maintenance application

The Log Entry Maintenance application automatically deletes Server log records that are older than a specified number of days, hours or minutes (1 day by default). You can schedule how often to run this application and configure it to optionally export these records prior to deletion.

You must enable the LogEntryMaintApp rules package in the Transaction Manager before you can use a Log Entry Maintenance application. For more information, see Enable a rules package.

Use the following procedure to create a Log Entry Maintenance application.

Note You can also use the log_export command-line utility to export server log entries.
  1. Select Application and click Add New.
  2. The New Application page is displayed.
  3. Select Log Entry Maintenance from the mandatory Application Type list.
  4. Note When your server uses an Oracle database, the Export folder and Number of records per file fields is not displayed. Instead, SecureTransport uses a partitioned table for the log entries. Your Oracle DBA can implement data export using Oracle functionality.
    Note When your server uses an Oracle database and the export database procedures are not deployed, the Enable logs export checkbox is disabled and following message is displayed: "The export functionality is not available, because the export database procedures are not deployed."
    Note The granularity of Oracle databases are in days.
  5. Enter a unique Application Name. You cannot enter spaces-only values in this field. For more information, see Spaces in required fields.
  6. Note The application name cannot include any forward slash (/) characters.
  7. (Optional) Use the Assign and Remove buttons to assign business units for the application. The Business Unit List contains the names of business units you have created. For details, see Business units.
  8. (Optional) Enter an application Description.
  9. In the Delete log entries when field, specify how old log entries will be when they are deleted in terms of days, hours, or minutes.
  10. You cannot enter spaces-only values in this field. For more information, see Spaces in required fields.
  11. In the Export folder field, specify where the export files are stored. You must enter a full directory path. If you are exporting from an Oracle database, you must fill in the name of the directory defined in the Oracle database (for example, ST_DMPDIR). On the Oracle Server:
    1. Create the directory where the logs will be exported and make sure that the Oracle user has permissions.
    2. Log in into Oracle as SYSDBA and create the ST_DMPDIR directory using the following syntax:
    3. CREATE DIRECTORY ST_DMPDIR AS '/YOUR_DIRECTORY_HERE';
    4. Grant all privileges on the directory to the ST user:
    5. GRANT ALL PRIVILEGES ON DIRECTORY ST_DMPDIR TO ST_DATABASE_USER
    6. Grant create table privileges to the ST user:
    7. GRANT CREATE TABLE TO ST_DATABASE_USER;
  12. If you are exporting from a Microsoft SQL Enterprise Edition database, you must complete the following steps on the database server:
    1. Create an export directory on the Microsoft SQL Server.
    2. Create a new filegroup:
    3. ALTER DATABASE databaseuser ADD FILEGROUP [ST_SERVERLOG_ARCHIVE]
    4. Create a file:
    5. ALTER DATABASE databaseuser
           ADD FILE
           (NAME = N'ST_SERVERLOG _ARCHIVE_databaseuser',
           FILENAME = N'<EXPORT_DIR>\ST_SERVERLOG_ARCHIVE_databaseuser.ndf',
           SIZE = 10MB,
           MAXSIZE = 100MB,
           FILEGROWTH = 1MB)
           TO FILEGROUP [ST_SERVERLOG_ARCHIVE]
      GO
      
    6. Grant all permissions on the <EXPORT_DIR> directory created in step "a" to the database user.
    7. Grant the database user Backup database and Backup log permissions.
    8. NoteThe Backup log permission is only required if the database is in Full recovery mode.
  13. In the Delete exported files when data is: ____ days old field, specify when SecureTransport deletes old exported log entry data.
  14. In the Number of records per file field, specify the maximum number of records that can exist in an exported file. When this value is exceeded, SecureTransport starts to export the server log entries in a new file.
  15. (Optional) In the Schedule pane, click Configure to schedule a future task or to schedule a series of future tasks.
  16. The Configure Schedule dialog box is displayed.
  17. To schedule an immediate recurrent task, select Schedule events on a recurring basis and then select Start now in the Length of Recurrence pane. The task will begin on the next minute.
  18. Note If you configure a schedule and save it after the scheduled start time, the task will not be executed. You must save your configured schedule before the scheduled start time.
  19. For information on working with the SecureTransport scheduler , see Scheduled downloads and tasks. Click OK when finished setting the schedule.
  20. Click Create Application.

Related topics:

Related Links