Skip to content

Join us at IDUG North America, 2016!

We will be exhibiting at IDUG NA 2016 in Austin, May 23-26, 2016 at the Austin Renaissance Hotel. http://www.idug.org/p/cm/ld/fid=795   . See us at Booth 507 and stop by and pickup a highly sought after Gunning Technology Solutions, LLC keychain light combo. Also we will be raffling off a GoPro Hero with starter pack as part of the Passport to Prizes program. As of today, Phil will be presenting, “Secure your Data with DB2 Native Encryption and SSL”, 1 pm on Wed, May 25, 2016. He will also be available in the booth to answer your DB2 questions. Stop by you will be glad you did.

http://www.idug.org/p/cm/ld/fid=947

See the latest IBM DB2 11 Tech Review

Take a look at this technical review of some key features of DB2 11.1 for Linux, UNIX and Windows by IBM Distinguished Engineer. Many improvements have been made to DB2 pureScale in the deployment area and support has been added to DB2 Native Encryption of a centralized key manager…. See it here…..http://www.ibmbigdatahub.com/blog/new-ibm-db2-release-simplifies-deployment-and-key-management

 

DB2 Techtalk on DB2 11 for LUW

You still have time to register for this DB2 Techtalk. Hear from the key Distinguished Engineers, DB2 Leaders and Developers from the IBM Toronto Lab. April 28, 12:30 EDT.

https://twitter.com/IBM_DB2/status/724973847405973504

DB2 9.7, 10.1 End of Support (EOS) Dates Published!

Many, many companies are running DB2 9.7 at various fixpack levels since it has been such a reliable and good performing release. However, many new capabilities are available in the new DB2 11.1 for Linux, Unix and Windows. DB2 10.1 also has an EOS of September 30, 2017. Start planning your migrations now. Here’s the link to the EOS dates:  http://www-01.ibm.com/support/docview.wss?uid=swg21168270

DB2 11.1 with BLU Accleration Announced!

A few days ago the long awaited, much anticipated next version of DB2 LUW, DB2 11.1 was announced. DB2 11.1 offers all kinds of opportunities for Cloud deployment and development. Also, end of support dates have been announced for DB2 9.7 and DB2 10.1. I’ll post a separate entry for that. Read and download the announcement here: http://www-01.ibm.com/common/ssi/cgi-bin/ssialias?infotype=AN&subtype=CA&htmlfid=897/ENUS216-141&appname=USN

DB2 Native Encryption — Get Going!

Running DB2 10.5 FP5? I’ve talked about this before, get going on DB2 Native Encryption. A quick and easy description and steps to follow are in these tips provided by Walid Rjaibi, IBM Chief Security Architect. https://www.ibm.com/developerworks/community/blogs/5things/entry/5_things_to_know_about_db2_native_encryption?lang=en

What Filesystems does DB2 LUW Support?

This question often comes up with clients moving to DB2 on Linux. Book mark this link and keep it handy so you will have a quick reference from IBM. Note that XFS filesystems are supported. http://tinyurl.com/ztppob9

 

 

DB2 LUW Generated Columns and Expression-Based Indexes

Prior to DB2 10.5, Expressed-based indexes were not available on DB2 LUW. But generated-columns have been around for a long time. With DB2 below version 10.5 you would need to create a generated-column and then an index on that column so the DB2 optimizer would use it. I’ve gotten huge performance improvements with generated-columns in the past, I mean order of magnitude type improvements. Well with 10.5 and above DB2 supports Expression-based indexes where you define the expression in the CREATE INDEX clause. So, going forward you will probably want to use the Expressed-based index feature instead of generated-columns. For the full benefits take a look at the DB2 Information Center:  https://www.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.ibm.db2.luw.admin.dbobj.doc/doc/c0061101.html

 

SOA, Microservices or APIs?

This is a good Developer Works article on SOA, Microservices and APIs. Whereas SOA was pretty good in the past, the article highlights how APIs are easier to code and manage. Make that System of Record DB2 LUW……

http://www.ibm.com/developerworks/websphere/library/techarticles/1601_clark-trs/1601_clark.html

IBM Champion for Analytics

Thrilled to have been named an IBM Champion for Analytics for the 8th time. This program honors DB2 Experts that have deep experience with DB2 Analytics. Thanks IBM. #ibm #DB2 #ibmblu #IBMBIGINSIGHTS

https://www.ibm.com/developerworks/champion/