Skip to content

Up over 370 days Straight and going, 7.2 Billion Transactions

January 8, 2016

Now at 420 days…..

Gunning Technology Solutions, LLC. THE WORLD LEADER IN DB2 LUW CONSULTING!

This is an example of what a properly configured and monitored DB2 LUW HADR implementation can provide. In this example, this two database instance running HADR in superasync mode to one standby server has been up over 370 days without an outage, with reports running against the standby databases in read only mode. Get started with DB2 today and see what you can achieve!

Database Partition 0 — Database FLW — Active — Up 375 days 01:28:32 — Date 2015-11-29-13.06.33.282000

HADR Information:

Role   State               SyncMode   HeartBeatsMissed   LogGapRunAvg (bytes)

Primary RemoteCatchup       SuperAsync 0                 57371

ConnectStatus ConnectTime                           Timeout

Connected     Thu Nov 05 13:30:59 2015 (1446748259) 120

LocalHost                               LocalService

10.221.37.1                             db2h_DB2_1

RemoteHost                               RemoteService     RemoteInstance

10.221.37.2                            db2h_DB2_2         DB2

PrimaryFile PrimaryPg PrimaryLSN

S0405097.LOG 7153       0x000052083D8E94C3

StandByFile StandByPg StandByLSN

S0405097.LOG 7022       0x000052083D8663A2

Database Partition 0 — Database LARG — Active — Up 375 days 01:04:01 — Date 2015-11-29-13.06.34.077000

HADR Information:

Role   State               SyncMode   HeartBeatsMissed   LogGapRunAvg (bytes)

View original post 38 more words

From → Uncategorized

Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: