Managing Log and Statistics

How to:

Note: You must be logged in as a Server Administrator with workspace configuration privileges in order to make any configuration changes, or to follow any of the following procedures.

To manage the log and statistics from the DMC, expand theWorspace folder, followed by the Logs and Traces folder. Then, right-click DataMigrator Log and Statistics. A shortcut menu will open with your options.

The following options are available in the shortcut menu:

View

Allows you to view the log and statistics tables.

Recreate

Creates empty new log and statistics tables.

Clean

Allows you to specify a date and time.

All records prior to the date and time entered are deleted, and the log and statistics files are rebuilt. This action frees up the space used by the deleted records, so that new records can be added. For FOCUS logs and statistics, this operation does not reduce the size of the log and statistics tables on disk, and new records can still be accepted without growing in size until the newly freed space has been freed up.

Backup

Creates a backup copy of the log and statistics tables on the disk, and a synonym that can be used to retrieve data from them. These tables are created in the <edaconf>/catalog directory that is located on the server (for example, c:\ibi\srv77\dm\catalog). A message will appear in the console showing the location.

Procedure: How to Send an Email Message When There Is an Error Writing to the ETL Log

You can configure the server so that an email message is sent to an address you specify if there is an error writing to the ETL log. For example, even though a log table is automatically maintained so that normal operations prevent it from reaching its maximum size, it is still possible for a flow to generate so many errors that it fills up the log table. This issue can be addressed by having the server send you a message when the log table is full.

  1. Configure the server to connect to a SMTP mail server, as described in How to Configure the Server for E-mail Notification.
  2. There are two ways to customize event routing from the DMC:
    • Right-click the Workspace folder and click Event Routing.

      or

    • Expand the Workspace and then the Logs and Traces folder.

      Right-click Workspace Logs and click Customize Event Routing.

      The Event Routing dialog box opens.

      Click the New button.

    The Customize Event Routing dialog box opens.

  3. Select the following options for each field:
    • Type - Error
    • Filter - 60003 ETLLOG write error
    • EDAPRINT - Yes
  4. In the E-mail field, enter the address where the email message will be sent.
  5. In the Procedure field, enter the name of the process flow, for example, baseapp/pf_backup_recreate.
  6. Click Add.
  7. Click Save and Restart.

WebFOCUS

Feedback