-- dba.v_total_log_used_mb - total log used in MB

-- Downloaded from http://www.ebenner.com/db2luwdba-howto
-- For use only with other components from article series:
-- "Effective DB2 Monitoring with Snapshot Administrative Views"
-- by Jeffrey Benner, in _DB2 LUW DBA HowTo_
-- Please direct any questions to consulting@ebenner.com

-- This work is licensed under the Creative Commons Attribution 3.0 United States License. To view a copy of this license, visit http://creativecommons.org/licenses/by/3.0/us/ or send a letter to Creative Commons, 171 Second Street, Suite 300, San Francisco, California, 94105, USA.

create view dba.v_total_log_used_mb as
select SNAPSHOT_TIMESTAMP,
decimal( (decimal(TOTAL_LOG_USED, 20, 1) / decimal(1048576, 9, 1)), 14, 1) as TOTAL_LOG_USED_MB from dba.snapdb;