Use of the system table SYSINFO. LOGSTATISTICS
You can use the DEMODB demo database. Start the Database Studio and log onto the demo database DEMODB: Logging On to a Database.
Error while parsing external reference: '0A8E4002F5D54E7685D13A24C85D111E/REUSE_SQLTUT_SQL_ANWEISU'. Cause: Could not resolve the target for key reference "0A8E4002F5D54E7685D13A24C85D111E/REUSE_SQLTUT_SQL_ANWEISU"
Error while parsing external reference: 'D5FD03E81F76407BACF7141D4F55BD5E/REUSE_SYSTAB_ALLGHINWEIS'. Cause: Could not resolve the target for key reference "D5FD03E81F76407BACF7141D4F55BD5E/REUSE_SYSTAB_ALLGHINWEIS"
You can use the system table LOGSTATISTICS to determine the following database information, among other things:
Size of the log area and used log area
SELECT usablesize, usedsize, usedsizepercentage
FROM SYSINFO.LOGSTATISTICS
Number of log queues and their size(s)
SELECT queuecount, queuesize
FROM SYSINFO.LOGSTATISTICS
Size of the log area that has not yet been backed up
SELECT notsavedsize, notsavedpercentage
FROM SYSINFO.LOGSTATISTICS