Shulou(Shulou.com)06/01 Report--

In the HADR monitoring of DB2 database, it is found that for a certain period of time every day, many applications are in commit active state, which has an impact on application performance.

Guess it could be caused by two reasons

The log is written slowly.

Slow network communication

What's the reason? Talk with surveillance data.

Run the following SQL at a frequency of every 5 seconds

INSERT INTO temp1 select CURRENT_TIMESTAMP, LOCK_WAIT_TIME, LOG_DISK_WAIT_TIME,TOTAL_COMMIT_TIME from TABLE (MON_GET_WORKLOAD (',-2)) AS t

Also running together is the following SQL

INSERT INTO temp2 select CURRENT_TIMESTAMP,LOG_WRITE_TIME,LOG_WRITES,LOG_HADR_WAIT_TIME,LOG_HADR_WAITS_TOTAL from table (mon_get_transaction_log (- 1)) as t

The monitoring of the table function gets a cumulative value. If you find a way to get the difference every 5 seconds, you can see which period of time the data is abnormal.

Data from table temp1

TIMESTAMP / LOCK_WAIT_TIME / LOG_DISK_WAIT_TIME/TOTAL_COMMIT_TIME

17:39:16, 0, 2, 3

17:39:21, 0, 2, 2

17:39:26, 0, 2, 2

17:39:31, 0, 4, 4

17:39:37, 0, 2, 2

17:39:42, 0, 9, 9

17:39:47, 0, 3, 3

17:39:52, 79, 99, 99

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.