IT37326: TOTAL_LOG_USED MONITOR ELEMENT SHOW UNREASONABLY HIGH VALUE

Db2 Version 11.1 Mod 4 Fix Pack 7 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• This problem occurs when the LOGFILSIZ database configuration
  parameter is set to 1053721 or higher.
  
  User may notice a very high value of the TOTAL_LOG_USED
  under monitor function mon_get_transaction_log().  The usage
  value reported is much higher than the actual use, and over time
  it gets worse.
  
  The trigger for the incorrect tracking of log space usage is by
  and ONLINE BACKUP operation, or ARCHIVE LOG command,
  which truncates the current log file.
  
  This is not just an incorrect reporting problem.  It can also
  cause
  transactions to fail with SQL0964N error when there should be
  sufficient log space to contain the workload.
  
  
  Deactivate the database can resolve the incorrect tracking of
  log space.
  

Local fix

• Deactivate the database can resolve the incorrect tracking of
  log space.
  
  Configuring LOGFILSIZ database configuration parameter to a
  value smaller than 1053721 can avoid this problem.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description above                                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to DB2 Version 11.1 Mod 4 Fix Pack 7                 *
  ****************************************************************
  

Problem conclusion

• First fixed in DB2 Version 11.1 Mod 4  Fix Pack 7
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  IT37475 IT37495 IT37496

Fix information

• Fixed component name

  DB2 FOR LUW

• Fixed component ID

  DB2FORLUW

Applicable component levels

• RB10 PSN

     UP