diag_histlist 
You display the available log files.
If you execute the DBM command without specifying a time stamp, the system displays a list of all available log files, the directory in which they are stored, and the time stamp for each.
If you specify a time stamp in addition to the DBM command, the system displays the file IDs of the log files. 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 the operating system. The path for the directory that contains the log files is defined by the value of the special database parameter DiagnoseHistoryPath.
Prerequisites
You have the server authorization DBFileRead.
Structure
diag_histlist [<YYYYMMDDHHMMSS>]
Option |
Description |
|---|---|
<YYYYMMDDHHMMSS> |
Time format for 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
<file_ID>
<file_ID>
...
The system displays the file IDs of available log files.
Value |
Description |
|---|---|
<file_ID> |
File ID |
In the event of errors, see Reply Format.
Example
Call the Database Manager CLI, log on as operator OLEG with the password MONDAY, connect to the database instance DEMODB.
Display the list of log files available for this instance:
>dbmcli -u OLEG,MONDAY -d DEMODB diag_histlist
OK
20050324150815 C:\Documents and Settings\All Users\Application Data\sdb\data\wrk\DEMODB\DIAGHISTORY\DEMODB_20050324_15-08-15
20050324150845 C:\Documents and Settings\All Users\Application Data\sdb\data\wrk\DEMODB\\DIAGHISTORY\DEMODB_20050324_15-08-45
or
Call the Database Manager CLI, log on as operator OLEG with the password MONDAY, connect to the database instance DEMODB.
Display the file IDs of the log files:
>dbmcli -u OLEG,MONDAY -d DEMODB diag_histlist 20050324150815
OK
DIAGHIST#20050324_15-08-15\knldiag
DIAGHIST#20050324_15-08-15\knldiag.run
DIAGHIST#20050324_15-08-15\knldiag.start
DIAGHIST#20050324_15-08-15\knltrace
More Information
Database Administration, Log Files