diag_histlist 
Use this DBM command to display the available log files.
If you execute the command without specifying a time stamp, the system displays a list of all available log files with their time stamps and the directory they are stored in.
If you specify a time stamp in addition to the DBM command, the system displays the file IDs of the log files that have this time stamp. You can display the contents of a file by using the file ID (see: file_getfirst).
You can, however, also use the information about the directory to access log files using operating system commands. The path of the directory that contains the log files is defined by the value of the special database parameter DiagnoseHistoryPath.
Prerequisites
You have the server permission DBFileRead.
Structure
diag_histlist [<YYYYMMDDHHMMSS>]
Option |
Description |
|---|---|
<YYYYMMDDHHMMSS> |
Time format for the change date of the backup history: Year Month Day Hours Minutes Seconds |
Result
After Entering a Command Without a Time Stamp
OK
<timestamp> <directory>
<timestamp> <directory>
...
The system displays a list of all available log files.
Value |
Description |
|---|---|
<timestamp> |
Time stamp |
<directory> |
File directory |
After Entering a Command with a Time Stamp
OK
<timestamp>\<file_ID>
<timestamp>\<file_ID>
...
The system displays the file IDs of all available log files.
Value |
Description |
|---|---|
<file_ID> |
File ID |
In the event of errors, see Reply Format.
Example
Call Database Manager CLI, log on as the operator OLEG with the password MONDAY, connect to the database DEMODB.
Display the list of the log files available for this database:
>dbmcli -u OLEG,MONDAY -d DEMODB diag_histlist
OK
20080922131308 C:\Documents and Settings\All Users\Application Data\sdb\data\wrk\DEMODB\DIAGHISTORY\DEMODB_20080922_13-13-08
20080922131308 C:\Documents and Settings\All Users\Application Data\sdb\data\wr k\DEMODB\DIAGHISTORY\DEMODB_20081008_16-39-48
or
Call Database Manager CLI, log on as the operator OLEG with the password MONDAY, connect to the database DEMODB.
Display the file IDs of the log files:
>dbmcli -u OLEG,MONDAY -d DEMODB diag_histlist 20081008163948
OK
DIAGHIST#20081008_16-39-48\knldump
DIAGHIST#20081008_16-39-48\KnlMsg
DIAGHIST#20081008_16-39-48\knltrace
DIAGHIST#20081008_16-39-48\rtedump
More Information
Database Administration, Log Files