IBM Db2 Analytics Accelerator (IDAA) v7 Announced #IBMz #zAnalytics

Posted by Frank Fillmore on October 17, 2017 under BLU Acceleration, DB2 for Linux Unix Windows, HTAP, IBM Pure Systems, IDAA, Mako, Netezza. Tags: , , , .

On July 23, 2010 I attended the announcement of the IBM Smart Analytics Optimizer (ISAO).  This was IBM’s first iteration of heterogeneous scale-out to enable mixed OLTP and OLAP workloads to run on the same platform.  Subsequently IBM acquired Netezza and the Netezza appliance became the foundation for the IBM Db2 Analytics Accelerator (IDAA).  In IDAA workshops I would refer to the ISAO as IDAA v0.5.

Fast forward to today when IBM announced IDAA v7.1.  “What is old is new again.”  Think of this delivery of IDAA as “ISAO v4.0” (there was some good-natured debate about the numbering).  Why do I frame it those terms?

  1. IDAA has received a “brain transplant”.  Instead of Postgres, the database engine for IDAA will be Db2 Warehouse.  This will give IDAA greater compatibility with Db2 for z/OS, including broader SQL and datatype support, TIMESTAMP consistency, and more.  By exploiting Db2 with BLU Acceleration features such as in-memory columnar (rather than row-organized) data, Single Instruction, Multiple Data (SIMD) chips, actionable compression, and “data skipping” (avoiding extents that don’t contain data of interest) IDAA v7.1 provides a robust platform for better performance with a roadmap for continuous improvement and enhancement.  IBM has also consolidated its data repository development efforts by focusing on fewer, higher-value initiatives.
  2. IDAA has received a “heart transplant”.  The IBM Integrated Analytics System (IIAS) appliance on which IDAA v7.1 is based, no longer depends on Field Programmable Gate Arrays (FPGA) that were the “secret sauce” of the Netezza (aka PureData System for Analytics – PDA).  FPGAs might be reintroduced at a later time.

So, a few questions – and a fewer answers.

  • How long will the legacy Netezza/PDA “Mako” N3001 be supported?  Until 2023.  So the installed base of existing IDAAs will be protected for five years.
  • Will the Database Partitioning Feature (DPF) – IBM’s MPP shared-nothing data warehouse scaling technology – be exploited by IDAA v7.1?  Dunno.
  • Wither the IDAA cloud deployment introduced in v6?  Nary a mention today.

Topics for a future blog post:

  • “True HTAP” – Hybrid Transaction / Analytic Processing
  • IDAA deployment on IBM z – using Docker images sitting on Integrated Facility for Linux (IFL) specialty processors.

Oracle Renewal Looming? Consider DB2! @IBMAnalytics

Posted by Frank Fillmore on May 16, 2017 under BLU Acceleration, DB2 for Linux Unix Windows, DB2 for z/Linux, IBM DB2 Services, Oracle, pureScale. Tags: , , .

Thanks to my colleague, Kim May, for another wonderful job leading customers and IBMers through the rewards and challenges of converting Oracle databases to DB2. The recording of the latest webinar is found here.  The presentation materials: Oracle Customers Consider DB2 5.16.17

Finally, The Fillmore Group’s White Paper on Oracle to DB2 migrations: SmarterQuestions White Paper – Oracle to DB2 Migration Lessons Learned – Final

Please reach out to Kim or me if you have any questions.

Another Oracle Attack Webinar? You Bet!

Posted by Kim May on May 2, 2017 under BLU Acceleration, DB2 Education, DB2 for Linux Unix Windows, DB2 Gold Consultants, Frank Fillmore, HTAP, IBM DB2 Services, IBM Mid Market Customers, Oracle, pureScale, TFG Blog.

With IBM’s announcement this week of super-aggressive discounting being offered to current Oracle customers considering a move to DB2, and with the deadline looming for many Oracle customers faced with another year of bloated “investment” in Oracle support, we’ve decided to deliver updated material on the benefits of moving to DB2.

Our upcoming webinar, “Oracle Renewal Looming?  Consider DB2!” will be delivered on Tuesday, May 16th, from 11:30am to 12:30pm EDT.

DB2 Gold Consultant Frank Fillmore will join me for the session, as will IBM’s Tony Mancini, Worldwide Competitive Team Executive.  Tony will give us a brief overview of IBM’s recent announcement, and Frank and I will deliver a fast-paced, interactive 60-minute session that will (we hope!) provide current Oracle customers with an understanding of both the cost savings and incredible database functionality available with DB2.

Please register HERE to join us!

Oracle Renewal Looming? Consider DB2! @IBMAnalytics

Posted by Frank Fillmore on April 6, 2017 under BLU Acceleration, DB2 for Linux Unix Windows, DB2 for z/Linux, DB2 Migrations, HTAP, IBM DB2 Services, MQT's, Oracle, pureScale. Tags: .

Thanks to Kim May for a fabulous job stepping customers and IBMers through the rewards and challenges of converting Oracle databases to DB2.  The recording of the webinar is found here.  The presentation materials: Oracle Customers Consider DB2 4.5.17

Finally, The Fillmore Group’s White Paper on Oracle to DB2 migrations: SmarterQuestions White Paper – Oracle to DB2 Migration Lessons Learned – Final

Please reach out to Kim or me if you have any questions.

Webinar: Oracle Renewal Looming? Consider DB2!

Posted by Kim May on March 13, 2017 under BLU Acceleration, DB2 for Linux Unix Windows, DB2 for z/Linux, DB2 Gold Consultants, DB2 Migrations, Frank Fillmore, HTAP, IBM Champion, IBM DB2 Services, IBM Information Management Software Sales, Oracle, pureScale, TFG Blog.

The Fillmore Group is inviting organizations frustrated with rising Oracle costs to join us for a webinar focusing on the two primary motivations behind DB2 migrations: cost and functionality. Session attendees will perform a self-analysis to compare similar version license costs, and gain an understanding of the technical features included in DB2 for on-premise use – BLU, pureScale, and the Data Partitioning Feature – as well as a brief overview of cloud deployment and SaaS options.

Date:   Thursday, April 6th

Time:  11:00am – 12:00pm EDT

The session also includes an overview of the migration process, as anyone considering a move needs to understand the time and effort involved.

Sound boring? It won’t be! The session will be delivered by IBM Champions Frank Fillmore and Kim May. Frank has participated in IBM’s annual “Break Free Forum” and Kim has worked with several Oracle customers exploring migrations to DB2. We understand this is a complicated comparison but will do our best to make the session entertaining without including too much Oracle bashing. But maybe a bit.

Registration is required to attend. Register HERE.

The Fillmore Group IBM Analytics Class Schedule – First Half, 2017

Posted by Kim May on December 1, 2016 under Arrow ECS, Authorized Training Partner, BLU Acceleration, DB2 Education, DB2 for Linux Unix Windows, DB2 for z/Linux, DB2 for z/OS, DB2 Gold Consultants, Global Skills Initiative, IBM DB2 Services, IBM Training Services Delivery Partner, Q-Replication, TFG Blog.

Although the Global Skills Initiative hasn’t delivered on its promise IBM continues to schedule and deliver classes with the Global Training Partners.  It’s just more difficult for customers to find classes and register…and then wait for the all-too-frequent “sorry, cancelled” call.

But, as we have been delivering IBM Authorized DB2 and data management tools classes for this long, we’re hanging in.  Why not?  Our classroom sits waiting for students and our consultants who train always look forward to delivering classes.

Our scheduled classes are in the document attached below.  These are the classes we are scheduled to deliver.  Please remember we have access to other courses and curriculum, and can deliver many more courses (along with our regularly scheduled classes) in private sessions at your location, and/or via distance learning.

Please call (443-956-0288) or email me (kim.may@thefillmoregroup.com) if I can help!

1h-2017-the-fillmore-group-classes

DB2 101 Event – 8 Seats Still Available!

Posted by Kim May on April 8, 2016 under Big Data, BLU Acceleration, DB2 Connect, DB2 Education, DB2 for Linux Unix Windows, DB2 for z/OS, DB2 Gold Consultants, Federation, Frank Fillmore, Hadoop, HTAP, IBM Champion, IBM DB2 Services, IBM Information Management Software Sales, IBM Mid Market Customers, IBM Pure Systems, IDAA, InfoSphere, Mako, Netezza, Optim, pureScale, Q-Replication, TFG Blog.

Frank and I attended an IBM Business Partner event in Philadelphia earlier this week where we met with several IBM’ers supporting Business Partner initiatives in 2016.  Each of the specialists presented their “best of” solutions to the partners in attendance, and then patiently answered our many questions (mostly mine – sorry team!)

The final preparations for our Woodberry Kitchen lunch event are underway:   Frank and I are polishing the presentation, IBM’s Andrew Levine and Warren Heising are tracking down answers to my Cloud deployment “what if?” questions, Megan is gathering gold coins for attendees who ask Frank good technical questions, and Jolanta at Woodberry Kitchen has me salivating with her menu recommendations.

If you will be in Baltimore April 21st and haven’t registered yet, please do!  Register HERE.

DB2 101 – IBM Data Management Portfolio 2016 – Woodberry Kitchen Luncheon

Posted by Kim May on March 10, 2016 under BLU Acceleration, DB2 Education, DB2 for Linux Unix Windows, DB2 for z/OS, DB2 Gold Consultants, DB2 Migrations, DB2 Stars, Frank Fillmore, HTAP, IBM Champion, IBM DB2 Services, IBM Information Management Software Sales, IBM Pure Systems, IDAA, InfoSphere, InfoSphere Streams, Mako, Netezza, Oracle, pureScale, Q-Replication, TFG Blog.

For Baltimore and Mid-Atlantic area data management customers, The Fillmore Group is excited to announce a “DB2 101” luncheon event at award-winning Woodberry Kitchen in Baltimore on Thursday, April 21, 2016, from 11am – 2pm.

Join DB2 Gold Consultant Frank C. Fillmore, Jr., for a delicious lunch and a sprint through the IBM Analytics 2016 data management solutions portfolio.   Whether you are a long-time IBM customer or are considering your first IBM product purchase, Frank’s presentation will deliver the latest on today’s hottest technology topics – HTAP, Big Data/Hadoop and Cloud – and the specific solutions IBM has built, acquired and integrated to enable customers to meet their data management goals.

Is this, “the more things change the more they stay the same”, or an inflection point for data technology? You be the judge!

Frank’s overview will include IBM’s DB2 core databases, InfoSphere data integration solutions, Hybrid Transaction / Analytics Processing (HTAP), Big Data/Hadoop and Cloud offerings, as well as his 2016 best product recommendations and resources to help you learn more and evaluate these solutions.

Lunch and valet parking will be provided free of charge by The Fillmore Group.  Registration is required as seating is limited.  Register HERE.

If you have any questions or dietary restrictions please contact Kim May at kim.may@thefillmoregroup.com.  I hope we will see you at Woodberry!

DB2 101 Woodverry Kitchen 003

 

April Events – “DB2 101” Luncheon and Free Hands-on IDAA Class

Posted by Kim May on March 7, 2016 under Authorized Training Partner, BigInsights, BLU Acceleration, DB2 Education, DB2 for Linux Unix Windows, DB2 for z/OS, DB2 Gold Consultants, Frank Fillmore, HTAP, IBM Champion, IBM Information Management Software Sales, IDAA, Mako, pureScale, Q-Replication, TFG Blog.

I am excited to announce two upcoming events The Fillmore Group will deliver in April.  Stay tuned for dates and locations!

Woodberry “DB2 101” Luncheon

Join DB2 Gold Consultant Frank C. Fillmore, Jr., for a sprint through IBM Analytics’ 2016 data management solutions portfolio. From today’s hottest topics – HTAP, Hadoop and Cloud – to the specific IBM solutions behind the buzzwords, Frank will deliver an overview of how IBM has built, acquired and integrated data management solutions to enable customers to accomplish their organization’s goals. Is this, “the more things change the more they stay the same”, or an inflection point for data technology? You be the judge!

Free Hands-on IBM DB2 Analytics Accelerator (IDAA) April Class

IBM’s 2012 announcement of the IBM DB2 Analytics Accelerator – the IDAA – the Netezza/mainframe hybrid, delivered IBM’s first Hybrid Transaction/Analytics Processing (HTAP) solution. Now, after 3 years and multiple enhancements, the IDAA continues to promise great things for IBM DB2, VSAM and IMS customers. According to our calculations, 90% of IBM System z customers don’t own an IDAA yet – and we think everyone should have one! Join us for this free, 2-day, hands-on, technical introduction to learn how an IDAA can benefit your System z shop.

 

 

IDUG, DB2-L and Charming Developers

Posted by Kim May on February 29, 2016 under BLU Acceleration, DB2 for z/OS, HTAP, IBM DB2 Services, IDAA, Oracle, TFG Blog.

There was some discussion on DB2-L this past week, not about “charming developers” (as in, “gee, that developer sure is charming!”), but about how the DB2 community can encourage developers to use the IDUG listserv as a resource for application coding questions.  Because, there are many extraordinary technical people monitoring the list.  And yes, many can also be quite charming to new listserv users!

Right now I see the division between DB2 users and their organizational colleagues growing as System z workloads are being restricted by cost and security concerns.  Quite frequently there appears to be very little communication between DBA’s and developers within organizations.  With larger organizations bringing teams of data scientists on board, many of whom are unfamiliar with the mainframe, the divide further broadens, as the data scientists view developers as their allies.

With the introduction of Hybrid Transaction/Analytical Processing (HTAP), the ability to run OLTP and Analytics together should be bringing data warehouse applications back to the mainframe.  The new data scientists, and their application developer colleagues, will need their DBA colleagues to help.  I hope DB2-L is one of the resources that makes the transition for everyone easier.