How can I determine what is the current percentage of the Datacom log file (LXX) in use?

Document ID : KB000026645
Last Modified Date : 14/02/2018
Show Technical Document Details

Introduction:

 

We need a quick way to check how full is currently our Datacom Log file (LXX).

Instructions:

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
FROM SYSADM.MUF_LOGGING;

 

which produces the following report:

Figure 1

This query can be run online (DQRY, DDOL) or in batch (DBSQLPR).

Additional Information:

 

For more information about Datacom/DB System Tables, you can read the manual titled "CA-Datacom/DB System Tables Reference Guide".