Displaying Log File Information (SAP Library - Data Retention Tool (DART) (CA-GTF-DRT))

Displaying Log File Information

Use

This utility allows you to obtain a log of DART jobs that were executed on your system, and in which files they were created. This includes:

Data extraction

Merging data extracts

Rebuilding a data extract

Exporting view data into a file, when using the View query utility

DART keeps two types of logs: one for data extracts, and the other for exported view data files. The ALV is used to display information allowing you to personalize display variants.

The following table describes the types of jobs each of the logs keeps:

Log Type	Job Types
Data extract log	Data extraction Merging data extracts Rebuilding a data extract
View query log	Exporting view query data into a file

Both logs list jobs regardless of whether they were executed interactively or in the background. They allow you to archive files and retrieve archived files via the ArchiveLink interface.

Procedure

Displaying Data Extract Log

Displaying All Jobs

From the main DART screen choose Extras ® Display extract log.

The system lists the DART jobs executed on your system.

The log contains:
Details of each job, such as the name of the user who ran it, and the date and time it ran
List of the files created as a result of executing the job
Date and time of the deletion and name of the user who deleted the file (If the files associated with the job have been since deleted)

You can now perform one of the following tasks:

Task	Instructions
Display the details of a single job	Doubleclick the file name to display the contents. Alternatively, you can mark the line and choose Details. Double-click the file name to display the contents. View the segment statistics. To display unformatted records from an extract file double-click the file name.
Look at the extract created by the job	Select the job in the list. Choose Browse extract. Enter the directory set for the extract. This invokes the Data extract browser tool to view the extract you have selected.
Delete the extract created by the job (You can also delete a data extract from the main DART menu)	Choose Edit ® Delete data extract. This deletes the extract created by the job, and marks the extract as deleted in the log list. If the data extract has already been archived, only the local files will be deleted.
Hide the lines of jobs for which the extract has been deleted	Choose Edit ® Hide deleted extracts. The icon changes to Show deleted extracts, allowing you to redisplay these jobs in the list.
Go to the view query log list (described below)	Choose Goto ® View query log.
To reset the Archive status To restore Archivelink log To either import from the archive or to export to the archive	Choose Extras ® Reset Archive Status. Choose Extras ® Restore Archivelink log Click on the appropriate import from or export to archive icon.
To view a legend that contains explanations of the various Export to archive and Import from archive icons	Choose Legend

Displaying View Query Log

From the main DART screen choose Extras ® Display view log.

You can now perform one of the following tasks:

Task	Instructions
Look at the file created by the job, which contains the view data you have exported	Select the job. Choose Display file. Enter the directory set of the exported view file. Enter the maximum number of records to display in the Max no. of hits field. Enter an offset number, if you wish to view the data starting from some point in the middle of the view data. You specify this as a byte number. For example, if the exported view file size is 4K (4,000 bytes), you can look at the second half of the file by specifying 2,000 as the offset. This displays the actual contents of the exported file. You may also view the exported view data file with a spreadsheet program or with a text editor.
Look at the original data extract file on which the view is based	Choose Browse extract. Enter the directory set of the saved view file. This calls the Data extract browser query tool to view the source extract file.
Delete the exported view data file created by the job	Choose Edit ® Delete view file.
Hide the lines of jobs for which the exported view data file has been deleted	Choose Hide deleted files. The display changes to Show deleted files, allowing you to redisplay their jobs in the list.
To reset archive status To restore Archivelink log To either import from the archive or to export to the archive	Choose Extras ® Reset Archive Status Choose Extras ® Restore Archivelink log Click on the appropriate import or export to archive icon.
To view a legend that contains explanations of the various Export to archive and Import from archive icons	Choose Legend.

Note

If you append data to an existing file when exporting view query data, the job in which you exported the data is listed as a separate entry under the entry of the original export.

When you then invoke the Display view file function, the default value of the offset is the location of the first appended data record. Accept the default if you wish to view the file starting at the beginning of the appended data.