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.

DB2 101 Event – 8 Seats Still Available!

Posted by Frank Fillmore 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 Frank Fillmore 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

 

Countdown to: “IBM Data Retrieval Technologies : RDBMS, BLU, IBM Netezza and Hadoop” #IDUG Europe

Posted by Frank Fillmore on November 11, 2014 under Big Data, BLU Acceleration, DB2 for Linux Unix Windows, DB2 for z/OS, DB2 Gold Consultants, Frank Fillmore, Hadoop, IBM Champion, IBM Pure Systems, International DB2 Users Group (IDUG), Netezza.

Frank is doing his final preparation for today’s presentation at IDUG Europe – if you are lucky enough to be in beautiful Prague at the conference I hope you will stop by!

Session E7 on Tuesday, November 11 from 3:15 to 4:15 p.m.

Abstract:  IBM offers four distinct data retrieval technologies: the traditional RDBMS, which primarily relies on indexes to speed access; the new BLU Acceleration columnar compression database; IBM PureData System for Analytics (IBM Netezza), which deploys racks of Field Programmable Gate Array (FPGA) processors to parse the data; and IBM InfoSphere BigInsights, which is the IBM distribution of Hadoop. Choices are good to have, but how do you choose which technology to apply to a particular business use case? In this session, you learn how these techniques differ, including their relative strengths and weaknesses, to help you make an informed choice.

 

Services – Available Help for the “tions”

Posted by Frank Fillmore on May 30, 2014 under Authorized Training Partner, Big Data, Data Studio, DB2 Connect, DB2 Education, DB2 for i, DB2 for Linux Unix Windows, DB2 for VSE&VM, DB2 for z/OS, DB2 Gold Consultants, DB2 Migrations, Federation, Frank Fillmore, Hadoop, IBM Champion, IBM DB2 Services, IBM Pure Systems, IDAA, InfoSphere, InfoSphere Streams, MQT's, Netezza, Optim, Oracle, pureScale, Q-Replication, SQL Tuning, TFG Blog. Tags: , , , , , , , , , , , , , , , , , .

I was on a call this morning with an IBM technical team to discuss our progress filling the seats in one of our upcoming free IDAA classes.  Not surprising, given the number of people on the call (and who they were!) we went a bit off topic and ended up chatting about services and what appears to be – to IBM customers and sellers at least – a shortage of skilled consultants available to help with the “tions” – replication, implementations, migrations and federation.

The Fillmore Group has skilled consultants available to support these efforts, at rates that are typically about half of those being charged by “the competition”.

If your team has a project pending, or one in process, where a skilled consultant, at a reasonable hourly rate, can get things back on track, please contact me.  We are ready to work!  A list of our IBM Information Management capabilities is attached here.

 

Frank’s IOD Presentation Scheduled

Posted by Frank Fillmore on August 26, 2013 under Big Data, BigInsights, BLU Acceleration, DB2 Education, DB2 for Linux Unix Windows, DB2 for z/OS, DB2 Gold Consultants, Frank Fillmore, Hadoop, IBM Champion, IBM DB2 Services, IBM Pure Systems, IDAA, Netezza, TFG Blog. Tags: , , , , , .

For those of you planning to attend this year’s Information on Demand (IOD) conference in Las Vegas, starting November 3rd, please join us for Frank Fillmore’s session, IPT-2150-B, “IBM Data Retrieval Technologies: RDBMS, BLU, IBM Netezza, and Hadoop“.  The session is scheduled for Tuesday, November 5th, from 1:45-2:45pm.

The session abstract is below.  In the session Frank will share his experience with IBM’s solutions to help determine which is best to meet your organization’s unique needs.

Abstract:  IBM offers four distinct data retrieval technologies: the traditional RDBMS, which primarily relies on indexes to speed access; the new BLU Acceleration columnar compression database; IBM PureData System for Analytics (IBM Netezza), which deploys racks of Field Programmable Gate Array (FPGA) processors to parse the data; and IBM InfoSphere BigInsights, which is the IBM distribution of Hadoop. Choices are good to have, but how do you choose which technology to apply to a particular business use case? In this session, you learn how these techniques differ, including their relative strengths and weaknesses, to help you make an informed choice.

Break Free from Oracle Webinar

Posted by Frank Fillmore on June 21, 2013 under BLU Acceleration, DB2 Education, DB2 for Linux Unix Windows, DB2 Gold Consultants, DB2 Migrations, Frank Fillmore, IBM Champion, IBM DB2 Services, IBM Information Management Software Sales, IBM Pure Systems, Oracle, pureScale, TFG Blog. Tags: , , , , .

The Fillmore Group will deliver a free webinar Wednesday, June 26th, from 11am-noon EDT on the value of migrating from Oracle to DB2.  We have been assisting customers with Oracle to DB2 migrations for the past few years and believe that with the recent DB2 BLU enhancements and IULA announcement the time is right to break free!

Register Here.

What’s an IULA?  It’s the IBM Unlimited License Agreement, a new way to license DB2 use that provides a low cost entry point to purchase DB2, and allows customers to predict and control their ongoing maintenance and support costs.  

As long-time believers in the superiority of IBM’s database technology, we also want to spread the word about the technical enhancements announced for the new IBM BLU Acceleration.  With beta customers reporting 90%-95% compression and amazing performance improvements, the DB2 vs. Oracle performance comparison is a great story to tell.

Most importantly, however, is helping current and prospective IBM customers understand where IBM’s efforts to compete directly with Oracle will deliver the most benefit to their organizations.  Whether it’s cost, performance, or simplifying their in-house database environment, we want to help each one understand why and how IBM has the lead.

I hope you will join us!

Central Ohio DB2 Users Group (CODUG) Inaugural Meeting on June 25th – Join Us!

Posted by Frank Fillmore on June 13, 2013 under Big Data, BigInsights, BLU Acceleration, DB2 Education, DB2 for Linux Unix Windows, DB2 for z/OS, DB2 Gold Consultants, Frank Fillmore, Hadoop, IBM Champion, IBM Pure Systems, IDAA, InfoSphere, InfoSphere Streams, International DB2 Users Group (IDUG), Netezza, Optim, Oracle, Q-Replication. Tags: .

From my colleague, Jim Herrmann:

The Central Ohio DB2 Users Group (CODUG) no longer exists, but we are taking action to bring it back as a tremendous resource for the community and an amazing opportunity for leadership. CODUG is going to be a great DB2 regional users group because the members of the central Ohio DB2 community are going to make it so.

We are going to start out with all of you being a valuable contribution to your community by completing the RSVP for the June 25th, where you will have the ability to choose the presentations that you want to see from our amazing speakers. Use the URL below:

http://goo.gl/mpWT0

The short URL above links to a Google Docs form, which some company firewalls block, in which case you will need to make the extra effort of forwarding and filling out the form from home. Your input is essential to the success of the group. Whether you are planning to come on 6/25 or not, please fill out the form with your information and your vote. It’s free and it puts you in direct communication with the new CODUG!

You would be a further contribution to your friends and coworkers who have built their careers around DB2, on any platform, if you forward this message to them to make certain that they know about this amazing kickoff meeting. Don’t worry about them getting multiple copies, worry about them getting none. Forward this message now, while you’re thinking about it. If you wait, you will forget to do it later, and you will have missed the chance to connect someone to their community.

The meeting will be formatted with a single track in the morning and two tracks in the afternoon, one for DB2 z/OS and one for DB2 LUW. We will actually physically split the room at the lunch break. We have three well known names in the world of DB2 who will be presenting at the meeting. The bios of these three awesome individuals you can find after the attached agenda.

We are building towards an amazing day. Fill out the form, share it, and we will be one step closer to creating something powerful in our lives.

Thank you for your time and your commitment to DB2,
Please don’t forget to join us at Facebook and Linkedin to get to know about future activities at CODUG.
Linkedin group:  http://www.linkedin.com/groups/CODUG-Central-Ohio-DB2-Users-5014603/about
Facebook page: https://www.facebook.com/CODUG
Agenda

09:00 – 09:30    CODUG Possibility (Jim Herrmann)
09:30 – 10:00    IBM Announcements (Monte Bauman)
10:00 – 10:15    Break
10:15 – 11:30    “DB2 101” or “I didn’t know IBM Information Management could do that!” (Frank Fillmore)
11:30 – 12:45    Lunch
12:45 – 14:15    First afternoon presentation block (Scott Hayes and Robert Catterall)
14:15 – 14:30    Break
14:30 – 16:00    Second afternoon presentation block (Scott Hayes and Robert Catterall)

Frank C. Fillmore, Jr., DB2 Gold Consultant and IBM Champion, is the Founder and President of The Fillmore Group, Inc., a Premier IBM Business Partner that specializes in Information Management (IM) software sales, consulting, and training.  Frank has appeared on the IDUG Experts Panel and frequently presents to customers and local DB2 users groups.  Franks 25 years of field experience spans IBMs Information Integration, Data Governance, Data Warehousing, and Big Data portfolios. Read More…

Can the Data Warehouse and #BigData Coexist?

Posted by Frank Fillmore on May 6, 2013 under Big Data, BigInsights, Hadoop, IBM Champion, IBM Pure Systems, InfoSphere Streams. Tags: , , , .

I had the opportunity to chat with Jeff Kelly, Big Data Analyst, at Wikibon.  You can about our discussion on the Silicon Angle blog or view the interview here.

Webinar Thursday: IBM Big Data Announcements – What You Should Know

Posted by Frank Fillmore on May 6, 2013 under Baltimore Washington DB2 Users Group, Big Data, BigInsights, BLU Acceleration, DB2 Education, DB2 for Linux Unix Windows, DB2 Migrations, Hadoop, IBM Champion, IBM DB2 Services, IBM Information Management Software Sales, IBM Pure Systems, Informix, InfoSphere Streams, Netezza, pureScale, TFG Blog. Tags: .

On April 30th IBM announced several significant solution enhancements related to data management and big data.  These announcements reflect IBM’s commitment to leading the next generation of data solutions through improved functionality in their core database and data warehouse solutions, as well as expanding the capabilities of their solutions built to exploit big data, BigInsights and InfoSphere Streams.  For DB2 database customers IBM announced BLU Acceleration, delivering 8 to 25 times faster reporting and analytics on DB2, along with significant compression and space savings.  For customers considering IBM’s Big Data solutions, IBM announced BigSQL, its ANSI SQL interface that makes BigInsights analysis accessible to business users, not just data scientists.    And for organizations looking to simplify administration, a new appliance, the IBM PureData System for Hadoop was announced.

Join us Thursday, May 9th from 11am-12pm Eastern for an overview of the announcement and learn how your organization can benefit from IBM’s continued investment in data management.  Register here.

Presenter:
Warren Heising, Certified Consulting IT Specialist IBM
Warren is a Certified Consulting IT Specialist for IBM working in the Mid-Atlantic region.  He has over 25 years experience in the database field including 9 years at Informix prior to the IBM acquisition. He has a strong background in both OLTP and DSS Informix products and has worked with numerous clients in both Commercial and Federal accounts. Currently, he supports the full family of IBM Informix products along with DB2 and big data products for the Mid-Atlantic region and is actively involved in Proof of Technology and Proof of Concept scheduling and delivery.