IBM DB2 Analytics Accelerator v4 PTF 5 Enhancements #IDAA #IBMz

Posted by Frank Fillmore on June 21, 2015 under Big Data, DB2 for z/OS, Mako. Tags: , , .

Abstract: An update on the latest IBM DB2 Analytic Accelerator (IDAA) PTF released in May, 2015. This PTF delivers new functionality to extend IDAA utilization for DB2 for z/OS users including:

  • Improved Incremental Update reliability and performance
  • Accelerated dynamic query statement caching
  • Additional scalar function support
  • In-database transformation with Accelerator Only Tables (AOTs)

Click here for the recording of the webinar.  The presentation materials: IDAA v41 PTF5 TFG

Congratulations to the 2015 IBM Champions for Information Management!

Posted by admin on June 1, 2015 under DB2 for Linux Unix Windows, DB2 for z/OS, Frank Fillmore, IBM Champion, TFG Blog.

Beth Flood, Program Manager for the IBM Champions for Analytics, today announced the 2015 Champions.  Congratulations!  The complete list of Champions is on the IBM website at:  ibm.com/developerworks/data/champions

The Champions program is in its sixth year, rewarding IBM Information Management advocates and expert technical users for their efforts in the community that promote IBM solutions.   These efforts include delivering presentations, supporting users groups, authoring articles, books and white papers, and overall giving the community a group of recognized specialists willing and able to help.  The program requires revalidation annually, to ensure we continue our efforts.  Frank and I have been honored to be recognized each year since the program’s inception, and we have greatly appreciated the rewards – working with Beth, networking with the Champions at conferences, getting new product announcements *before* anyone else, and of course, all the discounts and great stuff Beth manages to snag for us.

Most importantly, I am extremely proud when I review the list of Champions and recognize so many skilled DB2 consultants The Fillmore Group has had the pleasure to work with.  I wish I could keep you all busy all the time!  You are great!

IBM’s OLTP and Analytic Data Strategies Webinar Series

Posted by admin on May 20, 2015 under Authorized Training Partner, Big Data, BigInsights, BLU Acceleration, DB2 for Linux Unix Windows, DB2 for z/OS, DB2 Gold Consultants, Frank Fillmore, Hadoop, IBM DB2 Services, IDAA, Netezza, TFG Blog.

I am excited to invite IBM data management users to join DB2 Gold Consultant Frank C. Fillmore for a series of three webinars covering the latest IBM database strategies.  Each session highlights a topic critical to IBM data management customers’ knowledge of the many, sometimes competing, often confusing, options available from IBM.

The content will help data architects better understand the latest solutions available to support analytic and OLTP workloads, as well as IBM’s data strategy direction and where today’s solutions – relational databases, Netezza and Hadoop – are best applied.

Attend one webinar or join us for all three.  Each one hour session will provide a wealth of clear, useful information.  Click on the links below to register.

#1  IBM DB2 Analytics Accelerator v4 PTF 5 Enhancements
Tuesday, June 9, 2015, 1pm-2pm EDT  Register here:  https://attendee.gotowebinar.com/register/5384878354738776577
Frank will present an update on the latest IBM DB2 Analytic Accelerator (IDAA) PTF released in April, 2015. This PTF delivers new functionality to extend IDAA utilization for DB2 for z/OS users including:
– Improved Incremental Update reliability and performance
– Accelerated dynamic query statement caching
– Additional scalar function support
– In-database transformation with Accelerator Only Tables

#2 IBM Hybrid Transaction/Analytic Processing (HTAP)
Tuesday, June 20, 2015, 1pm-2pm EDT  Register here: https://attendee.gotowebinar.com/register/5118968064636087810
Learn how customers are using HTAP to eliminate analytic latency and data synchronization issues to transform and simplify information management infrastructure. For years IT customers have been told that online transaction processing (OLTP) and analytics couldn’t co-exist on the same platform. This led to costly and complex regimes to move OLTP data to a different platform for analytics. With HTAP, the barriers to near real-time analytics are removed amid significant reductions in IT expenses and complexity risk.

The concept of Hybrid Transaction/Analytic Processing was coined by Gartner. IBM implements HTAP in two ways:
– IBM DB2 Analytics Accelerator (IDAA) for DB2 for z/OS data (using Netezza hardware)
– DB2 BLU Acceleration – DB2 for Linux, Unix, Windows (a software-only implementation)

#3  IBM Data Retrieval Technologies:  RDBMS, BLU, Netezza and Hadoop
Tuesday, July 21, 2015, 1pm-2pm EDT, Registration here:  https://attendee.gotowebinar.com/register/1762449336105853441
In this session Frank will describe and compare the four distinct data retrieval technologies available from IBM.  Choices are good to have, but how do you choose which technology to apply to a particular business use case? Learn how these techniques differ, including their relative strengths and weaknesses.
– The traditional RDBMS, relying primarily on indexes to speed access
– The new BLU Acceleration columnar compression and memory-optimized database
– IBM PureData System for Analytics (Netezza), which deploys racks of Field Programmable Gate Array (FPGA) processors to parse data
– IBM InfoSphere BigInsights,  the IBM distribution of Hadoop

Registration for each webinar is required.  To register, click on the session registration links above.  I hope you will join us!

Training Anyone?

Posted by Kim May on May 14, 2015 under Arrow ECS, Authorized Training Partner, Big Data, BigInsights, BLU Acceleration, Data Studio, DB2 Connect, DB2 Education, DB2 for Linux Unix Windows, DB2 for z/OS, Global Skills Initiative, Hadoop, InfoSphere, Optim, pureScale, Q-Replication, TFG Blog.

The Fillmore Group 2H 2015 Class Schedule

With all the challenges IBM’s move to the Global Skills Initiative (aka outsourcing education) has created for DB2 users, please remember IBM classes do still exist and are available for the patient and persistent.  Fear not!  If you need training, we are prepared to help.

After seeing public training nosedive over the past two years we are now seeing a bit of a resurgence.  Are classes really running?  Well, in all honesty, not often.  However, we are seeing a few run here and there, and when they don’t, with our relationship with Arrow ECS (one of the five Global Training Partners) intact, we are learning to “collect” students interested in training, and either gather them together for classes, or provide private training at affordable rates.

I’ve just submitted our second half of 2015 public training class schedule to Arrow (see the attachment above) and expect to see the classes posted on the IBM training site (IBM.com/training) within the next couple weeks.  I welcome anyone looking for a class – whether it’s on my schedule or not – to contact me at kim.may@thefillmoregroup.com so that I can work some coordination magic for you.

Can We Reverse This Trend?

Posted by admin on April 24, 2015 under Authorized Training Partner, Baltimore Washington DB2 Users Group, DB2 Education, DB2 for z/OS, DB2 Migrations, Global Skills Initiative, IBM DB2 Services, IDAA, TFG Blog.

Just this week, while working to support a new customer consulting requirement, collaborating with IBM on a handful of IDAA sales opportunities, and following up on a Baltimore/Washington DB2 User Group initiative I ran into varying responses based on one similar theme:  customers are losing confidence in the long-term viability of the mainframe.

My consulting customer is looking for a skilled resources to support a DB2 for z/OS environment.  Due to the “downward pressure on rates” they want the hourly rate to be 20-25% less than they paid for a similar resource in 2012.  Of course, they tell me, they will accept someone with fewer years of experience – 3 to 5, rather than 5 to 10.  Where does one find a US citizen (a requirement) with 3 to 5 years of DB2 for z/OS experience?  With the Global Skills Initiative IBM education has dropped off dramatically.   The IBM Academic Initiative seems to have proven successful for one financial institution in the Southeast (but for no one else), and the skills shortage we’ve all been hearing about for years is being compounded by the drumbeat of Procurement teams requiring cheaper and cheaper personnel.

Our strategy sessions around IDAA prospects invariably begin with someone saying, “well, you know, XYZ Company is planning to be off the mainframe by 2017.”  Or some other year…but it’s always part of the discussion.  Apparently while people with moderate arithmetic skills can demonstrate the overall cost savings of System z, the “modernization” folks are beating us up with their messaging.  It’s tough to address the TCO challenge when the second question is, “and who will do the work?”

My local RUG agreed to sponsor college students at our meetings so that we can try to get some future graduates interested in the mainframe.  Baltimore, where I live, has many colleges and universities but thus far, in spite of my outreach, I’ve only gotten a response from one school willing to tell their students about our offer.  I can’t help but wonder if the career counselling centers haven’t been told to avoid the mainframe, too.

I am frustrated.

*Free* Hands-on IDAA Class – New England – April 27th and 28th

Posted by admin on March 19, 2015 under Data Studio, DB2 Education, DB2 for z/OS, DB2 Gold Consultants, Frank Fillmore, IBM Champion, IDAA, Mako, Netezza, TFG Blog.

Just announced!

DB2 Gold Consultant Frank Fillmore will deliver a free, hands-on IDAA class at the historic Publick House in Sturbridge, Massachusetts, on April 27th and 28th.  The complete course outline and registration information are HERE.   The Welcome Packet with travel and lodging recommendations is HERE.

Class is free, however students are responsible for their own travel and lodging expenses.

The IDAA is a high-performance appliance that integrates IBM Netezza and zEnterprise technologies. The solution delivers extremely fast results for complex and data-intensive DB2 queries on data warehousing, business intelligence and analytic workloads.  You can:

– Query data at high speeds-to significantly improve response times for unpredictable, complex and long-running query workloads.

– Extend the capabilities of DB2 for z/OS-to support a cost-effective analytics solution for data warehousing, business intelligence and predictive analytics.

– Lower operating costs-by reducing System z disk requirements and offloading query workloads to a high-performance platform.

Please note:  this class is being offered exclusively to IBM z Systems customers considering an IDAA purchase.  Registration is required.

I hope you will join us and learn about the IDAA!

2015 IBM Champions for Information Management

Posted by admin on March 12, 2015 under DB2 Education, IBM Champion, TFG Blog.

Congratulations to the 2015 Champions!

After work last night I stopped at the store and stood in line for about 10 minutes waiting to pay for a $4 hairband.  When it was finally my turn to checkout, at a nationwide retailer that’s been in the news for a data breach, I was asked for my zip code, email address, and asked to complete an online survey when I got home.  My frustration with the incessant collection of personal information – and the resulting Inbox clogging marketing emails, telemarketer calls and junk mail had me fuming!

Then, I got home and read the email from IBM’s wonderful Beth Flood telling me I was selected as a 2015 IBM Champion for Information Management and it got me thinking about the whole analytics, social networking and community ecosphere that’s been developing over the past ten years.  It’s immature, and often annoying, and definitely still needs work.  However, on the bright side, it has enabled individuals and organizations to make better decisions so much faster (and yes, often accurately).  We are all becoming conditioned to expect things to work faster and technology to know our preferences and anticipate our choices.

Both Frank Fillmore (another 2015 Champion – congratulations!) and I have had the opportunity to participate in this program designed to encourage and reward people in the DB2 community who share our experiences and knowledge with others – through the same social networks and tactics that we all sometimes find aggravating.  However, when things work – when, for instance, I am able to connect with a DB2 customer and assist them in finding appropriate education, or when I coordinate an event that enables DB2 users in the community to gather and learn about new solutions, it works as designed and really helps people get the information they need.

Thank you Beth, and thank you IBM for supporting the Champions program and inviting us to participate.  I will remind myself of the power of the unsubscribe button, and try to be mindful of the positive changes data accumulation and analysis bring to our lives.  I appreciate being a part of it.

IBM DB2 Analytics Accelerator #IDAA #DB2z Hands-on Workshop Returns in 2015

Posted by Frank Fillmore on February 26, 2015 under Data Studio, DB2 for z/OS, IDAA, Mako, Sidecar. Tags: , , .

Thanks to Kim May and Saghi Amirsoleymani of IBM for the successful two-day IBM DB2 Analytics Accelerator (IDAA) Workshop with hands-on lab exercises.  Five large financial services enterprises sent attendees.  Thanks as well to Al, Allan, Dave, Ed, Jim, Lori, Warren, and Steve for the lively discuss and deep technical questions.

The presentation is attached here: IDAA Workshop 2015-02

IBM Recognizes The Fillmore Group for IDAA Classes at 2015 z/Bootcamp

Posted by admin on February 4, 2015 under DB2 Education, DB2 for z/OS, DB2 Gold Consultants, DB2 Stars, Frank Fillmore, IBM Champion, IBM Information Management Software Sales, IDAA, Mako, Netezza, TFG Blog.

Frank Fillmore and IBM’s Kevin Poole were congratulated on stage at last week’s IBM z/Bootcamp where The Fillmore Group was recognized for the success of our 2014 IDAA hands-on training classes with the “New Business Hero” award.  We are looking forward to our first 2015 IDAA class February 24th and 25th in Baltimore, and excited to work with IBM z Systems customers considering IDAA acquisitions – we think it’s great!

Many thanks to our IBM colleagues – Saghi Amirsoleymani, Mike Hood, Rich Gast, Seth Steinberg and Jim Reed, who helped us share the IDAA excitement with our customers this past year.  We are looking forward to more excitement in 2015!!!

*Free* Hands-on IDAA Class Announced – Baltimore – February 24 & 25

Posted by Kim May on January 16, 2015 under Authorized Training Partner, Data Studio, DB2 Education, DB2 for z/OS, DB2 Gold Consultants, Frank Fillmore, IDAA, Mako, Netezza, TFG Blog.

DB2 Gold Consultant Frank Fillmore will deliver a 2-day, hands-on IBM DB2 Analytics Accelerator (IDAA) class at the Radisson Cross Keys in Baltimore, Maryland, on Tuesday and Wednesday, February 24th and 25th.  IBM z Systems customers considering an IDAA acquisition are invited to attend free of charge.

The class will be provide an overview of the System z + Netezza IDAA hybrid technology, along with an introduction to the many (and ever expanding) array of deployment options being used to leverage this unique, powerful, and cost-saving technology.  Originally introduced as a means to accelerate analytic queries on System z, the IDAA is now being used to address a variety of challenges, including archiving data with the option for fast retrieval, via the High Performance Storage Saver (HPSS).

With 2015’s introduction of V5, and the integration of the recently upgraded Netezza Mako line of appliances, the IDAA is a “must see” for all System z customers.

If you are interested in joining us, please review the course outline and registration.  Registration is limited to 20 students, on a first-come-first-served basis.

Please note:  Seats are reserved for current IBM z Systems customers considering an IDAA acquisition.  Attendees are responsible for their own travel and lodging expenses; The Fillmore Group’s Welcome Packet with travel recommendations will provide assistance.

I hope we will see you in Baltimore next month!