You also notice in Example 2-222 on page 246 how the other VM ( 1950678c-18bf-4c87-860c-f9e6ec24b513 ) is sending heartbeats normally through both VIOSs ( count1:0 count2=0 ). 

To understand how these missed heartbeat counters are computed, we go to the DBN node and look for database log entries that correspond to one of the hsGetMissCount  calls. We look at the hsGetMissCount  call that was issued around 22:09:55.862, and the findings are shown in Example 2-223. 

# /usr/ios/cli/ioscli cluster -status -verbose|grep -p DBN|egrep "Node Name|DBN" Node Name: usaxvia053ccpx1 Node Roles: DBN # ------------ # uname -uL IBM,0221282FW 2 usaxvia053ccpx1 # ls -latr /home/ios/logs/pg_sspdb/*.log ... -rw-r--r-- 1 vpgadmin bin 20971642 Aug 27 21:36 pg_sspdb-27-21-15.log -rw-r--r-- 1 vpgadmin bin 20971706 Aug 27 21:56 pg_sspdb-27-21-36.log -rw-r--r-- 1 vpgadmin bin 20971701 Aug 27 22:14 pg_sspdb-27-21-56.log -rw-r--r-- 1 vpgadmin bin 20971546 Aug 27 22:35 pg_sspdb-27-22-14.log ... -rw-r--r-- 1 vpgadmin bin 20971710 Aug 28 13:52 pg_sspdb-28-13-31.log drwxrwxr-x 8 bin bin 4096 Aug 28 14:00 .. -rw-r--r-- 1 vpgadmin bin 20971545 Aug 28 14:12 pg_sspdb-28-13-52.log drwx------ 2 vpgadmin bin 4096 Aug 28 14:30 . -rw-r--r-- 1 vpgadmin bin 17718556 Aug 28 14:30 pg_sspdb-28-14-12.log # cp /home/ios/logs/pg_sspdb/pg_sspdb-27-21-56.log pg_sspdb-27-21-56.log.missedHb # more pg_sspdb-27-21-56.log.missedHb ... 2019-08-27 22:09:55.861 CUT|5d65aa33.19e0118|LOG: statement: RELEASE _EXEC_SVP_20122a88;SAVEPOINT _EXEC_SVP_20122a88;select DISTINCT vmuuid from vioshs.map where viosuuid='5c3196a3-c41f-4b5c-9861-dee6077081c6' OR viosuuid='0ab5001f-2c3e-4fbb-97ea-41d3f8c4f898' 2019-08-27 22:09:55.862 CUT|5d65aa33.19e0118|LOG: statement: RELEASE _EXEC_SVP_20122a88;SAVEPOINT _EXEC_SVP_20122a88;SELECT CAST ((EXTRACT( epoch FROM NOW(): :timestamp) - EXTRACT( epoch FROM vioshs.map.vmHbMissed::timestamp)) AS BIGINT) FROM vioshs.map WHERE vioshs.map.vmuuid='61be20f0-09a8-4753-b5e5-564f8a545ed5' AND vioshs.map.viosuuid='5c3196a3-c41f-4b5c-9861-dee6077081c6' 2019-08-27 22:09:55.862 CUT|5d65aa33.19e0118|LOG: statement: RELEASE _EXEC_SVP_20122a88;SAVEPOINT _EXEC_SVP_20122a88;SELECT CAST ((EXTRACT( epoch FROM NOW(): :timestamp) - EXTRACT( epoch FROM vioshs.map.vmHbMissed::timestamp)) AS BIGINT) FROM vioshs.map WHERE vioshs.map.vmuuid='61be20f0-09a8-4753-b5e5-564f8a545ed5' AND vioshs.map.viosuuid='0ab5001f-2c3e-4fbb-97ea-41d3f8c4f898' pg_sspdb-27-21-56.log.missedHb (74%) 

So, the missed heartbeat counters are computed as the difference between the current moment and the missed heartbeat time stamp that was reported by the HM in the HSDB map table ( (EXTRACT( epoch FROM NOW()::timestamp) - EXTRACT( epoch FROM vioshs.map.vmHbMissed::timestamp)) AS BIGINT ). 

