The onstat -l command

The onstat -l command displays information about physical and logical logs.

The output section that contains information about each logical-log file includes the following information:
  • The address of the logical-log file descriptor
  • The log file number
  • Status flags that indicate the status of each log (free, backed up, current, and so on)
  • The unique ID of the log file
  • The beginning page of the file
  • The size of the file in pages, the number of pages used, and the percentage of pages used

The log file numbers in the numbers field can get out of sequence if you drop several logs in the middle of the list or if the database server dynamically adds log files.

For more information about and an example of onstat -l output, see the HCL OneDB™ Administrator's Reference.