Q Replication: Frank’s Field Notes – Follow-ups

Posted by Kim May on July 28, 2016 under Arrow ECS, Authorized Training Partner, DB2 for Linux Unix Windows, DB2 for z/OS, DB2 Gold Consultants, Federation, Frank Fillmore, IBM DB2 Services, Oracle, Q-Replication, TFG Blog.

Thanks again to everyone who joined us this morning for Frank’s presentation.  The recording and presentation files will be added in our next post.

In this post I am happy (thrilled!) to announce the Q Replication training class discussed on the webinar – the four-day, instructor-led session CE243G, “Using Queue Replication” has been posted on both the IBM and Arrow ECS websites and is therefore ready to accept registrations.  Please join us if you are interested, either in our Baltimore classroom, or via distance learning.  The class will run for four days, Tuesday – Friday, August 23-26.  Register here.

Special thanks to Megan Byrne, who helped get the class reinstated – it hasn’t run publicly for over three years – and is back on the schedule.

As a special incentive to anyone interested in attending the class in our Baltimore classroom, if you are interested in joining us for the Baltimore Orioles vs. the Washington Nationals game Tuesday night (after the first day of class), please let me know.  At The Fillmore Group we are all great O’s fans and they are, after all, in first place!

Finally, as one of today’s topics was the Oracle Native Apply now available for Q Replication, I am attaching a flyer with our Quickstart services offering to assist current Q Replication customers to transition from using Federation Server to the Oracle Native Apply.  Hope it helps!

Oracle Native Apply Quickstart 7.28.16

Thanks again for your help Megan!  Go O’s!

Megan at O's game

 

IBM Q Replication: Frank’s Field Notes, Summer ‘16

Posted by Kim May on June 21, 2016 under DB2 Education, DB2 for Linux Unix Windows, DB2 for z/OS, DB2 Gold Consultants, DB2 Migrations, Frank Fillmore, IBM Champion, IBM DB2 Services, IBM Information Management Software Sales, IDAA, InfoSphere, Netezza, Oracle, Q-Replication, TFG Blog.

Please join us Thursday, July 28th, from 11am-12pm EDT for a free webinar with an update on IBM’s Q Replication.

Having worked with Q Replication customers since 2006, DB2 Gold Consultant and IBM Champion Frank Fillmore has collected useful tips and techniques for Q Replication implementation and administration. Join Frank as he shares his notes and thoughts on the topics below and delivers a mid-2016 checkpoint on the evolving IBM InfoSphere Data Replication (IIDR) product development roadmap.

In this session Frank will cover the topics below.  Please register for the session here.

  1. Cold Start a Q Replication topology.
    1. When and why would you need to consider a Cold Start.
    2. What are the steps?
  2. Oracle Native Q Apply – replication directly to an Oracle database (including RAC and Exadata).
    1. Comparison to Federated Apply.
    2. Co-existence and migration.
  3. Tooling – what tool do I use when?
    1. Q Replication Dashboard.
    2. ASNMON.
    3. Replication Center.
    4. ASNCLP.
  4. ASNCONSUMER – used to replicate to PureData System for Analytics (Netezza).
  5. Pricing models.

About Frank Fillmore:

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 database-oriented 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 29 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.

 

 

*FREE* IBM DB2 Analytics Accelerator (IDAA) Hands-on Training

Posted by Kim May on April 26, 2016 under Authorized Training Partner, DB2 Education, DB2 for z/OS, DB2 Gold Consultants, Frank Fillmore, HTAP, IBM Champion, IBM DB2 Services, IBM Information Management Software Sales, IBM Smart Analytics System, IDAA, Mako, Netezza, TFG Blog.

DB2 Gold Consultant Frank Fillmore will deliver a free, hands-on IBM DB2 Analytics Accelerator (IDAA) class at the IBM offices in Chicago at 71 South Wacker Drive on Monday and Tuesday, June 6th and 7th.  The course outline and registration link are HERE.   The Welcome Packet with travel and lodging recommendations will be sent once the registration is accepted.

Class is free, however students are responsible for their own travel and lodging expenses.  The Fillmore Group will provide breakfast and lunch each day to students in class.

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 offered exclusively to IBM z Systems customers considering an IDAA purchase.  Registration is required.

I hope you will join us and learn more about the IDAA! If you have any questions on the class, please feel free to contact me at kim.may@thefillmoregroup.com.

DB2 101 Event – 8 Seats Still Available!

Posted by Kim May on April 8, 2016 under Big Data, BLU Acceleration, DB2 Connect, DB2 Education, DB2 for Linux Unix Windows, DB2 for z/OS, DB2 Gold Consultants, Federation, Frank Fillmore, Hadoop, HTAP, IBM Champion, IBM DB2 Services, IBM Information Management Software Sales, IBM Mid Market Customers, IBM Pure Systems, IDAA, InfoSphere, Mako, Netezza, Optim, pureScale, Q-Replication, TFG Blog.

Frank and I attended an IBM Business Partner event in Philadelphia earlier this week where we met with several IBM’ers supporting Business Partner initiatives in 2016.  Each of the specialists presented their “best of” solutions to the partners in attendance, and then patiently answered our many questions (mostly mine – sorry team!)

The final preparations for our Woodberry Kitchen lunch event are underway:   Frank and I are polishing the presentation, IBM’s Andrew Levine and Warren Heising are tracking down answers to my Cloud deployment “what if?” questions, Megan is gathering gold coins for attendees who ask Frank good technical questions, and Jolanta at Woodberry Kitchen has me salivating with her menu recommendations.

If you will be in Baltimore April 21st and haven’t registered yet, please do!  Register HERE.

DB2 101 – IBM Data Management Portfolio 2016 – Woodberry Kitchen Luncheon

Posted by Kim May on March 10, 2016 under BLU Acceleration, DB2 Education, DB2 for Linux Unix Windows, DB2 for z/OS, DB2 Gold Consultants, DB2 Migrations, DB2 Stars, Frank Fillmore, HTAP, IBM Champion, IBM DB2 Services, IBM Information Management Software Sales, IBM Pure Systems, IDAA, InfoSphere, InfoSphere Streams, Mako, Netezza, Oracle, pureScale, Q-Replication, TFG Blog.

For Baltimore and Mid-Atlantic area data management customers, The Fillmore Group is excited to announce a “DB2 101” luncheon event at award-winning Woodberry Kitchen in Baltimore on Thursday, April 21, 2016, from 11am – 2pm.

Join DB2 Gold Consultant Frank C. Fillmore, Jr., for a delicious lunch and a sprint through the IBM Analytics 2016 data management solutions portfolio.   Whether you are a long-time IBM customer or are considering your first IBM product purchase, Frank’s presentation will deliver the latest on today’s hottest technology topics – HTAP, Big Data/Hadoop and Cloud – and the specific solutions IBM has built, acquired and integrated to enable customers to meet their data management goals.

Is this, “the more things change the more they stay the same”, or an inflection point for data technology? You be the judge!

Frank’s overview will include IBM’s DB2 core databases, InfoSphere data integration solutions, Hybrid Transaction / Analytics Processing (HTAP), Big Data/Hadoop and Cloud offerings, as well as his 2016 best product recommendations and resources to help you learn more and evaluate these solutions.

Lunch and valet parking will be provided free of charge by The Fillmore Group.  Registration is required as seating is limited.  Register HERE.

If you have any questions or dietary restrictions please contact Kim May at kim.may@thefillmoregroup.com.  I hope we will see you at Woodberry!

DB2 101 Woodverry Kitchen 003

 

IDUG, DB2-L and Charming Developers

Posted by Kim May on February 29, 2016 under BLU Acceleration, DB2 for z/OS, HTAP, IBM DB2 Services, IDAA, Oracle, TFG Blog.

There was some discussion on DB2-L this past week, not about “charming developers” (as in, “gee, that developer sure is charming!”), but about how the DB2 community can encourage developers to use the IDUG listserv as a resource for application coding questions.  Because, there are many extraordinary technical people monitoring the list.  And yes, many can also be quite charming to new listserv users!

Right now I see the division between DB2 users and their organizational colleagues growing as System z workloads are being restricted by cost and security concerns.  Quite frequently there appears to be very little communication between DBA’s and developers within organizations.  With larger organizations bringing teams of data scientists on board, many of whom are unfamiliar with the mainframe, the divide further broadens, as the data scientists view developers as their allies.

With the introduction of Hybrid Transaction/Analytical Processing (HTAP), the ability to run OLTP and Analytics together should be bringing data warehouse applications back to the mainframe.  The new data scientists, and their application developer colleagues, will need their DBA colleagues to help.  I hope DB2-L is one of the resources that makes the transition for everyone easier.

Steve Mills, #IBM EVP Retires

Posted by Frank Fillmore on January 8, 2016 under BigInsights, BLU Acceleration, DB2 for Linux Unix Windows, DB2 for VSE&VM, DB2 for z/OS, DB2 Gold Consultants, IBM DB2 Services, IBM Information Management Software Sales, IBM Smart Analytics System, IDAA, Informix, InfoSphere, InfoSphere Streams, pureScale. Tags: .

I only spoke with Steve Mills a couple of times and attended presentations he delivered at conferences a few others, but he has had an enormous impact on my career.  Steve was the executive sponsor of the DB2 Gold Consultants program, of which I have been a member since 1998.  Steve recognized that specialized, deep technical skills were imperative to enabling the adoption and successful deployment of IBM’s world-class, function-rich – but let’s face it: enormously complex – information technologies.  Through the DB2 Gold Consultants program, Steve cultivated a cadre that were not only among the best DB2 practitioners, but foremost in the world in relational database technology in general.  Folks like Richard Yevich, Bonnie Baker, Frank Ingrassia, Terry Purcell, Jan Henderyckx, and Gerry Hodge.  I am humbled to be numbered among them.

For years IBM would sponsor a week-long DB2 Gold Consultants conference, usually at Silicon Valley or Toronto Lab.  Dozens of presenters including IBM Fellows like Pat Selinger, Don Haderle, Don Chamberlin, Hamid Pirahesh, and Curt Cotner would tell us about broad industry trends and specifics regarding features and functions in vNext, vNext+, and vNext++.  It was an amazing feast of insight which enabled me to better serve my clients.  None of that would have happened without Steve’s leadership.

An even more critical and direct aspect of Steve’s support was his sponsorship of contracting vehicles for DB2 Gold Consultants which enabled us to engage directly with IBM without having to add additional layers of third-part procurement.  He understood the practical problem of small businesses and sole practitioners trying to navigate a large, cumbersome bureaucracy.  One time I explained to Steve that even with the contracting vehicle in place, IBM buyers occasionally refused to use it.  His response was “Sometimes the inmates are running the asylum”.  I didn’t hear anything for a couple of weeks and then I received a call from a senior IBM procurement officer who introduced himself by saying: “Hi, I’m one of the ‘inmates'”.  Of course, the problem was resolved.

Steve Mills, the quintessential old-school “wild duck” IBMer, will be missed.

Looking Toward 2016 – TFG Events Schedule

Posted by Kim May on December 18, 2015 under #IBMInsight, Authorized Training Partner, Baltimore Washington DB2 Users Group, DB2 Education, DB2 for z/OS, DB2 Gold Consultants, Frank Fillmore, IBM DB2 Services, IBM Information Management Software Sales, IDAA, International DB2 Users Group (IDUG), Q-Replication, TFG Blog.

Fillmore 2016 Scheduled Marketing Events

The Fillmore Group had a terrific 2015 thanks to our great customers and terrific consulting team.  We are looking forward to an exciting 2016, with some key focus areas already “in the works” and of course plans to remain as competitive and flexible as possible so that we can continue offering top quality technical education and consulting at competitive prices, along with helpful, knowledgeable IBM Analytics software purchase assistance.

Our 2016 schedule contains some annual highlights:  IDUG (in Austin this year; should be great!), the IBM Insight Conference in October and four quarterly meetings of the Baltimore/Washington DB2 Users Group, our local RUG.

In addition we are planning a 4-part webinar series to support customers working to keep System z thriving and growing in their organizations, another free, hands-on IDAA class, and assistance with getting a college or university in the Baltimore/Washington area to work with the IBM Academic Initiative team.

Happy Holidays!  2016 is coming up fast!!

Frank to Present on HTAP at Philadelphia System z Meeting

Posted by Kim May on August 21, 2015 under BLU Acceleration, DB2 Education, DB2 for z/OS, DB2 Gold Consultants, Frank Fillmore, IBM Champion, IBM DB2 Services, IBM Information Management Software Sales, IDAA, Netezza, TFG Blog.

Frank will be presenting, “Hybrid Transaction Processing” at the new Philadelphia System z group meeting at Maggiano’s Little Italy, located at 205 Mall Boulevard, King of Prussia, Pennsylvania, 19406, on Friday, September 18th.  Frank’s presentation will run from 10:45am – 11:45am, after which lunch will be served.

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 now these technologies differ, including their relative strengths and weaknesses.

Also on the schedule to present are Bill Shipley, Senior DBA from Vanguard, discussing his experience facilitating analytics with both System z and the IDAA,  Mark Anzani, IBM Vice President of IBM z Systems Strategy and Montgomery Bauman, IBM Technical Specialist for z Systems.

The event runs from 9:00am to 2:45pm, and is being sponsored by IBM.  Register to attend at:  https://ibm.biz/zPhillyUserGroup

 

 

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!