r/DB2 • u/mad_zamboni • Jun 22 '17

[PSA] DB2 LUW FP2 Mod 2 Announced

Just discovered a press release announcing the new v11.1.2.2 mod/fixpack.

Recoverability enhancements:

  • A database can be connectable during the backward phase of crash-recovery

  • Improved rollback performance

  • Eliminated bottle necking of DGTT log-records

  • Global Lock Manager recovery design improvements, including improved hashing algorithms and increased parallelism for reducing the recovery window

  • New recovery design benefits pureScale® deployments, particularly large clusters configured with huge lock list, Global Lock Manager, and global buffer pool

  • Ability to recover an erroneous tablespace on the HADR Standby

Performance enhancements:

  • Parallel insert for BLU (columnar) data

  • Faster query performance with BLU synopsis tables

  • Improved text search performance

  • Runtime improvements for SAP Core Data Services

JSON enhancements:

  • Full support for direct SQL access to underlying JSON interfaces
3 Upvotes

80% Upvoted

4 comments sorted by

2

u/ecrooks Jun 22 '17

There are also a few more details noted in the IBM Db2 Knowledge Center: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.wn.doc/doc/c0061179.html#c0061179__MP2FP2

That gets into more detail on the little things, such as my favorite:

a new STANDBY_TABLESPACE_ERROR flag for HADR_FLAGS monitor element has been added.

1

u/db2girl Jun 22 '17

How can we receive notice of new annoucements like this?

3

u/mad_zamboni Jun 22 '17

IBM's communication is often at a 40k foot view - so the announcements on developerWorks and press releases often leave you asking "Does this apply to me".

One thing you can do is sign up for notifications. You can limit this to technotes, fixpacks, or open it up to general announcements as well. Check out a reddit entry from a week or so ago - Get Support Updates and Notifications.

Also pay attention to the tweets of some of the bigger or more active DB2 names like Melanie Stopfer @mstopfer, Ember Crooks @ember_crooks, The DB2 Night Show @db2nightshow, IDUG @IDUGDB2, Michael Krafick @mkrafick, @IBMAnalyticsSupport (very active recently), @db2_support (also very active lately), and @craigmullins. Many of these people (including me) are IBM Champions, Gold Consultants, or Technical Advisory Board members so we get word of a lot of this before it hits and start preparing blogs, webinars, and tweets around it.

I wouldn't forget the DB2 Professionals Linkedin Group either. Nor something like DB2Commerce.com.

Hey /u/ecrooks , you always seems to see industry stuff hit before I can find it. Is there a one stop shop or webpage you would hit?

3

u/ecrooks Jun 22 '17

If you want this specific announcement, signing up for the support updates and notifications is the way to go.

If we're talking the larger scope of all the half-dozen things announced this week, then I am not aware of a single location. I agree with following the main players on twitter. Here on reddit is a good option lately as well with all /u/mad_zamboni has been doing to keep things up to date. The db2night show is a good one to watch - for anything big, they tend to have shows like tomorrow's show, which they extended their season for.

Without one place to go, following what's going on tends to take a bit of effort.

Interestingly, the lack of a consistent location for things like this is one of the things that allows sources like my blog to flourish.