DB2

New low cost offerings recently announced (which apply to FP5) around BLU, encryption, performance and pureScale.

Native compression is a game changer, cannot wait to get my hands on it.

I'm excited about additional platform support - BLU on Windows and zLinux. Woohoo!

Business Application Continuity offering allows 2 member pureScale cluster on top of DB2 WSE and ESE licensing. As pureScale guy, I love this. :)

and platform support for BLU Acceleration on Windows & zLinux.

Little feature I love in FP5: longer usernames are now supported on Linux/UNIX!

Native encryption with full application transparency makes it a breeze to safeguard your data.

BLU Acceleration is now available to many more organizations with the new support for Windows and zLinux.

For pureScale in general, FP5 also includes automatic CF memory management (think STMM for the CFs). Lower mgmt. costs.

@LynnCChou BLU on Windows and zLinux is the little announcement that is huge! Supports workgroups of all sizes, not to mention data mart consolidation to the mainframe!

Add-ons in BLU Acceleraiton, Business Applcation Continuity, Encryption, Performance Mgt

Exited about BLU on Windows and the Business Application Continuity Offering

More flexible packaging to make the advanced features of DB2 more accessible and affordable.

Native encryption on DB2 database server. Requires no app or schema changes. Transparent, secure key mgmt based on PKCS#12.

@ember_crooks Do you mean native encryption instead of compression? I presume so :)

We have customers on both Windows and z/Linux. Cannot wait to tell them about how game changing BLU Acceleration is!

Column-organized tables enhancements. High-available disaster recovery. PureScale enhancements.

Yes, fingers getting ahead of brain. Native encryption. Compression is cool too, just not new.

Application interface enhancements: CLI drivers, .NET data server provider

@ibm_db2 Interested in learning more about the details of BAC

Hi Philip. Blogged about it here. Reach out to me for more info. https://ibm.biz/BdEC...

@KSchlamb will do

When you need analytics at the speed of thought -- much more interactive than reports!

Cognos BI queries greatly sped up by BLU. Dynamic cube loading faster, and drill downs into the database faster.

* A subset of tables are frequently accessed in analytic queries,
you might want to create these tables as column-organized tables.

A credit card processing company in Europe discovered major patterns of fraud hours into the Proof of Concept for BLU Acceleration. Talk about fast ROI.

I'm just loosing my BLU-virginity, and learning so much, and blogging. Ask me again in 6 months.

Offload analytic data marts from poorly performing warehouses

Get snapshots of operational report rather than waiting till end of the day.

Create data marts directly off of the transactional database

@ibm_db2 I see a move from DPF to BLU

Major Swedish bank speeds up regulatory reporting. Saw 100x speed-up for some queries, 82% compression. http://www.ibmbluhub...

@ibm_db2 @GuyLohman1 Speed of thought says it all.....

No Admin headaches in creating and maintaining your warehouse. Jut load and go! No tuning, no performance enhancing objects, like indexes and MQTs.

Big data use cases: Extreme compression addresses Big Data issue of size. Massive storage (read I/O) savings

Fast reporting Addresses Big Data issue of response times. Query response times much, much faster

Complex queries for reporting, Business Intelligence, predictive analytics, data mining. This is where BLU shines, and provides 35-75X speedup with very minimal cost. Some queries speed up more than 1000X with no additional hardware.

Simplicity and Seamless Integration ddresses Big Data issue of development time

The load-and-go simplicity of BLU really democratizes the technology. You don;t need to be a database guru. BLU automatically self-configures to any server size.

Big Data, with SQL, and in-memory speeds. Faster than RAM! http://softwaretrade...

@samlightstone blog "Faster than RAM" has become a classic in the way of #DB2 blogs.

Instant insight on both real time and operational data now possible with BLU shadow tables.

Get instant answers with BLU Acceleration directly in your transactional environment with BLU Shadow Tables. Simplify landscape with reporting and transactions in the same system.

One sentence - Shadow tables bring analytics to data - allows for OLTAP on a single system!

Indexes originally created to speed up reporting can be removed, which often times speeds up the transactional work and saves space.

@amit505 This is a great feature for the "need analytics NOW" crowd in your org -- even on transactional data.

I lied! No more reporting headaches with shadow tables

When row-organized tables are joined to column-organized tables, the BLU engine is not used. Shadow tables seem complicated, but may address the problems that causes.

@iqbalgoralwalla Iqbal, you did a webinar about BLU Shadow Tables recently! Do you have a link?

Achieve significant performance for reports currently running on your OLTP system using Shadow tables

Shadow Tables bring BLU to OLTP (transactional) systems. Customers generally see speedup on BOTH the transactions and the reporting. A large number of secondary indexes are usually no longer needed, so INSERT, UPDATE and DELETE are much faster for OLTP.

Improve OLTP performance by remove indexes previously used for reporting

Shadow Tables mean faster OLTP, much faster reporting, less storage required, on a single system.

Simplify infrastructure by moving reports running on another system to your OLTP system

http://www.dbisoftwa...

Maintains in-memory columnar "shadows" of row-based operational-data tables.

Creation and refreshing of the shadows is through automatic, incremental synchronization of the corresponding row-oriented DB2 tables.

@IBM_DB2Enables DBAs to boost query speeds automatically without having to manually create, manage and tune complicated indexes.

Automatically routes analytic queries to the appropriate shadow tables, which leverage IBM's BLU in-memory technology.

Not only does this enable faster analytics against DB2, it also ensures continued high throughput on row-based OLTP applications and much less manual administration.

Here's real customer feedback: "The results are delighting my end users and we don't see any impact to our transactional performance.” – Paul Peters, Lead Database Administrator, VSN Systemen"