Delete Application Log

http://help.sap.com/SAPHELP_NW04S/helpdata/EN/24/95d207fe2c11d2962300a0c930660b/frameset.htm

Use

You must delete logs to avoid Application Log database table overflow.

Features

You can delete logs in dialog (Program ® Execute) or in the background (Program ® Execute in background).

You have the following options:

• Expiry date
• General selection conditions

Delete options:

• Only calculate number
  The system only calculates the number of logs that can be deleted. The data is not read from the database.
• Create list
  The system creates a list of all logs that can be deleted. You can then decide which logs to delete.
• Delete immediately
  The system deletes all logs from the database that satisfy the selection conditions.

A log can only be deleted when it has expired (reached or passed its expiry date). However, you can delete logs before their expiry date if they have the "Delete before expiry" attribute.

Activities

1. Choose transaction SLG2.
   You go to the dialog box Application Log: Delete Obsolete Logs.
2. Select the appropriate radio button under Expiry date.
3. Specify selection conditions.
4. Choose the relevant option.
5. Choose Execute.
   The logs are deleted from the database.

To delete logs in the background, choose the Delete immediately option - otherwise only the number or list of deletable logs is output.

Log Archiving

If you want to delete logs from the database, due to storage space and runtime considerations, but still want to keep the data, you can archive the logs. A log can, however, only be archived if it has either expired (reached or passed its expiry date) or if it permits deletion before the expiry date.

Logs are archived using the archiving object BC_SBAL.

The log header data, as well as the message data itself, is saved.

The archiving programs, SBAL_ARCHIVE and SBAL_ARCHIVE_DELETE, are integrated and documented in the Archive Development Kit (ADK). For more information, see Data Archiving (CA-ARC) ® Data Archiving (ADK).

You start archive administration with transaction code SARA.