Procedure documentation Displaying the Diagnosis History Locate the document in its SAP Library structure

Use

You display the available diagnosis history.

If a Structure linkdatabase instance was not properly stopped, the system backs up certain database files during the restart of the database instance (Starting the Database Instance). These files are required for the diagnosis of problems that occurred previously. The files are backed up by the system in a diagnosis backup and stored in the directory DIAGHISTORY in the Structure linkrun directory of the database instance (Database Manager default value). You can define this path using the parameter DIAG_HISTORY_PATH.

If you run the command without specifying the option <YYYYMMDDHHMMSS>, the system displays a list of all available diagnosis backups. These are listed with their time stamps and the paths under which the Structure linkbackups are stored. This means that you can also access the diagnosis backup using operating system resources.

If you enter the command again with the option <YYYYMMDDHHMMSS> (timestamp), the system displays the file IDs of the files belonging to the diagnosis backup. Using the file ID, you can display the contents of a database file (Opening a Database File).

Prerequisites

You have the DBM operator authorization DBFileRead.

Syntax

diag_histlist [<YYYYMMDDHHMMSS>]

Example

Command without option specified

dbmcli -d DB -u dbm,dbmp diag_histlist

OK
20010706140709  d:\sapdb\usr\wrk\DB\DIAGHISTORY\A74_20010706_14-07-09
20010706162223  d:\sapdb\usr\wrk\DB\DIAGHISTORY\A74_20010706_16-22-23

Example

Command with option specified

dbmcli -d DB -u dbm,dbmp diag_histlist 20010706162223

OK
DIAGHIST#20010706_16-22-23\knldiag
DIAGHIST#20010706_16-22-23\knldump
DIAGHIST#20010706_16-22-23\knltrace
DIAGHIST#20010706_16-22-23\rtedump

Reply

The result of the request depends on whether you specify the option <YYYYMMDDHHMMSS> (time stamp).

After Entering a Command Without an Option

If you do not specify a time stamp, the system displays a list of all available diagnosis backups.

OK<NL>
<YYYYMMDDHHMMSS> <directory><NL>

<YYYYMMDDHHMMSS> <directory><NL>

...

After Entering a Command with an Option

If you specify a time stamp, the system displays a list of the files that belong to the diagnosis backup.

OK<NL>
<file_id><NL>

<file_id><NL>

...

In the event of errors, see Reply Format.