We need a quick way to check how full is currently our Datacom Log file (LXX).
The easiest way is to run the following SQL query from MUF_LOGGING dynamic system table:
SELECT IN_USE_BLOCKS, TOTAL_BLOCKS,
(IN_USE_BLOCKS*100/TOTAL_BLOCKS) AS PERCENT_FULL
which produces the following report:
This query can be run online (DQRY, DDOL) or in batch (DBSQLPR).
For more information about Datacom/DB System Tables, you can read the manual titled "CA-Datacom/DB System Tables Reference Guide".