This is a topic that gets a lot of questions from time to time and it seems folks have a hard time finding the information. When upgrading your Db2 version or installing a Fixpack you should check for driver fixes and new versions. Also it is a good practice to keep your drivers current, which means having a good test environment where you test the new drivers with your applications, this minimizes risk when upgrading. Here is the link: http://www-01.ibm.com/support/docview.wss?uid=swg21363866 . For Db2 database version compatibility for 9.7, 10.1 and 10.5 refer to this link: http://www-01.ibm.com/support/docview.wss?uid=swg21363866 and for 11.1 here : https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.apdv.java.doc/src/tpc/imjcc_c0024897.html. Make the Db2 Knowledge Center your friend!
You are more likely to have a data breach than getting the flu..checkout the new Cost of a Data Breach…..
https://securityintelligence.com/ponemon-cost-of-a-data-breach-2018/
I was working on a customer problem today involving lock timeouts and I refreshed my memory using the great presentation on Locking from lab guru Mike Winer. Check it out at https://s3.amazonaws.com/files.idug.org/download/2096.1410?AWSAccessKeyId=AKIAIZGD7FMLIYLBZNIA&Expires=1530415465&Signature=mytEHkBTxbGEtMBMU1i8a4b7i4I%3D
I uploaded some recent presentations, you can find them at https://philipkgunning.com/presentations/
There were some recent important FLASH notifications regarding Db2 for LUW Security notices, check them out or subscribe: : http://www.ibm.com/support/docview.wss?uid=swg22016181&myns=swgimgmt&mynp=OCSSEPGG&mync=E&cm_sp=swgimgmt-_-OCSSEPGG-_-E
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
Came across this recently looking for some certification help for a client. Here is the link:
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
Gunning Technology Solutions, LLC. THE WORLD LEADER IN Db2 LUW CONSULTING! 