The system table SYSINFO.LOGVOLUMES describes the log volumes used.
ID |
FIXED(5) |
Number of the volume |
CONFIGUREDSIZE |
FIXED(20) |
Configured size of the volume (KB) |
USABLESIZE |
FIXED(20) |
Area of the volume that can be used for log entries (KB) |
PATH |
CHAR(256) |
Name of the volume |
MIRRORPATH |
CHAR(256) |
Name of the mirrored volume NULL, if the volume is not mirrored |
Concepts of the Database System, How Databases Log Data Changes