Technote (FAQ)
Question
Based on IY85454 onwards the calculation of DB2 sec_log_used_pct attribute should be the following. However, it seems like there is a discrepancy concerning actual statistics captured vs a triggered event as reported by the DBA. The differences was huge. Computation of the formula using native DB2 commands only indicated it to be 33% as opposed to the triggered event at 141%. The DBA suspected this value to be incorrect.
Formula:
secondary_used = total_log_used - (logprimary * logfilsz * 4096)
pct = (secondary_used/(logfilsz * logsecond * 4096)) * 100
Answer
We confirmed with development the enhancement request MR1005073318 is implemented in
upcoming release DB2 Agent v622 which will be available be the end of 2009.
Two new attributes are introduced as follow:
curr_pri_log_used_pct: Percent of current primary log space used;
curr_sec_log_used_pct: Percent of current secondary log space used.
The formula for calculating curr_sec_log_used_pct is:
(sec_logs_allocated/logsecondary)*100
sec_logs_allocated: The total number of secondary log files that are currently being used for the database.
logsecondary: Number of secondary log files configured in db cfg.
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.