Db2 Up for 730 days and Counting, Over 24 Billion Transactions….on Windows!

Db2 9.7, Windows 2008 R2

 

C:\Users\Administrator>db2pd -alldbs -hadr

 

Database Partition 0 — Database FNPRD — Active — Up 733 days 05:50:23 — Date 2018-03-25-12.58.10.082000

 

HADR Information:

Role    State                SyncMode   HeartBeatsMissed   LogGapRunAvg (bytes)

Primary RemoteCatchup        SuperAsync 0                  51316

 

ConnectStatus ConnectTime                           Timeout

Connected     Thu Dec 07 18:46:41 2017 (1512690401) 120

 

LocalHost                                LocalService

10.221.37.1                              db2h_DB2_1

 

RemoteHost                               RemoteService      RemoteInstance

10.221.37.2                              db2h_DB2_2         DB2

 

PrimaryFile  PrimaryPg  PrimaryLSN

S0505974.LOG 4866       0x0000598C5079A210

 

StandByFile  StandByPg  StandByLSN

S0505974.LOG 4659       0x0000598C506CB2D1

 

Database Partition 0 — Database FNPOS — Active — Up 733 days 05:49:30 — Date 2018-03-25-12.58.10.815000

 

HADR Information:

Role    State                SyncMode   HeartBeatsMissed   LogGapRunAvg (bytes)

Primary RemoteCatchup        SuperAsync 0                  0

 

ConnectStatus ConnectTime                           Timeout

Connected     Thu Dec 07 18:46:23 2017 (1512690383) 120

 

LocalHost                                LocalService

10.221.37.1                              db2h_DB2_3

 

RemoteHost                               RemoteService      RemoteInstance

10.221.37.2                              db2h_DB2_4         DB2

 

PrimaryFile  PrimaryPg  PrimaryLSN

S0018361.LOG 5387       0x0000012FC405BC0D

 

StandByFile  StandByPg  StandByLSN

S0018361.LOG 5383       0x0000012FC40570AC