IBM Db2 Analytics Accelerator (IDAA) v7 Workshop a Success! #IBMz #IBMAnalytics

Posted by Frank Fillmore on July 29, 2018 under BLU Acceleration, Data Studio, DB2 Education, DB2 for Linux Unix Windows, DB2 for z/OS, DB2 Migrations, HTAP, IBM Smart Analytics System, IDAA, Mako, Netezza, PostgreSQL, Sidecar. Tags: , , .

On July 23 and 24, 2018 The Fillmore Group delivered a hands-on IBM Db2 Analytics Accelerator (IDAA) v7 Workshop to 12 students across 5 different enterprises at the IBM Dublin, Ohio (USA) Technical Education Center.  This was the first IDAA v7 hands-on Workshop delivered to customers anywhere.  Many thanks to Atlee, Bill, Bob, Dom, Emmi, Larry, Marshall, Mohammed, Naga, Ruth, Shawn, and Toby for all of the great questions.  Kudos to the IBM Poughkeepsie Benchmark Center for standing up the IDAA v7 environment in record time with just-released functionality like Incremental Update.  And thanks to IBMers Rich Gast, Mike Hood, Sandro Ramirez (aka “Nicky’s Dad”), Julie Efthymiou, and Rudy Benvenuto for all of their support.

Finally – and most importantly – the Workshop’s flawless execution from scheduling, invitations and outreach to customers, to welcome packets for travelers, to food service, and overall logistics was the direct result of many months of hard work on the part of my colleague, Kim May.  I really appreciate it!

The presentation materials are here:IDAA Workshop 2018-07

Since IDAA v7 is so radically different from it’s predecessors, the Workshop generated lots of questions which will be incorporated into future sessions.  Watch this space.

2018 Events – So Much To Do!

Posted by Kim May on January 22, 2018 under Baltimore Washington DB2 Users Group, BLU Acceleration, DB2 Education, DB2 for Linux Unix Windows, DB2 for z/Linux, DB2 for z/OS, DB2 Stars, Frank Fillmore, IBM Champion, IBM Mid Market Customers, IBM Think Conference, IDAA, TFG Blog.

With IBM’s consolidation of conferences resulting in the cancellation of last Fall’s World of Watson/Insight/IOD Conference, and the merge into March’s upcoming Think conference, Db2 users have several educational event options to consider.  With training and education budgets continuing to shrink, and the use of contractors (who need to be billable, and know everything already, right?) growing, getting funding and approval to attend events is more challenging than ever.

However, with so many choices, I hope you will find something that’s a good fit, and have the opportunity to network with the Db2 community.   Here’s a short list of the events I am hoping to attend – and why:

Hands-on IDAA/IIAS Training, Date TBD (February or March), Baltimore, Maryland

Frank Fillmore is developing a new 2-day hands-on training class to introduce the IBM Db2 Analytics Accelerator (IDAA) and it’s new version, the IBM Integrated Analytics System (IIAS), featuring BLU Acceleration and available as an appliance or a z/Linux software solution.  Class will focus on use case development, determining the right fit deployment option for your organization, implementation and administration.  Frank has been delivering similar classes since the release of the IDAA and has helped many System z customers understand the accelerator value.

Why attend?  The IDAA/IIAS solution is an incredible addition to the System z environment, Frank is an excellent presenter, and class is *FREE*

To register:  keep an eye on our blog or email me if you would like me to notify you when class is scheduled.

 

Baltimore/Washington Db2 Users Group Education Session with Themis, Wednesday, March 14th, BWI Hilton, Linthicum Heights, MD

Every March the Baltimore/Washington Db2 Users Group offers a full-day education session.  These sessions are evaluated by our board and intended to provide the best local full-day of training available in the area each year.  The March session will be delivered by IBM Champion and author Tony Andrews from Themis, and will focus on SQL programming, performance, and tuning, as well as the SQL-PL native Stored Procedures language.

Why attend?  The annual education day presenters reads like “Who’s Who in Db2” and the sessions are consistently terrific.  Tony is an excellent presenter, the event is local for Baltimore/Washington area Db2 users, and it’s our group’s first meeting at our new BWI Hilton location.

To register:  visit the Baltimore/Washington Db2 Users Group webpage.

Cost:  $250 in advance and $300 at the door.  The fee includes materials and a sit-down lunch.

 

Think 2018, March 19 – March 22, Las Vegas, NV

IBM has consolidated several technical conferences into Think, with the conference topics covering AI, Cloud, Data, Security, and Systems.  As last year’s World of Watson/Insight/IOD annual data-centric conference was cancelled, Db2 users are interested in better understanding IBM’s direction and how the continued IBM transformation will impact their organizations.

Why attend?  This is usually the largest annual gathering of Db2 users.  Great networking, excellent presenters, superb people watching.  Maybe some answers to those nagging “what’s next?” questions??

To register:  visit the Think registration page.

Cost:  $2,295 for the week; $895 for a single day pass.  *Before registering ask your IBM rep for help with the cost of the pass.*  😉

 

IDUG Philadelphia, April 29 – May 3, Philadelphia, PA

The annual North America Db2 conference will be held in downtown Philadelphia this year, an easy and inexpensive commute for Mid-Atlantic organizations like The Fillmore Group.  The IDUG conference is where the Db2 community and IBM are focusing on the delivery of hard-core technical content.  With 5 days of education sessions, workshops, over 100 technical briefings and an experts’ panel, this year’s IDUG conference, while smaller than Think, will likely offer the best technical education value for Db2 users.

Why attend?  IDUG will deliver top-notch Db2 technical presenters and presentations.  Great networking and friendly – very community focused.

To register:  visit the IDUG North America 2018 conference webpage. 

Cost:  $1,865 through March 16 (early bird).  Need help funding a conference pass?  There are many discounts and community offers – contact the IDUG Conference Planning Committee (CPC) for help.

First Half 2018 Classes Posted at www/ibm.com/training

Posted by Kim May on December 14, 2017 under Authorized Training Partner, BLU Acceleration, DB2 for Linux Unix Windows, DB2 Migrations, Frank Fillmore, Global Skills Initiative, IBM DB2 Services, IDAA, pureScale, TFG Blog.

The Fillmore Group 1H 2018 Class Schedule

As an IBM Business Partner that truly believes that proper training is one of the most critical factors influencing the successful deployment and use of technology, we here at The Fillmore Group continue to evaluate the IBM Analytics courses available and to select those we feel will potentially help IBM Analytics customers succeed.  And, of course, as we believe affordable technical services are another of those critical factors influencing success, we are happy to customize classes and include them along with a fully scoped implementation or healthcheck effort.

One highlight and two classes NOT posted on the IBM website.  First, the highlight.  We’ve been told that pureScale is finally being adopted by Db2 LUW customers.  This is great news as it is great technology, featuring one of the best System z features (Parallel Sysplex) re-imagined for distributed environments.  Unfortunately, the course curriculum was written for the original version of pureScale, v10.5, and hasn’t been updated to reflect the enhancements in v11.  Nor does the course include hands-on exercises.  We have a solution:  Frank Fillmore recently delivered the class to a group of students implementing v11 and updated the materials and built hands-on exercises.

Second, two classes NOT posted on the IBM website but available in the first half of 2018:  hands-on IBM Integrated Analytics System (IIAS), the just-released upgrade to the IBM Db2 Analytics Accelerator (IDAA) and QMF for Multi-Platforms.  We are working on curriculum for both of these classes and hope to have them scheduled for sometime early in the year – we are targeting February for the IIAS class and March for QMF.  If you are interested in either class please let me know.

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.