Search code examples
db2transaction-log

How to find out current transaction log size in DB2?

How to find out the current transaction log size? Is it possible to do e.g. by querying some system tables with SQL? It would also be interesting to find out the maximum size for the transaction log.

Is the only option to look it up from the file system?

Solution

  • Yes, you can get this data from table SYSIBMADM.DBCFG

    For example - I had to check database log parameters, so I used query:

    SELECT * FROM SYSIBMADM.DBCFG
WHERE
    NAME IN ('logfilsiz','logprimary','logsecond')