Extending appreciation to all who participated in the IBM Db2 Analytics Accelerator (IDAA) v7.1 webinar on August 28, 2019.  If you weren’t able to join us, here is the webcast recording.  In a fast-paced 90 minutes we covered:

1. A review of capabilities included in recent IDAA v7.1.x code drops
2. The return of the High Performance Storage Saver (HPSS)
3. Integrated Synchronization
4. The closer-to-real Hybrid Transaction Analytic Processing (HTAP) capability
5. Disaster Recovery and High Availability considerations

The Fillmore Group’s exclusive IDAA Buyer’s Guide compares these IDAA form factors and deployment options:

• IBM Integrated Analytics Systems (IIAS)
• Docker container running on System z
• Docker container running on LinuxONE

And this is the handout: IDAA Webinar 2019-08

Please note: if you would like the exclusive IDAA Buyer’s Guide referenced in the webinar, contact my colleague, Kim May (kim.may@thefillmoregroup.com).

Our webinar delivered on March 11, 2016 outlining access to mainframe data specifically oriented to non-mainframers such as IT Architects and Data Scientists was a success.  The presentation materials are here: IBM z Systems – Mainframes – for IT Architects and Data Scientists

A recording of the webinar is found here.

In this session I described and compared 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

Click here for the recording of the webinar.  The presentation materials: IBM Data Retrieval Technologies RDBMS BLU Netezza and Hadoop

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)

Click here for the recording of the webinar.  The presentation materials: Hybrid Transaction Analytic Processing – HTAP

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

Last week in Baltimore The Fillmore Group conducted a deep-dive technical workshop on IBM DB2 Analytics Accelerator.  We covered Basic and Advanced hands-on labs with the support of the IBM Poughkeepsie Demo Center.  Saghi Amirsoleymani and Mike Hood, both of IBM, presented on the Tools Ecosystem supporting the Accelerator including:

• Omegamon XE for DB2 Performance Expert
• DB2 Query Monitor
• Optim Query Workload Tuner
• DB2 Analytics Accelerator Loader

The presentation I gave outlining the topics covered in the Basic and Advanced lab exercises is here: IDAA Workshop 2014-04  Additional presentations will be posted soon.

Demo videos of the Tools include:

• DB2 11 Using Statistics Collection Advisor
• IBM DB2 Analytics Accelerator for z/OS and the Supporting DB2 and Optim Database Tools

Database Magazine and Articles on Accelerating Analytics Queries

http://ibmdatamag.com/2013/12/accelerating-analytics-queries/

http://www.ibm.com/developerworks/data/library/techarticle/dm-1403queryaccel/index.html

When IBM acquired Netezza the phenomenal processing capability enabled by the Netezza FPGA technology (Field Programmable Gate Arrays) made Netezza’s query speeds clear winners when benchmarked against all competitors.  Today IBM announced a new generation of Netezza, now branded the “IBM PureData System for Analytics”Powered by Netezza”, the N2001 systems.

The new N2001 system specs once again put Netezza into the “catch-me-if-you-can category, with a 3 times faster scan rate than the current Netezza, while supporting 50% greater storage capacity per rack, and improved resiliency and fault tolerance, thanks to more spare drives in the cabinet and faster drive regeneration.

The N2001 is available with the same quick, simple installation, and IBM also updated the IBM DB2 Analytics Accelerator, the “sidecar” Netezza that attaches to the mainframe.  More on the new sidecar soon – I hear the IDAA has even more capabilities to offer DB2 for z customers.  Stay tuned!

IBM DB2 Analytics Accelerator (IDAA) powered by Netezza Lunch and Learn

If you are in the Baltimore/Washington area and interested in learning more about the IBM DB2 Analytics Accelerations – the IDAA – please join Netezza evangelist Dwaine Snow and DB2 Gold Consultant Frank Fillmore for lunch to learn about the new solution from IBM that merges System z with Netezza. The IBM DB2 Analytics Accelerator creates an environment for operational data store, data warehouse and analytic marts on the same platform as operational systems, such as IMS™, CICS®, Java™, the Web and more.

Learn how you can use the IBM DB2 Analytics Accelerator to:
• Enable decision-makers to perform high-performance business analysis for better results
• Substantially reduce operational costs by removing the need for complex query tuning
• Drive immediate value to the bottom line by rapidly adding new applications and user requirements
• Extend the qualities of service in security and availability of System z, enabling business intelligence to deliver business changing analytics and reduce complexity by extending System z manageability

*** Session attendees may qualify to attend a free 2-day hands-on IDAA training session at The Fillmore Group’s Towson, MD office in July. ***

Date: Wednesday, June 27th 2012
Time: 10:30 am – 1:00 pm
Location: Sheraton Columbia Town Center Hotel – Merriweather Room
   10207 Wincopin Circle – Columbia, Maryland 21044
Agenda:
10:30 – 11:30 IDAA Overview – Dwaine Snow
11:30 – 12:00  IDAA Enablement – Best Practices – Frank Fillmore
12:00 – 1:00 Lunch, Q&A, Open Discussion, raffle for Baltimore Orioles tickets (8/14 vs. Boston)  

Register here: http://tinyurl.com/tfgidaa 

Presenters:
Dwaine Snow
Dwaine is a Data Warehouse and OLTP Competitive Analyst and has worked for IBM for the past 21 years.   Prior to supporting Netezza, Dwaine was one of the senior product managers responsible for new releases of DB2 for Linux, UNIX, and Windows.  Dwaine has written books, articles and tutorials, and has presented at numerous IDUG and RUG conferences. In addition to promoting Netezza and IDAA Dwaine is hoping to start writing his first Netezza book soon.

Frank Fillmore
DB2 Gold Consultant and IBM Champion Frank C. Fillmore is the Founder and President of The Fillmore Group, a Premier Business Partner specializing in Information Management software sales, consulting, and training. He has been providing IBM Information Management services for 25 years.  This past summer Frank worked with Sears to enable near real-time OLTP data loads to Netezza, and Frank recently coordinated hands-on IDAA training.

This week The Fillmore Group is welcoming Andy Perkins from IBM in Dallas, Texas, who is here to deliver hands-on IDAA training to a group of consultants from The Fillmore Group, a couple members of the IBM z/technical team, and a prospective customer.  What’s the big deal all about?

For starters, “Sidecar” is the nickname given to the IBM Data Analytics Accelerator, or IDAA (for short, if you consider a 4-letter acronym short).  The Sidecar, or IDAA, is a Netezza that attaches to an IBM mainframe and enables users to apply Netezza’s remarkable query speed to mainframe queries.  By doing so they can radically change the way they look at business analytics and evaluate their BI strategy.  Does an organization really need to move all the data to a separate warehouse to run reports?  How quickly can an organization run queries and put the results to work?

At The Fillmore Group we are convinced this is the next big thing and are excited to have consultants already skilled in the component parts – mainframe technology and Netezza – now becoming familiar with the installation process to get the Sidecar into production.    If you are as excited about it as we are, or just curious, let us know.