Articles & Content
The Fillmore Group was founded by IBM DB2 Gold Consultant Frank C. Fillmore, Jr.
Note: The content of this blog is the opinion and thoughts of the blogger and does not necessarily represent the opinions of IDUG.
QMF Analytics for Multiplatforms – September Baltimore/Washington DB2 Users GroupFrank Fillmore just finished delivering a webcast with IBM's Steve Mink and Doug Anderson, hosted by Blanca Borden, on the just-released QMF Analytics for Multiplatforms solution. For the many QMF for z users, this new GUI-based solution offers the opportunity to extend the use of the objects, forms, queries, etc., an organization has developed over the years. The session was recorded and I will post the recording link as soon as it's available to view. For the September 13th Baltimore/Washington Db2 Users Group Frank will reprise his presentation and deliver a demo on QMF Analytics for Multiplatforms. The meeting is being sponsored by SEGUS and will include 4 presentations -- 2 from SEGUS's Ulf Heinrich and 1 from IBM's John Iczkovits in addition to Frank's. Summary session abstracts are below. Complete abstracts, speaker bio's and registration information will be available later this week on the Baltimore/Washington DB2 Users Group website (www.bwdb2ug.org). I hope you will join us if you are in the area! Session 1: Ulf Heinrich -- Compliance with Compliments! Viable Db2 Workload Tracking Audit and Compliance is one of the big challenges companies are facing these days. This presentation shows how the entire DB2 workload can be tracked without the overhead of a trace, or monitor, enabling to answer Who did What When ? whenever needed. Session 2: Ulf Heinrich -- Db2 12 Continuous Delivery Starting with version 12 Db2 goes agile and code fixes, as well as new features and functions, will be delivered in a continuous stream, so called Continuous Delivery. While this change intends to make new technology available faster than in a three-year cycle it will also differ from how we did DB2 migration and testing before. This presentation provides an overview about Db2 Levels and how they affect the Db2 subsystem, the Catalog/Directory, SQL and DDL. More importantly, you will see how changes can be applied safely and what levels of quality assurance and testing can be passed to assure Continuous Delivery goes well with Continuous Availability. Session 3: John Iczkovits -- DB2 for z/OS is in The Cloud! Using z/OSMF to Install, Migrate, and Provision DB2 These are exciting times and you may not realize it, but Db2 for z/OS is in the cloud! You may be thinking, what exactly does that mean? Many of your z/OS colleagues are already using z/OSMF for all sorts of functions. Come learn how to use z/OSMF to manage Db2 software, install, migrate, and provision data for Db2 and what the cloud means to us. Session 4: Frank Fillmore -- QMF Analytics for Multiplatforms In July, QMF Analytics for Multiplatforms became generally available. Like QMF for z/OS, this solution delivers QMF’s visualization, dash boarding and graphical ad-hoc query capabilities, and enables users to leverage their existing QMF assets – queries, forms, procs from legacy QMF. In this session Frank Fillmore will provide an overview of the features of QMF Analytics for Multiplatforms and perform a demonstration that includes new updates to QMF’s data visualization interface.
Webcast: Introducing QMF Analytics for MultiplatformsQMF is bringing its power and ease to the distributed platforms! In July QMF Analytics for Multiplatforms became generally available. This distributed platform only solution is aimed at customers that had inquired about QMF’s visualization, dashboarding and graphical ad-hoc query capabilities on non-z/OS platforms. Join us in this webcast where Frank Fillmore will highlight how QMF Analytics for Multiplatforms is being used by one of his customers to modernize their operations. We also will discuss in more detail the features of QMF Analytics for Multiplatforms and will conclude with a demonstration by Doug Anderson that will include the new updates to QMF’s data visualization interface. Date: August 16th, 2017 Time: 8:00am PDT / 11:00am EDT Register at: http://ibm.biz/QMFforMP
IBM Reinvents Partnerworld – Ravages the Partner EcosystemI just received an email from IBM's Partnerworld program notifying me that as of August 1, 2017, The Fillmore Group, after ten years as a Premier IBM Business Partner (the highest program level), is now officially a Registered Business Partner, the lowest level in the program. We still have a team of expert consultants. We are still authorized to deliver most IBM courses in the Analytics brand family curriculum. We are still actively promoting, influencing and reselling IBM Analytics solutions. I am still Chair of the Baltimore/Washington DB2 Users Group and an IBM Champion. Frank is still a Gold Consultant. Several of our consultants are IBM Champions and Golds. IBM simply won't programmatically acknowledge that our skills have value any longer. IBM claims to value partners with skills, but by they are lying. The truth is the two factors determining partner level in the new Partnerworld system are software sales and customer references. Is it a coincidence that IBM is struggling with sales (21 straight quarters of declining revenues) and the company has historically been terrible at getting customer references? Sadly, great technology followed by poor quality and expensive implementations and enablement support don't add up to gushy customer success stories. In the new program, without sales of $1,000,000 or more in a single product family a Business Partner cannot be granted a product "Competency" designation -- no matter how many times they have implemented a solution, how many customers they have trained, and/or how many presentations and webinars they have delivered to help current and prospective customers understand the value of IBM's solutions. In the new IBM world, that's not "competency". So like many of IBM's "reinvention" efforts over the past five years, the "new" Partnerworld program is essentially the same old program, with new, onerous requirements designed to eliminate specialty partners (like The Fillmore Group) and I suppose reduce IBM's burden of managing their partner network. Because like who needs an extensive network of partners promoting an incredibly complex portfolio of products and solutions?? Heck, why not just funnel business to a handful of partner organizations and keep things simple. Maybe reduce channel support headcount by 10 or 15 people. Woohoo. Think small. After I received the email notifying me of our program level demotion I tried to log in to Partnerworld to review the program offerings for our new, low level. And like so many things in today's IBM world, the response was sad, heartbreaking and terribly frustrating -- apparently they can't keep the program website up. Need a high availability solution???
Tealeaf FatigueI have been reviewing our first half of 2017 and trying to get a handle on where our DB2 world is headed in the second half of this confusing year. Frankly, I'm baffled! While the year started on a positive note with IBM's acknowledgement that they needed to re-engage and support their existing DB2 customers, and the positive trend continued with the announcement of the super-aggressive DB2 pricing available via the Oracle Attack, I still find that at mid-year the good outcomes I expected are failing to materialize. How come? In my opinion, one reason is a result of IBM's "re-invention" of their Business Partner program. As a long-time IBM Business Partner, our team invests an incredible amount of time and energy maintaining our "Premier Partner" status, primarily through certifications that validate our skills. When IBM rolled out the new partner program in 2017 their messaging indicated a new focus on highly-skilled, knowledgeable partners. Unfortunately, in reality, the program modifications boiled down to two new criteria: 1) customer references and 2) meeting high volume IBM software sales targets. To IBM, these make perfect sense: IBM struggles to get customer references, and with rolling sales staff reductions, IBM needs to beef up their sales partners. However, the "Give it to Mikey, he'll eat anything" approach may not be working. Partners like The Fillmore Group are being marginalized ("Skills? Who needs 'em?") by the program, while high volume partners (like HP, oh, oops, not any more) are being funneled territories, "uncovered" customers and leads. In my opinion, the fallout is likely to be similar to the Global Skills Initiative, IBM's education program "re-invention" from a few years ago that resulted in far fewer DB2 classes and fewer available training options as the program created a layer of 5 large, competing training partners who function independently and whose lack of coordination splintered the IBM training business. Is this what IBM is -- unintentionally/intentionally? -- planning for their partner community? I don't know, but it's unsettling. One bright note: the new partner levels were scheduled to go into effect June 30th, but have been pushed back to the end of July. Perhaps sanity prevails?? My final head scratcher is the annual IOD/Insight/World of Watson/no, not this year conference. I received an email this morning about the LearnQuest-sponsored Analytics conference scheduled for New Orleans in October. I've also heard about a DB2 Conference being planned for Boston in -- October, as well. On one hand I think any conference and opportunity to network is good. On the other hand, I am wondering if the conflict is quietly announcing the final split between DB2 for z/OS and DB2 for LUW. Or I suppose that should be (another brilliant re-invention), Db2 for z/OS and Db2 for LUW...!!
The Fillmore Group – Another Migration Success!I am pleased to report a team of four consultants from The Fillmore Group, a team with over 100 years of combined DB2 experience, recently completed a successful migration of the courts system database at Lake County, Illinois. The migration was spurred by an all-too-familiar challenge: retirement announcements by three long-time, key technical personnel and a recognized need to modernize their database to enable potential use of Commercial-Off-The-Shelf (COTS) application software. The entire project, including new DB2 for z/Linux (LUW) DBA training, re-integration of several archived databases and migration of the customer’s extensive library of QMF reports, was estimated at 18 months and completed in 9. Under Frank Fillmore’s direction, the team utilized resources as needed: part-time and full-time, remote and at the customer site. The production cutover Memorial Day weekend went smoothly. Lake County’s court system database is now running DB2 V11.1 on an Integrated Facility for z/Linux (IFL) on their IBM z Systems BC12. Their DB2 software license costs were under $10K. Most importantly, they are now prepared to begin evaluating application modernization options. Congratulations to Suresh, Roger, Jim and Frank. If your team is looking for migration support, please contact me. These DB2 experts like to keep busy!
$5!! – June 14th Balto/Wash DB2 Users Group MeetingThe Baltimore/Washington DB2 Users Group has been supporting the local DB2 community for 25 successful years. Our quarterly meetings are packed with interesting, relevant information about how to best leverage DB2. Many of the region's largest businesses and agencies regularly attend our meetings and benefit from the presentations and networking opportunities as some of the most highly skilled developers and database administrators in the Mid-Atlantic are frequent attendees. At our April board meeting we decided to do something special for the June meeting. We agreed to offer a special, discounted $5 registration fee to attendees who pre-register, rather than our usual $30 -- $50 (see the information below – details and registration information are included in it). The $5 includes everything our users expect at our quarterly meetings: terrific presenters (we have Jeff Josten presenting), a sit down lunch and the opportunity to meet with many of the best DB2 technical people in the region. We are hoping this *almost free* offer will encourage new DB2 users and people who haven't been able to attend meetings recently to join us. If you are in the area June 14th I hope you will join us. If you can't be here, please share this invitation with any of your colleagues or customers who may be interested. Please note: you must register by Friday, June 9th, on the Baltimore/Washington DB2 Users Group website (www.bwdb2ug.org) to receive the $5 discounted registration. Don't forget!! Date: Wednesday, June 14th, 2017 Time: 9:00 AM -- 3:30 PM (registration at 8:30) Location: Sheraton Columbia Hotel, 10207 Wincopin Circle, Columbia, MD 21044 Meeting Schedule: Registration 8:30 -- 9:00 DB2 12 for z/OS and Beyond Jeff Josten IBM This presentation gives a high level overview of DB2 12, and also some other interesting features which have shipped recently on DB2 11 (and sometimes DB2 10) including native DB2 RESTful services, DB2aaS cloud-style provisioning, and IDAA on Cloud. We will also take a peek into the future for what is planned beyond DB2 12. Coffee Break 10:15 -- 10:30 DB2 for z/OS Continuous Delivery Jeff Josten IBM DB2 for z/OS is moving to a continuous delivery model for shipping new features. The main objectives are to speed up delivery of important new functions and to make it easier for customers to manage DB2 upgrades. This presentation will give an overview of the continuous delivery mechanisms and suggested best practices for managing DB2 in this continuous delivery world. Lunch 11:45 -- 12:45 DB2 Autonomics Sowmya Kameswara IBM An overview of the no-charge product the Data Server Manager (DSM) and the new IBM DB2 Autonomics for z/OS. The DB2 Autonomics can help you in closing the gap between yesterday's IT implementation and tomorrow's IT demands while eliminating the mundane repetition of manual day-to-day tasks. DSM in a web browser is the weapon that can help your organization to fight the constant skills and resource gaps. Break 2:00 -- 2:15 API Economy Jeff Bisti IBM Microservices are a take on API Enablement that are quickly becoming a new standard in many customer shops. The goal is to avoid building the next generation of "monolithic" applications, and instead build functionality with modular web services, which can be repurposed by a wider variety of developers. Microservices can excel on the mainframe System of Record when they take advantage of where the platform itself excels. In this session, Jeff Bisti will present the benefits of thinking in terms of microservices, introduce some of the tools that are available to developers and architects, as well as the importance of an overall API strategy.
Oracle Renewal Looming? Consider DB2! @IBMAnalyticsThanks to my colleague, Kim May, for another wonderful job leading customers and IBMers through the rewards and challenges of converting Oracle databases to DB2. The recording of the latest webinar is found here. The presentation materials: Oracle Customers Consider DB2 5.16.17 Finally, The Fillmore Group’s White Paper on Oracle to DB2 migrations: SmarterQuestions White Paper -- Oracle to DB2 Migration Lessons Learned -- Final Please reach out to Kim or me if you have any questions.
IBM Announces Extended Support for DB2 for LUW V9.7 and 10.1I've been pondering what this announcement means all day...is IBM trying to become the most altruistic database software vendor? They are offering amazing software license discounts to customers moving workloads from Oracle to DB2 for LUW, and today announced a new extended support option for customers unable to meet the September 30th End of Support (EOS) date for both DB2 V9.7 and V10.1. Typically IBM pushes customers to migrate before the EOS date as it helps to keep the majority of customers being supported on a limited number of software versions. As everyone supporting software knows, simpler is better. On the flipside though, I've been wondering if this announcement is a veiled advertisement for a new, for-fee offering from IBM to generate services income? Yes, I can be as suspicious as anyone! If you find yourself in need of extended support and discover IBM is asking for a substantial fee and would like a second price option on support, please shoot me an email. We've offered DB2 customers similar support in the past, and we've also completed several migrations from V9.7 and V10.1 to V11.1 and can help you get to V11.1 before September 30th if that's the best option of all. Information on the IBM announcement and contact for obtaining a quote for the extended support is HERE. My contact info is HERE. Your call!
Another Oracle Attack Webinar? You Bet!With IBM's announcement this week of super-aggressive discounting being offered to current Oracle customers considering a move to DB2, and with the deadline looming for many Oracle customers faced with another year of bloated "investment" in Oracle support, we've decided to deliver updated material on the benefits of moving to DB2. Our upcoming webinar, "Oracle Renewal Looming? Consider DB2!" will be delivered on Tuesday, May 16th, from 11:30am to 12:30pm EDT. DB2 Gold Consultant Frank Fillmore will join me for the session, as will IBM's Tony Mancini, Worldwide Competitive Team Executive. Tony will give us a brief overview of IBM's recent announcement, and Frank and I will deliver a fast-paced, interactive 60-minute session that will (we hope!) provide current Oracle customers with an understanding of both the cost savings and incredible database functionality available with DB2. Please register HERE to join us!
Calling All IDAA Users!The next IBM-sponsored DB2 Analytics Accelerator Users’ Group meeting was announced this week. The Fillmore Group’s Frank Fillmore will be presenting one of the sessions, along with BNY/Mellon Pershing’s Al DiGiovanni, whose support and promotion of the IDAA enabled Pershing to acquire their first IDAA. Al and Frank will be presenting the meeting’s final session titled, “Increasing Utilization of the Accelerator by your Lines of Business”, a session whose topic has been a core issue for System z customers trying to persuade their colleagues to consider investing in the IDAA. As many technical teams promoting IDAA adoption have learned (the hard way!), most organizations adopted the circa-Y2K best practice of running OLTP and analytic workloads separately, and are therefore reluctant to re-integrate the two, in spite of the cost, latency and simplicity advantages. This session is designed to surface the issue and discuss options to address and overcome it. Information on the DAAUG meeting is below. Please be advised that membership in this group is limited to current IDAA customers and registration to attend is managed by IBM. If you own an IDAA and would like to attend, and have not received an email invitation from IBM, please email me (email@example.com) and I will connect you to the IBM team coordinating the meeting. I hope you will join us May 9th. Session Details “Increasing Utilization of the Accelerator by your Lines of Business” Frank Fillmore and Al DiGiovanni, BNY/Mellon Pershing The IDAA is a powerful tool for performing real-time analytics on z/OS transactional data. In many cases it is left to the managers of an enterprise’s mainframe to “sell” an IDAA to lines of business (LOBs). The audience for the sales pitch: CFOs, CTOs, Enterprise IT Architects, Data ScientistsThe objections: o existing infrastructure (ETL processes, enterprise data warehouses) o mainframe marginalization (“The mainframe is too expensive”; “The mainframe is not a strategic platform”)The advantages: o reduced complexity o reduced latency o cost savings (e.g. inexpensive data archiving of all System z data)New opportunities: o in-database transformation (i.e. AOTs for MicroStrategy) o in-database analytics (i.e. INZA-IDAA 22.214.171.124) o cloud deployment (Public/Private/Hybrid) o Machine Learning o R supportDB2 Analytics Accelerator Users’ Group (DAAUG) Meeting Date: Tuesday, May 9, 2017 Location: IBM Offices, NYC or via web conference Time: 9:30am – 2:00pm EDT During this meeting, Ute Baumbach, subject matter expert from the Analytics on z Systems Center of Excellence out of Boeblingen, Germany, will cover the most recently introduced Accelerator features, functions and fixes. Tim Willging, Distinguished Engineer, will discuss how you can expand your Accelerator use cases with new functionality in the Accelerator Loader Tool. Jonathan Sloan, Business Analytics Executive Consultant, will present ways the Accelerator complements IBM Machine Learning. Frank Fillmore, DB2 Gold Consultant of the Fillmore Group, and a customer presenter will share their successful experiences to help you promote the value of the Accelerator to your Lines of Business. We encourage you to join the meeting in person if you are local. Web Meeting details will be provided for remote attendees. Agenda: 09:30 – 10:00 Registration 10:00 – 10:15 Welcome 10:15 – 10:45 Developer's Update: DB2 Analytics Accelerator Features, Functions and Fixes 10:45 – 11:30 Expanding Accelerator use cases with new DB2 Analytics Accelerator Loader functionality 11:30 – 12:00 Lunch Break 12:00 – 01:00 Complementing IBM Machine Learning with the DB2 Analytics Accelerator 01:00 – 02:00 Increasing Utilization of the Accelerator by your Lines of Business