Skip to content

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

New Db2 LUW Support Portal

Came across this recently looking for some certification help for a client. Here is the link:

https://www.ibm.com/mysupport/s/topic/0TO500000001fUNGAY/db2-linux-unix-and-windows?language=en_US&productId=01t50000004WmTk

The Birds Nest – Db2 Native Encryption

Paul Bird from the Toronto Lab has quite a good blog on using Db2 Native Encryption. Take a look at http://www.idug.org/p/bl/et/blogid=70&blogaid=721

Great post on History of Db2 LUW

http://perspectives.mvdirona.com/2017/12/1187/

IBM Tech-note Re: Spectre and Meltdown

http://www-01.ibm.com/support/docview.wss?uid=http://www-01.ibm.com/support/docview.wss?uid=swg22012320

Great article that summarizes Chips and OPerating Systems effected by Meltdown and Spectre

Covers all the different CHIP brands and Operating Sustems along with planned action.

https://www.nextplatform.com/2018/01/08/cost-spectre-meltdown-server-taxes/

Meltdown Details

Read the white paper here:

https://meltdownattack.com/meltdown.pdf