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.

IBM Think Conference Call for Speakers is **OPEN**

Posted by Kim May on June 28, 2018 under Baltimore Washington DB2 Users Group, DB2 Education, DB2 for z/OS, IBM Think Conference, TFG Blog.

The IBM Think 2019 Conference will be held in San Francisco, on February 12 – 15.  For those like me, who felt the Las Vegas conferences were becoming one exhausted blur, San Francisco is a welcome change.

I hope this year’s Think Conference will offer excellent networking (why I go!), along with the opportunity to learn about new and “coming soon” solutions.  For technical folks there should be plenty of opportunities to learn and improve your skills.

As with past IBM conferences, presenters get a free pass. The conference fee is set at $2,295 – and we all know getting a free pass makes asking your boss to fund a week in San Francisco much easier.  And the Call for Speakers is now open.

I suggest anyone interested in presenting, particularly if it’s your first time submitting a presentation, share your presentation idea with your local users group and ask for their feedback. Users groups – like the Baltimore/Washington Db2 Users Group – review presentations throughout the year as part of the process of selecting meeting sessions.  Our board members can provide feedback to make your session abstract stand out (in a good way!)  Many of our board members have also delivered presentations, and welcome the opportunity to share their experiences with “newbie” presenters.

From IBM’s Call for Speakers announcement – “If you or your client have faced a challenge that led to a breakthrough in your industry, reinvented your processes, or resulted in success worth sharing, submit your proposal to become a speaker at Think 2019. All formats are welcome: lectures, labs, panels, breakout sessions, etc.”

The submission link is hereDon’t lollygag – submissions must be submitted by July 16, 2018.

Other dates to note: speakers selected will be notified in September; final presentations are due to IBM in December.

I hope to see you at Think!

*FREE* Hands-on IDAA Training – Columbus Class Announced for July

Posted by Kim May on June 14, 2018 under DB2 Education, DB2 for z/OS, DB2 Gold Consultants, Frank Fillmore, IBM Champion, IDAA, Mako, Netezza, TFG Blog.

Gold Consultant and Z Systems Champion Frank Fillmore will deliver a free, hands-on IBM Db2 Analytics Accelerator/IDAA class on Monday and Tuesday, July 23rd and 24th, at the IBM Dublin Campus near Columbus, Ohio.

Class has been updated to showcase the new IDAA V7.1 (“Sailfish”) and covers the new architecture, sizing considerations for the new generation of IDAA appliances, and recommendations for organizations upgrading from the Mako (V5) to Sailfish.

The fine print:  attendees must be IBM customers considering an IDAA purchase in 2018.  While class is free (and we will treat attendees to breakfast and lunch both days), attendees are responsible for their own travel and lodging expenses.

We have 20 available class seats, available on a first-come-first-served basis.  The registration link is here and the course outline is below. I will send travel information and recommendations to everyone registering (I’m working on them now!)

Finally, if there is any additional information needed please feel free to email me at kim.may@thefillmoregroup.com.

IBM Db2 Analytics Accelerator Training

Dates (2 days):  Monday and Tuesday, July 23rd and 24th, 2018

Class Times:  9:00am – 4:00pm

Cost:  Class is *free* to pre-registered attendees

Instructor:  Frank Fillmore

Join us for this refreshed class that includes material specific to the latest IDAA “Sailfish” releases, including V7.1, and the M4002, aka “Maverick”. Attendees will learn how and why an IDAA can extend your System z’s processing capabilities to enable Hybrid Transaction/Analytic Processing (HTAP).

Topics:

  • An introduction to the new V7.1 architecture and IBM Integrated Analytics System (IIAS).
  • The heterogeneous accelerator environment:  what works well today.
  • Assessment tools to support acquisition:  Workload Assessment, CVE, PoC.
  • Positioning IDAA within your organization with the most valuable use case.
  • Migrating from the Netezza-based IDAA to V7.1.

Lab 1: Basic IDAA Activities
– Data Studio / IBM Db2 Analytics Accelerator Studio GUI
– Table acceleration
– Query processing and analysis

Enhancing Value to the IDAA with the IBM Tools Ecosystem
– Assessment: What is the workload that would benefit from being accelerated?
– Optimization: How do I monitor and optimize a workload to take advantage of the Accelerator?
– Administration: Can I manage the Accelerator more effectively?

Lab 2: Advanced IDAA Exploitation
– Incremental Update: keeping accelerated data in sync with DB2 for z/OS OLTP
– Accelerator-only Tables (AoTs): intermediate tables and ETL processing

 

IDUG 2018 Thoughts and Notes

Posted by Kim May on May 7, 2018 under Baltimore Washington DB2 Users Group, DB2 Education, DB2 for Linux Unix Windows, DB2 for z/OS, IDAA, International DB2 Users Group (IDUG), TFG Blog.

Last week’s annual International Db2 Users Group (IDUG) Conference in Philadelphia was interesting and – as always – a great time to reconnect with friends and colleagues.  With IBM in what feels like perpetual transformation mode, I was curious to compare this conference with others I’ve attended in the past, to get a sense of how Db2 customers are perceiving the state of Db2 in these uncertain times.  My impressions:

  1. Db2 for z/OS customers, while not excited about growing workloads on System z, appear to be more confident their organizations will maintain what’s in place and invest in mainframe infrastructure when and where it makes sense.  I expected to hear the “we’re getting off the mainframe in 3 years” comment and did not; instead I was encouraged to see existing IDAA customers expressing interest in the new “Sailfish” model (V7.1).  Shameless plug:  if you were one of these people, please join us for our free IDAA class in June.
  2. For Db2 for LUW, the times are changing, and hopefully for the better.  Jon Lind’s Technical Advisory Board meeting offered participants a chance to express their concerns with the ecosystem, marketing, competitiveness, enablement, and I could go on, list of challenges around keeping Db2 for LUW relevant in the RDBMS market.  Jon Lind’s team has a refreshing willingness to listen, and the opportunity to revive Db2 for LUW.  Keep an eye on this team:  they have a long list of requests, and spent much of the conference talking with end users and partners about what they can do to help.  I wish them great success!!
  3. Kudos to the IDUG team for a fabulous location and super well organized event.  I wish we could have had some competitors join us for the community dinner to check out the enthusiasm (and noise level!) in the dining room.  There was ENERGY to spare!  And special thanks to IBM’s Surekha Parekh and Jim Reed for hosting such a great event at the conference and for all their support.
  4. One-name Rocket woman Saghi also deserves a shout out for gathering the local user group leaders for lunch and extending IDUG’s support to our Db2 communities.  The Db2 for z/OS RUGs are incredibly strong and doing their best to ensure LUW users have access to similar community resources.

So, I will end this post on my experience at IDUG with one final thank you, to Steve Cricchi, from T. Rowe Price, whose presentation on loading data into the IDAA was very well done and will be shared with the Baltimore/Washington Db2 Users Group at an upcoming meeting.  Well done!  Frank’s waiting for his beer…  🙂

IDUG Philadelphia Early Bird Discount Extended – Register Now!!

Posted by Kim May on March 21, 2018 under DB2 Education, DB2 for Linux Unix Windows, DB2 for z/OS, IBM Champion, International DB2 Users Group (IDUG), TFG Blog.

For those of us weathering the Spring snowstorm of 2018 on the East Coast – not in sunny Las Vegas, an incentive to think Spring and plan for warmer weather in Philadelphia during IDUG, scheduled for April 29th – May 3rd.

The Early Bird discount has been extended until March 31st.  There are – now – ten more days to register and take advantage of the reduced price.

As Bill Shipley emailed earlier today:  Remember this is the 35th Anniversary of IBM Db2 for z/OS, 25th Anniversary of IBM Db2 LUW and 30th Anniversary for IDUG.

IDUG 2018 offers new educational opportunities and more training than ever before! Attendees will experience:

•Five days of education sessions

•Half and full-day workshops

•More than 100 one-hour technical sessions

•Two expert panels on z/OS and LUW

And my birthday’s in there, too…hope we can celebrate together in Philly!!

Skipping Think

Posted by Kim May on March 7, 2018 under #IBMInsight, DB2 Education, Frank Fillmore, IBM Think Conference, Information on Demand Conference, Insight 2014, Insight 2015, TFG Blog.

Frank asked me to respond to an email from an IBM’er asking whether we will be at the Think Conference in Las Vegas. I started the reply and then decided – in the interest of efficiency – to post my response on our blog so that I can direct inquiries here. Apparently there’s a bit of pressure on to boost attendance.

After attending every IOD, Insight and World of Watson conference, Frank and I have decided to skip Think. The arc of the annual IBM data-centric conferences has in many ways paralleled the arc of The Fillmore Group over the past 10 years. I haven’t given up on achieving success in the future, but the status quo is unsettling.

Some history: when IBM announced the first Information on Demand/IOD Conference, I was fairly new to The Fillmore Group. I sold and coordinated technical training for companies in the Mid-Atlantic prior to joining TFG and was involved in the Greater Baltimore Tech Council, whose quarterly wine tastings were legendary – fun, great for business, and fabulous networking. Frank loved the idea, and we hosted our first wine tasting at the first IOD annual conference in Anaheim. At this event I was introduced to the IBM Lab Services Data Management team, who became our largest customer for the next three years.

After the first year the conference was moved to Las Vegas, where each year we have rented a suite and hosted a champagne tasting. One year we couldn’t get a large enough suite and had to put the champagne in the bathtub (see the picture below – only in Vegas!) I recall that year particularly vividly as Frank gushed afterward at the number of IBM Data Management VP’s in attendance (6 – and my guess is he can still name them!) We had a great time introducing IBM’ers to their colleagues and wow’ing our customers by introducing them to the stars of the Db2 world.

At one of the conferences Steve Mills attended our event as well as the IBM Data Champions luncheon where he gave Frank an award for our consulting team’s support of the JP Morgan Chase Oracle to Db2 migration effort. Frank is rarely speechless; on this occasion he was.

So why aren’t we looking forward to another conference?

First, we want to be where our customers are. I am the chairman of the Baltimore/Washington Db2 Users Group and I only know of one of my member organizations sending people to Think. We have a lot of Federal agency members, and they stopped attending years ago, but even the commercial customers don’t seem to be interested.

I believe the Db2 technical people, if attending any conference at all in 2018, will be at IDUG. The IDUG session abstracts explain what will be presented in a font that allows for the use of multiple words, and the topics are of interest to the audience. I understand a few will be at SHARE next week…along with most of the IBM z technical team. Who can afford 3 weeks out of the field attending conferences before the end of the first half?

Second, IBM’s often contradictory messaging regarding the role of Business Partners is particularly confusing this year. What is the value of this partnership and what do partners provide to IBM and its customers? What is IBM doing to support us in return?

In the past there was recognition for our product promotion and outreach. For these efforts, primarily related to marketing and reselling IBM software, partners like The Fillmore Group were provided with sales leads and co-marketing funding to offset event costs.

Over the past year IBM has “transformed” the Business Partner program. They claim the new program recognizes skilled partners, and claim partners will be allocated sales leads and co-marketing funding based on the achievement of technical competencies. Competencies – according to IBM – are determined by the certifications earned in a particular category, demonstrating technical skills, and reselling a minimum of one million dollars’ worth of software in each category. I giggle as I type. Our team has historically supported customers running IBM replication solutions. Has anyone paid (channeling Mike Myers’ Austin Powers as Dr. Evil) ONE MILLION DOLLARS for replication?

Meanwhile IBM is trying to transform (oh that word!) their software licensing to a cloud-based, SaaS model, and encouraging Business Partners to develop the ability to collect monthly software license fees from customers. Will the new partners ever achieve the one million dollars of sales within one Analytics sub-category and qualify as “competent”? If not, will the top partners grow IBM’s software business or simply continue to slow revenue slide along with IBM?

On the 2018 IBM Business Partner kickoff call, IBM’s General Manager for Global Business Partners listed his 5 top initiatives for 2018. One is to better support IBM’s top 300 resellers, of which The Fillmore Group is not one, and another is to attract new Business Partners.  IBM has 19,000 Business Partners. As one of the 18,700 IBM Business Partners IBM has abandoned, we plan to attend IDUG with some technical folks and customers and hope maybe someday IBM finds us of value again in the future.

 

 

 

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.

2018 New Year’s Resolutions – Let’s Get Started!

Posted by Kim May on January 4, 2018 under Authorized Training Partner, Baltimore Washington DB2 Users Group, DB2 Education, DB2 for z/OS, DB2 Migrations, Frank Fillmore, IDAA, Oracle, TFG Blog.

As always the holidays are over too soon.  Here at The Fillmore Group we are back to work, starting the year with the usual goal setting and head scratching.  Three initiatives we worked on in 2017 showed a great deal of promise but never seemed to quite gain the traction we had hoped for.  So, unlike in prior years when I would start with a blank page, I am committing myself to pushing these three harder in 2018, as all three offer terrific options to maximize the value of an organization’s data assets.  These are:

Oracle to Db2 database migrations.  Last year IBM offered discounted Db2 licenses to current Oracle customers – and when I say “discounted” I mean practically gave them away.  Frank Fillmore and I delivered several competitive migration presentations and got lots of positive feedback from Oracle customers.  Still, we didn’t see a lot of Db2 adoption from these folks and I’m sorry – for them and us.  This is a head-scratcher, because I’m not sure where we are getting snagged, but we need to figure it out in 2018.

IDAA/IIAS/HTAP vs. “edge systems”.  Admittedly 2017 was a bit of a transition year for the IBM Db2 Analytics Accelerator (aka the IDAA) as IBM completely revamped the design, replacing the Netezza-bolted-to-a-mainframe with 2 Db2 BLU Acceleration-based options to deliver the Hybrid Transaction Analytic Processing (HTAP) capability.  Meanwhile in 2017 analysts were predicting that edge systems are the future – sounding frighteningly like they did in the late 1990’s when the standalone data warehouse was the next big thing.  It makes absolutely no sense to me to build out a completely new system, particularly on the periphery of an organization’s most secure system, to perform analytics when IBM has clearly demonstrated you can leave the data in place and perform both your OLTP and analytic processing in tandem.  We need to continue to educate customers to ensure they understand the overall value – reducing complexity, reducing cost, and keeping data secure.  The new BLU-based version has a new name:  IBM Integrated Analytics System – IIAS.

Supporting the Db2 eco-system.  This is such a no-brainer but one that needs constant attention, effort and input to maintain.  IBM formal classroom education offerings are minimal.  Conferences – IBM and IDUG – are changing and it’s difficult to determine which is most appropriate to attend.  Users groups (including the Balto/Washington Db2 Users Group) are struggling to provide our users with unbiased product information, education and resources.  We aren’t giving up and hope the greater Db2 community continues to work to stay active and involved within the community and within our individual organizations.  If we want to stay relevant we need to stay involved.

Happy 2018!  Off to work!

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.

It’s Q4 and the Second Opinion Clinic is Open

Posted by Kim May on November 28, 2017 under Authorized Training Partner, DB2 Education, DB2 for Linux Unix Windows, DB2 for z/Linux, DB2 for z/OS, DB2 Migrations, IBM DB2 Services, IBM Information Management Software Sales, TFG Blog.

It’s Q4 – and that means IBM software sellers are making their best deals.  As an IBM customer, you know the year end deals are the best available, right?  I hope so…but if you have any doubt and/or think getting a second opinion may help validate just how great the pricing is, please contact The Fillmore Group for a free second opinion.

And, of course, if you need help implementing the solution being proposed, or education to ensure your team is able to effectively support the new solution, we would be happy to provide a services estimate.  As an IBM Authorized Training Partner, expert consulting provider and Analytics Reseller (for both distributed/PPA software and System z), we have access to IBM customer discount levels and understand the various packaging and pricing metrics used for solution sizing and selection.

Don’t let PVU vs. TB sizing, sub-capacity and limited use licensing confuse you into spending more than you need to…click HERE to contact us for an explanation and a second opinion.  The doctor is in!