DB2 FOR LUW / DB2FORLUW / B10 - DB2

SYSIBMADM.LOG_UTILIZATION is returning  SQL0801N  when the
outputs  returned are supposed to be zero.

Example,

=> db2 "select LOG_UTILIZATION_PERCENT from
SYSIBMADM.LOG_UTILIZATION"

LOG_UTILIZATION_PERCENT
-----------------------
SQL0801N Division by zero was attempted. SQLSTATE=22012

This can be reproduced  easily in a  HADR standby database where
all the columns  returned by  LOG_UTILIZATION will be zero.
As a result of that  the  percentage calculation will  have a
division by zero.

Instead of  returning   SQL0801N  it should  return a zero.

The internal counters that track log usage are only updated
during runtime.
HADR standby is considered to be in recovery state (not runtime
state).
So, these values are not tracked.
As a result the monitor will always see 0 for the columns
against this function in the standby.

****************************************************************
* USERS AFFECTED:                                              *
* Any db2 level trying to use LOG_UTILIZATION                  *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to DB2 Version 11 Fix Pack 3                         *
****************************************************************

Don't  run this function in  a  db2 HADR standby.  Or, ignore
the SQL0801N message.

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

22.05.2017
24.04.2020
24.04.2020