DB2

IBM DB2
http://www.via-cc.at... Question 1: FP5 was just released and included new features. Could you tell us more about this?

Kelly Schlamb
New low cost offerings recently announced (which apply to FP5) around BLU, encryption, performance and pureScale.
ember_crooks
Native compression is a game changer, cannot wait to get my hands on it.
jrockwood
I'm excited about additional platform support - BLU on Windows and zLinux. Woohoo!
Kelly Schlamb
Business Application Continuity offering allows 2 member pureScale cluster on top of DB2 WSE and ESE licensing. As pureScale guy, I love this. :)
Lynn C. Chou
and platform support for BLU Acceleration on Windows & zLinux.
ember_crooks
Little feature I love in FP5: longer usernames are now supported on Linux/UNIX!
Amit Patel
Native encryption with full application transparency makes it a breeze to safeguard your data.
Amit Patel
BLU Acceleration is now available to many more organizations with the new support for Windows and zLinux.
Kelly Schlamb
For pureScale in general, FP5 also includes automatic CF memory management (think STMM for the CFs). Lower mgmt. costs.
Data Warehouse News
@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!
jameskobielus
Add-ons in BLU Acceleraiton, Business Applcation Continuity, Encryption, Performance Mgt
Philip Gunning
Exited about BLU on Windows and the Business Application Continuity Offering
Amit Patel
More flexible packaging to make the advanced features of DB2 more accessible and affordable.
jameskobielus
Native encryption on DB2 database server. Requires no app or schema changes. Transparent, secure key mgmt based on PKCS#12.
IBM DB2
@ember_crooks Do you mean native encryption instead of compression? I presume so :)
Iqbal Goralwalla
We have customers on both Windows and z/Linux. Cannot wait to tell them about how game changing BLU Acceleration is!
jameskobielus
Column-organized tables enhancements. High-available disaster recovery. PureScale enhancements.
ember_crooks
Yes, fingers getting ahead of brain. Native encryption. Compression is cool too, just not new.
jameskobielus
Application interface enhancements: CLI drivers, .NET data server provider
Philip Gunning
@ibm_db2 Interested in learning more about the details of BAC
Kelly Schlamb
Hi Philip. Blogged about it here. Reach out to me for more info. https://ibm.biz/BdEC...
IBM DB2
http://www.via-cc.at... Question 9: What are some of the best use cases you have seen for DB2 with BLU Acceleration?

Guy Lohman
When you need analytics at the speed of thought -- much more interactive than reports!
Kelly Schlamb
Cognos BI queries greatly sped up by BLU. Dynamic cube loading faster, and drill downs into the database faster.
Iqbal Goralwalla
* A subset of tables are frequently accessed in analytic queries,
you might want to create these tables as column-organized tables.
Amit Patel
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.
ember_crooks
I'm just loosing my BLU-virginity, and learning so much, and blogging. Ask me again in 6 months.
Iqbal Goralwalla
Offload analytic data marts from poorly performing warehouses
Lynn C. Chou
Get snapshots of operational report rather than waiting till end of the day.
Iqbal Goralwalla
Create data marts directly off of the transactional database
Philip Gunning
@ibm_db2 I see a move from DPF to BLU
Kelly Schlamb
Major Swedish bank speeds up regulatory reporting. Saw 100x speed-up for some queries, 82% compression. http://www.ibmbluhub...
Philip Gunning
@ibm_db2 @GuyLohman1 Speed of thought says it all.....
Iqbal Goralwalla
No Admin headaches in creating and maintaining your warehouse. Jut load and go! No tuning, no performance enhancing objects, like indexes and MQTs.
Iqbal Goralwalla
Big data use cases: Extreme compression addresses Big Data issue of size. Massive storage (read I/O) savings
Iqbal Goralwalla
Fast reporting Addresses Big Data issue of response times. Query response times much, much faster
Sam Lightstone
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.
Iqbal Goralwalla
Simplicity and Seamless Integration ddresses Big Data issue of development time
Sam Lightstone
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.
Sam Lightstone
Big Data, with SQL, and in-memory speeds. Faster than RAM! http://softwaretrade...
Data Warehouse News
@samlightstone blog "Faster than RAM" has become a classic in the way of #DB2 blogs.
IBM DB2
http://www.via-cc.at... Question 3: What benefits will I see if I use BLU Shadow Tables?

Amit Patel
Instant insight on both real time and operational data now possible with BLU shadow tables.
Amit Patel
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.
Iqbal Goralwalla
One sentence - Shadow tables bring analytics to data - allows for OLTAP on a single system!
Kelly Schlamb
Indexes originally created to speed up reporting can be removed, which often times speeds up the transactional work and saves space.
Data Warehouse News
@amit505 This is a great feature for the "need analytics NOW" crowd in your org -- even on transactional data.
Iqbal Goralwalla
I lied! No more reporting headaches with shadow tables
ember_crooks
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.
IBM DB2
@iqbalgoralwalla Iqbal, you did a webinar about BLU Shadow Tables recently! Do you have a link?
Iqbal Goralwalla
Achieve significant performance for reports currently running on your OLTP system using Shadow tables
Sam Lightstone
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.
Iqbal Goralwalla
Improve OLTP performance by remove indexes previously used for reporting
Sam Lightstone
Shadow Tables mean faster OLTP, much faster reporting, less storage required, on a single system.
Iqbal Goralwalla
Simplify infrastructure by moving reports running on another system to your OLTP system
jameskobielus
Maintains in-memory columnar "shadows" of row-based operational-data tables.
jameskobielus
Creation and refreshing of the shadows is through automatic, incremental synchronization of the corresponding row-oriented DB2 tables.
jameskobielus
@IBM_DB2Enables DBAs to boost query speeds automatically without having to manually create, manage and tune complicated indexes.
jameskobielus
Automatically routes analytic queries to the appropriate shadow tables, which leverage IBM's BLU in-memory technology.
jameskobielus
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.
Sam Lightstone
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"