Create a Transfer Log Maintenance application

The Transfer Log Maintenance automatically deletes Transfer log records that are older than a specified number of days (30 days 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 TransferLogMaintApp rules package in the Transaction Manager before you can use a Transfer Log Maintenance application. For more information, see Manage rules packages.

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

Note You can also use the log_export command-line utility to export transfer log entries.
  1. Select Application and click Add New.
  2. The New Application page is displayed.
  3. Select Transfer Log Maintenance from the mandatory Application Type list.
  4. For an embedded database or an external Microsoft SQL Server database, the following page is displayed.
  5. New Application - Transfer Log Maintenance
  6. For an external Oracle database, the following page is displayed.
  7. New Application - External Oracle database
  8. For an external Oracle database where the export functionality is not available, the following page is displayed.
  9. Transfer Log Maintance - Oracle
  10. Note When the server uses an Oracle database, the data export option and related fields are 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."
  11. Enter a unique Application Name. You cannot enter spaces-only values in this field. For more information, see Spaces in required fields.
  12. Note The application name cannot include any forward slash (/) characters.
  13. (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.
  14. Note As with all applications, assigning business units to the application controls which delegated administrators can manage the application. It does not control which log entries Transfer Log Maintenance processes.
  15. (Optional) Enter an application Description.
  16. In the Delete transfer log when ____ days old field, specify how old transfer log entries will be when they are deleted. The application computes the age of transfer log entries to midnight of the day it is run. For example, if the value of this field is 1 and the application runs at 4:00 AM., the application deletes entries created before midnight on at the beginning of the previous day. It does not delete entries created between midnight and 4:00 AM. on the previous day. This field is mandatory.
  17. You cannot enter spaces-only values in this field. For more information, see Spaces in required fields.
  18. If your server uses an Oracle database, continue with step 8.
  19. To export logs from an embedded database or an external Microsoft SQL Server database, select export data before deletion.
    1. In the Export directory field, specify where the export files are stored. You must enter a full directory path. If you are exporting from a Microsoft SQL Enterprise Edition database, you must also complete the following steps on the database server:
      1. Create an export directory on the Microsoft SQL Server.
      2. Create a new filegroup:
      4. Create a file:
      5. ALTER DATABASE databaseuser
             ADD FILE
             (NAME = N'ST_FILETRACKING_ARCHIVE_databaseuser',
             FILENAME = N'<EXPORT_DIR>\ST_FILETRACKING_ARCHIVE_databaseuser.ndf',
             SIZE = 10MB,
             MAXSIZE = 100MB,
             FILEGROWTH = 1MB)
      6. Grant all permissions on the <EXPORT_DIR> directory created in step "i" 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.
    2. In the Delete exported files when data is: ____ days old field, type the period of time (in days) exported files remain in the export directory before they are deleted. If you leave this field empty or specify zero, SecureTransport does not delete the files.
    3. In the Number of records per file: ____ thousands field, specify the maximum number of records (in thousands) that can exist in an exported file. When this value is exceeded, SecureTransport starts to export the transfer log entries in a new file.
  20. To export logs from an external Oracle database, select Enable logs export.
    1. In the Export folder field, specify where the export files are stored. 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:
      4. Grant all privileges on the directory to the ST user:
      6. Grant create table privileges to the ST user:
    2. In the Parallelism Degree field, specify the number of processors to use during an export operation. You can specify any value for one to the number of processors available on the server. You can limit the effect of the export on database performance by limiting the number of processors used.
  21. (Optional) In the Schedule pane, click Configure to schedule a future task or to schedule a series of future tasks.
  22. The Configure Schedule dialog box is displayed.
  23. Configure Schedule
  24. 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.
  25. 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.
  26. For information on working with the SecureTransport scheduler , see Scheduled downloads and tasks. Click OK when finished setting the schedule.
  27. Click Create Application.

Related topics:

Related Links