syslogs
The syslogs table provides information about space
use in logical-log files. In the flags column, each bit position
represents a separate flag. For example, for a log file, the flags column can have flags set for both current log file and temporary
log file. Thus, it might be easier to read values in the flags column if the values are returned using the HEX function.
| Column | Type | Description | ||
|---|---|---|---|---|
| number | smallint | Logical-log file number | ||
| uniqid | integer | Log-file ID | ||
| size | integer | Number of pages in the log file | ||
| used | integer | Number of pages used in the log file | ||
| is_used | integer | 1 If file is used, 0 if not | ||
| is_current | integer | 1 If file is the current file, 0 if not | ||
| is_backed_up | integer | 1 If file has been backed up, 0 if not | ||
| is_new | integer | 1 If the log has been added since the last level-0 dbspace backup, 0 if not | ||
| is_archived | integer | 1 If file has been placed on the backup tape, 0 if not | ||
| is_temp | integer | 1 If the file is flagged as a temporary log file, 0 if not | ||
| flags | smallint | Flags | Hexadecimal | Meaning |
| 1 | 0x01 | Log file is in use | ||
| 2 | 0x02 | File is current log file | ||
| 4 | 0x04 | Log file has been backed up | ||
| 8 | 0x08 | File is newly added log file | ||
| 16 | 0x10 | Log file has been written to dbspace backup media | ||
| 32 | 0x20 | Log is a temporary log file | ||