Frank Fillmore to Present at Heart of America #DB2 Users Group #zIBM #IDAA #HTAP

Posted by Frank Fillmore on February 26, 2016 under BLU Acceleration, DB2 for Linux Unix Windows, DB2 for z/OS, DB2 Gold Consultants, Frank Fillmore, IBM Champion, IDAA. Tags: , , , , , .

On Monday, March 14, 2016 DB2 Gold Consultant and IBM Champion Frank Fillmore will present on Hybrid Analytic/Transaction Processing (HTAP) at the Heart of America DB2 Users Group in Overland Park, KS.

A complete agenda, presentation abstracts, and speaker biographies can be found here.

IBM Data Retrieval Technologies: #RDBMS, #BLU, #Netezza and #Hadoop

Posted by Frank Fillmore on July 28, 2015 under BigInsights, BLU Acceleration, DB2 for Linux Unix Windows, DB2 for z/OS, IDAA, Sidecar. Tags: , , , , , .

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

IBM Hybrid Transaction/Analytic Processing #HTAP #IDAA #BLU #IBMz Webinar Materials

Posted by Frank Fillmore on July 21, 2015 under BLU Acceleration, DB2 for Linux Unix Windows, DB2 for z/OS, IDAA, MQT's, Netezza, Sidecar. Tags: , , , , , .

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

Frank Fillmore’s Insight Conference Presentation

Posted by admin on July 14, 2015 under Big Data, BigInsights, BLU Acceleration, DB2 for Linux Unix Windows, DB2 for z/OS, DB2 Gold Consultants, Frank Fillmore, Hadoop, IBM Champion, IDAA, Insight 2015, Mako, Netezza, TFG Blog. Tags: , , , , , .

Congratulations to Frank on the selection of his 2015 Insight Conference presentation!  Frank’s presentation (session #3584 for those of you already  working on your schedules) is titled, “DB2 ^ (Netezza | BLU) = Hybrid Transaction and Analytics Processing (HTAP)”.

As soon as the Insight schedule is released I will update this post with the session date and time.  Stay tuned!

In his session Frank will describe and compare the four distinct data retrieval technologies available from IBM, including two Hybrid Transaction and Analytics Processing (HTAP) platforms. 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

Bio
DB2 Gold Consultant and IBM Champion Frank C. Fillmore, Jr. is the Founder and President of The Fillmore Group, Inc., a Premier IBM Business Partner that specializes in IBM Analytics software sales, consulting, and training. Frank has been providing IBM Information Management solutions to government, industry, and not-for-profit enterprises as varied as The World Bank, J.P. Morgan Chase, Northrop Grumman, and the FBI for over 28 years. Frank’s current practice centers on Hybrid Transaction and Analytic Processing (HTAP) and Oracle to DB2 migrations as well as information governance and integration. Frank kayaks and cheers for the Baltimore Orioles.

 

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

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

IDAA Use Cases – Session #IDZ-6691B at Insight

Posted by Kim May on September 9, 2014 under DB2 Education, DB2 for z/OS, DB2 Gold Consultants, Frank Fillmore, IBM Champion, IDAA, Insight 2014, TFG Blog. Tags: , , , , , .

Frank Fillmore will be delivering a session on IDAA use cases at the IBM Insight Conference in Las Vegas (formerly IOD) on Tuesday, October 28th, from 10am-11am.

The IBM DB2 Analytics Accelerator (IDAA) speeds analytic queries that currently run on DB2 for z/OS.

IBM DB2 Analytics Accelerator can:

  • Help with operational data store reconsolidation on IBM System z.
  • Reduce extract, transform and load (ETL) costs and latency to make OLTP data available for analysis faster and less expensively.
  • Speed up batch reporting and offload System z processor consumption.
  • Archive original data by using the high performance storage saver (HPSS).
  • Enable analysis of VSAM and Information Management System (IMS) data along with DB2 for z/OS by using the DB2 Analytics Accelerator Loader.

In Frank’s session, attendees will learn about these functions and more, and gain an understanding of possible, interesting, and valuable IDAA use cases.

I hope we will see you there!

IBM DB2 Analytics Accelerator (#IDAA) Workshop a Success!

Posted by Frank Fillmore on April 14, 2014 under Data Studio, DB2 Education, DB2 for z/OS, IDAA, Optim, Sidecar. Tags: , .

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:

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:

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

Attending zIM Bootcamp at IBM Silicon Valley Lab Next Week @IBMDB2

Posted by Frank Fillmore on January 25, 2014 under Big Data, DB2 for z/OS, DB2 Gold Consultants, IBM Champion, IBM Information Management Software Sales, IDAA. Tags: , , .

Each year IBM assembles their Client Technical Professionals (CTPs) for System z Information Management software at Silicon Valley Lab.  For the past three years IBM has invited DB2 Gold Consultants to participate.  The 4 ½ day conference is rich with lectures and hands-on labs covering such diverse topics as DB2 for z/OS tools and utilities and IMS.  I am particularly interested in:

During the week I’ll blog and Tweet.  I look forward to your comments and questions.

IDAA Lunch and Learn with Dwaine Snow

Posted by Kim May on June 13, 2012 under DB2 Stars, Frank Fillmore, IDAA, Netezza, Sidecar, Sidecar, TFG Blog, Uncategorized. Tags: , , .

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.