Lunch Event March 3rd: #zIBM (Mainframes!) for Data Architects and Data Scientists

Posted by Frank Fillmore on February 2, 2016 under Big Data, DB2 Connect, DB2 for z/OS, DB2 Gold Consultants, Federation, Frank Fillmore, IBM Champion, IDAA, Q-Replication. Tags: , , , , , , , .

Kim has just returned from IBM’s annual “z Bootcamp” where they prepare their System z sellers for the upcoming year with a series of product updates, announcements and education.  Her takeaway message for 2016 was loud and clear:  IBM intends to continue to enhance and extend the capabilities of System z so they can remain relevant and leading the effort to leverage the power of System z data.

Which leads, naturally, to the “how?” question.  At The Fillmore Group, as an IBM Business Partner we believe our ability to connect with Data Scientists and Data Architects and to help them understand the data stored in System z will help us all better align our interests and build a successful data and analytic ecosystem.  To kick start this effort we have planned a lunch event at the award-winning Woodberry Kitchen in Baltimore where Frank Fillmore will present an overview of System z.  Read more below – and please join us if you can!

“IBM z Systems (Mainframes!) for IT Architects and Data Scientists”

Abstract
Fifty percent or more of a large enterprise’s data – especially the lifeblood online transaction processing (OLTP) data – likely reside on IBM z Systems (aka mainframe) computers.  In many organizations, mainframes remain a black box inside the “glass house” data center.  Yet the rich transactional data they contain are crucial to predictive analytics, such as fraud detection, and real-time data warehousing applications such as point-of-sale market basket analysis.

This lunch session is intended for Architects and Data Scientists who don’t have a mainframe background, but have been tasked by lines-of-business to develop new competitive insights into customers, supply chains, insurance claims, financial transactions – and/or any of a variety of other opportunities to turn an enterprise’s OLTP data into Big Data.

DB2 Gold Consultant and IBM Champion Frank Fillmore will explain:

The types of data are found on the mainframe, including:
• DB2 for z/OS (relational database)
• IMS – Information Management System (hierarchical database)
• VSAM – Virtual Storage Access Method (indexed file)

Frank will also explain the four key approaches to unlocking the data:
1. HTAP – Hybrid Transaction and Analytics Platform
2. Replication to heterogeneous data stores
3. Virtualization of heterogeneous data stores
4. ETL – Extract Transform Load

Frank will also discuss the how these approaches apply to the types of data in the context of the application requirements such as service level agreements (SLAs).

The session will be held on Thursday, March 3rd, from 11am-2pm at the Woodberry Kitchen, 2010 Clipper Mill Road, Suite 126, Baltimore, Maryland, 21211.

Registration is required.  Register HERE.

If you are unable to join us in Baltimore, Frank will deliver similar content in a webinar on Friday, March 11, 2016.  Registration for the session, to be held between 11am and noon, EST, is HERE.

Please note:  registration is required for both sessions as space is limited.  If you are a mainframe systems programmer or database administrator this is *not* the session for you (you should already know this stuff!)

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 Frank Fillmore 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 Frank Fillmore 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!

IDAA Administration Class September 16th-18th

Posted by Frank Fillmore on August 11, 2014 under Authorized Training Partner, Data Studio, DB2 Education, DB2 for z/OS, DB2 Gold Consultants, Frank Fillmore, IDAA. Tags: , , .

Based on feedback received from System z customers implementing the IDAA, DB2 Gold Consultant Frank C. Fillmore, Jr., will deliver a new course, IBM DB2 Analytics Accelerator (IDAA) Administration, beginning Tuesday, September 16, 2014, in our classroom in Towson, Maryland, just north of Baltimore.  This 3-day, hands-on course will provide an overview of the IDAA along with instruction and examples of best practices for IDAA administration.  This course is intended for System z users supporting the IDAA in production environments and covers query processing, loading data, distribution and clustering within the accelerator, and the IDAA tools ecosystem.  Click HERE for the complete course outline.

The cost of the course is $2100 per student.  Reserve a seat by contacting me, Kim May, to make payment arrangements.  Information on travel to Baltimore is available in our class Welcome Packet.  If you are a baseball fan, let me know if you would like to attend the Baltimore Orioles vs. the Toronto Blue Jays game either Tuesday the 16th or Wednesday the 17th – the O’s are hot!

Services – Available Help for the “tions”

Posted by Frank Fillmore on May 30, 2014 under Authorized Training Partner, Big Data, Data Studio, DB2 Connect, DB2 Education, DB2 for i, DB2 for Linux Unix Windows, DB2 for VSE&VM, DB2 for z/OS, DB2 Gold Consultants, DB2 Migrations, Federation, Frank Fillmore, Hadoop, IBM Champion, IBM DB2 Services, IBM Pure Systems, IDAA, InfoSphere, InfoSphere Streams, MQT's, Netezza, Optim, Oracle, pureScale, Q-Replication, SQL Tuning, TFG Blog. Tags: , , , , , , , , , , , , , , , , , .

I was on a call this morning with an IBM technical team to discuss our progress filling the seats in one of our upcoming free IDAA classes.  Not surprising, given the number of people on the call (and who they were!) we went a bit off topic and ended up chatting about services and what appears to be – to IBM customers and sellers at least – a shortage of skilled consultants available to help with the “tions” – replication, implementations, migrations and federation.

The Fillmore Group has skilled consultants available to support these efforts, at rates that are typically about half of those being charged by “the competition”.

If your team has a project pending, or one in process, where a skilled consultant, at a reasonable hourly rate, can get things back on track, please contact me.  We are ready to work!  A list of our IBM Information Management capabilities is attached here.

 

Finding System z Talent

Posted by Frank Fillmore on May 16, 2014 under DB2 Education, DB2 for z/OS, TFG Blog. Tags: , , .

The Fillmore Group has, at least in our opinion, access to some of the best DB2 for z/OS consulting and staff augmentation talent in the world.  Need help?  Email me!

However, as we heard recently from two successful mainframe customers at a class in Baltimore, finding young IT professionals interested in mainframe-centric careers is really tough.  Add to this the challenges in the world of IBM training, and the convergence of the aging z technical teams with the lack of young, skilled talent, and this becomes another factor jeopardizing long-term prospects for the IBM mainframe.

IBM has been trying to address the problem by enabling colleges and universities around the world to use IBM curriculum and remote labs to teach mainframe technology courses.

I spoke recently with IBM’s Don Resnik, who runs the IBM Academic Initiative, and Don re-introduced me to the program and shared some terrific resources.  As it turns out, there are three schools on the East Coast offering a mainframe track:  Radford in Virginia, and Syracuse and Marist in NY.

This week many colleges are holding graduation ceremonies.  If your organization would like to invest in the future of the mainframe, I recommend you spend a few minutes reviewing the information in the Academic Initiative website as well as the website where many students have posted their resumes, and where you can post job openings, www.systemzjobs.com.

As the parent of a college student anxious about his post graduation job prospects, I encourage everyone working with the mainframe to consider hiring a recent grad.  It’s a win-win.